I'm trying to get postgis running on my machine. Running brew install postgis seems to have installed postgres 9.2.1 on to my machine. I would like to remove my previous version 9.1.2 to keep my environment clean.
Running brew uninstall postgres removes 9.2.1.
What's the best way to do this?
The new version of PostGIS 1.2.0 already released. This new version fix many bugs and performance improvements of the previous PostGIS. You can download this PostGIS 1.2.0 from the link provided below this post.
PostGIS Publisher Description:
PostGIS adds support for geographic objects to the PostgreSQL object-relational database.
This appears to be very messy, so I would like to remove all trace of PostgreSQL on my system. I followed various instructions found on the web, but to no avail. After that, what's the best way to install 9.1?
I'm setting up my own postgres database to use with a heroku app (I don't wanna pay $200 a month just to have postgis, I don't need a huge database or anything, just postgis).
The command
psql -d template_postgis2 -f /usr/share/postgresql/9.1/contrib/postgis-2.1/postgis.sql
returns a list of errors that is too long to be displayed by scrolling up to the beginning of the error.
I tried the same command with "| more" and "| less" added up at the end of the command but it does not display the message page by page as it should.
Help! I am trying to connect to a Postgres database and can't get the server to connect. When I execute this php script:
$conn = pg_connect("dbname=wikimap user=postgres password=postgis host=localhost port=54321";
if (!$conn) {
echo "Not connected : " .
I have installed Postgres 9.1.4 on an Ubuntu 12.04 (precise) 64-bit from here http://www.openscg.com/se/postgresql/packages.jsp, but right after installing many commands (programs) are throwing these following warnings in different combinations:
/opt/postgres/9.1/lib/libxml2.so.2: no version information available
/opt/postgres/9.1/lib/libcrypto.so.1.0.0: no version information available
/opt/pos
TO make a database backup in postgreslq server you use pg_dump and psql commands.
First, locate the database:
# psql -l --username postgres --password
Then:
# pg_dump --username postgres name_db --file /dir/dir/backup.sql
To restore the database:
First create database with its respective name and roles:
# psql postgres
# postgres=# CREATE DATABASE name_db ENCODING 'UTF-8';
# postgres=# CREATE ROLE
I am using PostgreSQL 9.0. I've installed osm2pgsql package from Debian repositories and now I have two versions of postgres databse installed on my machine (9.0 and 9.1 - installed with osm2pgsql). How can I configure osm2pgsql and postgis to work with 9.0 database?
Email this page
