[postgis-users] new user = new problems

[matteo rossi]

Mike,
I did exactly what you wrote.
But I'd like to understand why the database I create on postgis are not 
directly Spatial Database....

thanks
Matteo

Mike Leahy wrote:

> Matteo,
>
> Try putting a full or relative path to the sql files like this:
>
> psql -d yourtestdatabase -f ../share/contrib/lwpostgis.sql
> psql -d yourtestdatabase -f ../share/contrib/spatial_ref_sys.sql
>
> Regards,
> Mike
>
> matteo rossi 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
>>
>>
>> |
>>
> _______________________________________________
> 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