oops, also if you don't already you need to have plpgsql language support installed before running lwpostgis.sql using createlang plpgsql yourexistingdb
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Randall, Eric Sent: Sunday, October 26, 2008 6:54 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] PostGis on an existing Postgres installation James, You need only run the lwpostgis.sql script in (/share/contrib) against your exiting database to spatially enable it. Also run spatial_ref_sys.sql Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of James Cauchi Sent: Sunday, October 26, 2008 5:32 AM To: [email protected] Subject: [postgis-users] PostGis on an existing Postgres installation Hi PostGis Community, My Question: Does everyone have a separate PostGis and Postgres db in their server or do people put all their data in the PostGis db? Background: I have been using Postgres DB since September and just now I need to add GIS support to my application so the obvious thing was to install PostGis. During my PostGis installation a new db (called PostGis) was created. I need to link my goereferenced data to other data in my db before i display it to the user on the map and that is why i need all the data in 1 db. cross-db references are not allowed in Postgres so I am left with 2 options: 1. Copy all my existing data to the PostGis db 2. Copy the whole PostGis db into my existing db. Both these options seem cumbersome and pretty silly so I must be missing something here - please enlighten me. thanks James _______________________________________________ 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
