From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | martin soethof <martinsoethof(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: question about installation |
Date: | 2012-07-11 19:46:44 |
Message-ID: | 4FFDD824.1010507@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2012-07-11 19:48:37 | Re: installation problem with postgres password |
Previous Message | Emanuel Calvo | 2012-07-11 16:07:40 | Re: Key not present in table, but it is. |