Thanks Nicklas,<div>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. </div>
<div>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. </div>
<div>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? </div>
<div>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.</div><div>Regards<br><br><div class="gmail_quote">
On Wed, Jan 13, 2010 at 10:33 AM, Nicklas Avén <span dir="ltr"><<a href="mailto:nicklas.aven@jordogskog.no">nicklas.aven@jordogskog.no</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>Hallo Oscar
<div align="left"> </div>
<div align="left">You can spatially enable any database by loading and running </div>
<div align="left">lwpostgis.sql</div>
<div align="left">and</div>
<div align="left">spatial_ref_sys.sql</div>
<div align="left"> </div>
<div align="left">for instance in pgAdmin</div>
<div align="left"> </div>
<div align="left">I think that's the right name of the files for your version and you can find them in :</div>
<div align="left">C:\Program files\PostgreSQL\8.3\share\contrib</div>
<div align="left">or something corresponing on your system.</div>
<div align="left">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</div>
<div align="left"> </div>
<div align="left">But if you have the possibility you probably want to upgrade both database and postgis. Latest stable now is</div>
<div align="left">PostgreSQL 8.4.2 and PostGIS 1.4. Hopefully in a couple of weeks PostGIS 1.5 will be released.</div>
<div align="left"> </div>
<div align="left">Hope that helps</div>
<div align="left">Nicklas<div class="im"><br>
<br>
2010-01-13 Oscar Zamudio wrote:<br>
<br>
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 <span style="line-height:18px;font-family:'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif">SPATIAL_REF_SYS Table for example, or the GEOMETRY_COLUMNS table? </span>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? ></div>
</div><div class="im">
<div>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</div>
</div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>