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