[postgis-users] new user = new problems

Mike Leahy mgleahy at alumni.uwaterloo.ca
Wed May 24 10:12:02 PDT 2006


Bruce,

Is it 'postgres' now?  Maybe pgAdmin does it different (I usually use 
commandline tools), but I was pretty sure that 'template1' is still the 
default template...

Mike

Bruce Rindahl wrote:
> Matteo
> Do the same commands you did below on the default database (typically called
> postgres).  Then every new database you create via pgAdmin III should be a
> spatial one.
> Bruce Rindahl
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of matteo
> rossi
> Sent: Wednesday, May 24, 2006 9:57 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] new user = new problems
> 
> Dear Carlos,
> I did exactly what you just wrote but it didn't work.
> I installed postgres without the postgis extension as service.
> After that I installed postgis.
> But if I create a new database from pgAdmin III the db is NOT a spatial one.
> In order to "upgrade" it to a spatial one, I had to use the command 
> lines below
> 
> C:\Programmi\PostgreSQL\8.1\bin>psql -U postgres -d db_prova -f 
> ../share/contrib/lwpostgis.sql
> C:\Programmi\PostgreSQL\8.1\bin>psql -U postgres -d db_prova -f 
> ../share/contrib/apatial_ref_sys.sql
> 
> Now I have a spatial database but this kind of procedure seeems to be 
> not so "user friendly" as I read on the manual! :-)
> 
> buona giornata anche a te!
> Matteo
> 
> Carlos Ferrão wrote:
> 
>> Ciao Matteo,
>> If you're using windows XP you don't really need to use psql.
>> First install postgres. Disable the postgis spatial extension. Install
>> postgres as a service and initialize a db cluster.
>> After that, install postGIS. In the installation procedure you can
>> create a database which will be spatially enabled.
>> For further operations on the database (create schema, etc.) you can
>> use the application pgAdmin III which is much visually rich and
>> powerful than the command line psql.
>>
>> Siamo vicini, sono anche in Roma.
>> Buona giornata,
>> Carlos.
>>
>>
>> On 5/24/06, matteo rossi <matteo.rossi at uniroma1.it> wrote:
>>
>>> Hi,
>>> I recently installed postgre 8.1 with postgis 1.1.2-1 for windows xp.
>>> I experienced many problems in following the steps suggested into the
>>> postgis manual uploaded in postgis site, especially about importing
>>> shapefiles, as it should concern other version than mine.
>>> The first problem if when I use the psql, the database created is NOT a
>>> spatial database but a simple postgres one.
>>> How I can transform it in a spatial one?
>>> How can I directly create a spatial database?
>>> I tried with
>>>
>>> |psql -d yourtestdatabase -f lwpostgis.sql
>>> psql -d yourtestdatabase -f spatial_ref_sys.sql
>>>
>>> but the "psql" command and the *.sql files are not under the same
>>> directory, so the shell don't recognize them.
>>>
>>> Can anyone help me?
>>>
>>> Thanks a lot
>>>
>>> matteo rossi
>>>
>>>
>>> |
>>>
>>> -- 
>>> Dott.Ing. Matteo Rossi
>>> Phd in Environmental Engineering
>>> Dept. Hydraulics, Transportations and Roads
>>> Faculty of Engineering
>>> University "La Sapienza" of Rome
>>>
>>> tel: +39 0644585024
>>> fax: +39 0644585016
>>> mailto: matteo.rossi at uniroma1.it
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> 
> 



More information about the postgis-users mailing list