[postgis-users] Postgis installation

[Nicklas Avén]

Hallo Oscar You can spatially enable any database by loading and running lwpostgis.sqlandspatial_ref_sys.sql for instance in pgAdmin I think that's the right name of the files for your version and you can find them in :C:\Program files\PostgreSQL\8.3\share\contribor something corresponing on your system.Probably you will have to remove the lines with "vacuum" in the spatial_ref_sys.sql before running. That issue shoud be fixed in upcoming PostGIS 1.5 But if you have the possibility you probably want to upgrade both database and postgis. Latest stable now isPostgreSQL 8.4.2 and PostGIS 1.4. Hopefully in a couple of weeks PostGIS 1.5 will be released. Hope that helpsNicklas

2010-01-13 Oscar Zamudio wrote:

Hi everybody. I'm a newbie and trying to use PostGIS with PostgreSQL in Windows. I installed PostgreSQL 8.3 and also PostGIS 1.3.6 using the Application Stack Builder. Spatial queries are working fine but I have some doubts about the PostGIS configuration. Where can I find the SPATIAL_REF_SYS Table for example, or the GEOMETRY_COLUMNS table? At the time I was installing the PostGIS extension I didn't check the creation of a postgis database. I guess postgis database contains the tables that I'm looking for. Am I wrong? >
I was thinking in reinstall the PostGIS 1.3.6 and create the postgis database but I don't know how, as the Application Stack Builder doesn't allow me to do that. Can anybody help me? Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100113/93ff6112/attachment.html>