[postgis-users] new user = new problems

[Carlos Ferrão]

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
>