<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18854"></meta>
</head>
<body>
<div align="left">How do you mean it is working well?</div>
<div align="left">If you have all the spatial functionality working you most likely have :</div>
<div align="left">geometry_columns </div>
<div align="left">and</div>
<div align="left">spatial_ref _sys table<br />
in your public schema.</div>
<div align="left"> </div>
<div align="left">But as I understood you, you have installed PostGIS with stackbuilder but without creating the template-database. Then all nessecary dll-files and sql-scrips is installed, but the database is not spatially enabled. And that can be done as I described in last mail. That have to be done for each new database that you want to use spatial functionality in. The difference if you had installed the template database is that then you could have spatially enabled a new database by using db postgis as template.</div>
<div align="left"> </div>
<div align="left">So</div>
<div align="left">Do you have a functional database with spatial functionality eg st_distance, st_union and so on? or have you "only" installed postgis in the server, yet.</div>
<div align="left"> </div>
<div align="left">/Nicklas</div>
<div align="left"> </div>
<div align="left"><br />
2010-01-13 Oscar Zamudio wrote:<br />
<br />
Thanks Nicklas,></div>
<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>On Wed, Jan 13, 2010 at 10:33 AM, Nicklas Avén <<a>nicklas.aven@jordogskog.no</a>> wrote:<br />
> >
<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><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>>
<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>postgis-users@postgis.refractions.net</a><br />
><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis.refractions.net/mailman/listinfo/postgis-users</a><br />
><br />
></div><br />
></div>
</body>
</html>