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@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
