[postgis-users] new user = new problems

[Bruce Rindahl]

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
>


-- 
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