On 11/07/2012 13:58, martin soethof wrote: > Hello > I have the following situation. > I used a postgres installer that can choose seperate paths for the > normal postgres and the data folder. > I used this because i wanted to share a database on an external hard > drive between 2 computers. > I installed it on PC #1, the normal postgres files are on my D drive, > the data folder and its components are on the portable F drive.. > Tomorrow i will be sitting behind PC #2, how should i install it.. > If i do install it the same way, won't that overwrite the existing data > folder on the F drive and thus result in loss of data or a corrupt database. > Or will postgres-installation simply notice i already have a data folder > there and ask if i want to share this? > Could you please guide me through the path of how to install postgresql > on the 2nd computer, so that both computers share their data in the same > folder.. What platform are you on? From the above it sounds like Windows. You might be able to do it as follows: - Install Postgres on the second computer using a local path for the data directory. - Stop the database server. - Restart it with the -D option pointing at the data directory on the external drive. Make sure that you use the same major version on both computers - e.g. 9.1, 9.0, etc. I think this will work; though it's not something I personally would do... it sounds a bit fragile. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
