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

Reply via email to