Thanks Nicklas, Maybe I did not expressed my questions very well. I already have a database with PostGIS enabled and I am working well with it. I installed PostGIS 1.3.6 in PostgreSQL as I mentioned using the App. Stack Builder. My problem is that now I want to check some PostGIS features as Reference systems because I need to measure distances etc.. As I'm reading the manuals, I learned about the existence of a SPATIAL_GEOMETRY_COLUMNS table (or example) that I didn't find in my installation nor in my customer installation. I used to see in another installation a database with the name "postgis" so I thought that maybe in that database (that I guess is a master database for PostGIS extension) I would find the tables that mention hte manuals. As I made a mistake in the original installation of PostGIS (didn't check the creation of "postgis" database) I want to reinstall it and this time check that option. How can I make this reinstallation and more important: can I do this without affecting my own PostGIS enabled database I already created in PosgreSQL? I certainly cannot update now to the last version of PostgreSQL and PostGIS because my customer use this configuration and I don't want to push them now to make these changes. Regards
On Wed, Jan 13, 2010 at 10:33 AM, Nicklas Avén <[email protected]>wrote: > Hallo Oscar > > You can spatially enable any database by loading and running > lwpostgis.sql > and > spatial_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\contrib > or 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 is > PostgreSQL 8.4.2 and PostGIS 1.4. Hopefully in a couple of weeks PostGIS > 1.5 will be released. > > Hope that helps > Nicklas > > > 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 > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
