I agree with Brent here that it works nicely for me as well to pg_dump
<src db params> | psql <target db params>
Just a word of caution that you may want to make sure that your pg_dump
excludes any PostGIS installation, especially if you are changing
versions. Otherwise, you are going to overwrite your new installation
with old PostGIS function definitions and confusion will abound.
Typically PostGIS is installed in the public schema, so I usually do
this which excludes the public schema from the dump:
pg_dump -N public <other args> <dbname> | psql <options>
Eventually, I would love to see PostGIS installed in it's own schema
which is treated by PostgreSQL like any other system schema
(information_schema, pg_catalog) and automatically excluded from
pg_dump. But for now, manual exclusion works.
Cheers,
Kevin
On 12/7/2010 12:18 PM, pcr...@pcreso.com wrote:
Hi Vinicius,
If SuSE created a Postgis enabled template, you could use that as the
basis for your new database, so it will already have Postgis installed.
Otherwise use the usual commands to install Postgis in a Postgres
database:
createlang plpgsql <new db> (not needed with Postgres v9.0+)
psql -d <new db> -f <path to>/postgis.sql
psql -d <new db> -f <path to>/spatial_reference_sys.sql
You'll need to find where SuSE has put the last two files, if you have
"locate" installed, then
"locate postgis.sql" will tell you where, or you can use "find"...
According to
http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS#For_Opensuse_11_2
the path is /usr/share/postgresql/contrib/
Cheers,
Brent Wood
--- On *Wed, 12/8/10, Vinicius /<vinicius...@gmail.com>/* wrote:
From: Vinicius <vinicius...@gmail.com>
Subject: Re: [postgis-users] postgis from ubuntu to suse
To: pcr...@pcreso.com
Cc: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net>
Date: Wednesday, December 8, 2010, 4:58 AM
Hi..
I created the database manually, but how do I install postgis into
this database ?
I´ve used Software Management to install postgresql and postgis,
but when I create a new database it´s completelly empty.
tks..
On 06/12/2010 20:00, pcr...@pcreso.com
</mc/compose?to=pcr...@pcreso.com> wrote:
Which version of PostGIS is on each box?
One q'n'd approach which works for me is to create the target db
manually, install Postgis into this manually, then use pg_dump
<src db params> | psql <target db params>
Brent Wood
--- On *Tue, 12/7/10, Vinicius /<vinicius...@gmail.com>
</mc/compose?to=vinicius...@gmail.com>/* wrote:
From: Vinicius <vinicius...@gmail.com>
</mc/compose?to=vinicius...@gmail.com>
Subject: [postgis-users] postgis from ubuntu to suse
To: postgis-users@postgis.refractions.net
</mc/compose?to=postgis-us...@postgis.refractions.net>
Date: Tuesday, December 7, 2010, 8:27 AM
Hi people..
I´ve had some problems to restore a database backup from
postgresql 8.3 on Ubuntu to postgresql 8.4 on OpenSuse 11.3.
I have many tables and indexes using postgis, but when I try
to restore them on OpenSuse many errors about libs occurs.
How Can I solve this problem, it is possible ?
tks...
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
