Sharing data directories between machines

From: JD Wong <jdmswong(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Sharing data directories between machines
Date: 2013-08-06 17:45:06
Message-ID: CAGuHHn8k4K87C9DPt1=ViXUWp2zQVguHM2mspcNeW8OM9Tvoxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!

I have two servers, which share a large mounted drive. I would like to
share postgres databases between them dynamically so that when one makes
changes, they are immediately available in the other.

I tried moving the data directory over to the mounted drive, and pointing
both postgresql.confs to that one. I was able to have both access the same
databases, but they can't share changes. It's like they're running on two
separate data directories, even though show data_directory reports the same
path for each.

How can I make them play nicely?

Thanks!
-JD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Davide Setti 2013-08-06 19:00:54 Re: Sharing data directories between machines
Previous Message Davide Setti 2013-08-06 17:17:21 Speedup filtering on citext[] columns