Re: Sharing data directories between machines

You can't just make them share the data dir (for example: what about
caches in memory?)

Probably what you want is streaming replication:

http://wiki.postgresql.org/wiki/Streaming_Replication

Regards.

On Tue, Aug 6, 2013 at 7:45 PM, JD Wong <jdmswong(at)gmail(dot)com> wrote:
> 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

--

Davide Setti
code: http://github.com/vad