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 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> wrote: From: Vinicius <vinicius...@gmail.com> Subject: [postgis-users] postgis from ubuntu to suse To: postgis-users@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