[postgis-users] PostGis on an existing Postgres installation

[Randall, Eric]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On 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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of James
Cauchi
Sent: Sunday, October 26, 2008 5:32 AM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users