Postgres Pro
Downloads
Home   >   mailing lists

Sharing data directories between machines - Mailing list pgsql-general

From JD Wong
Subject Sharing data directories between machines
Date
Msg-id CAGuHHn8k4K87C9DPt1=ViXUWp2zQVguHM2mspcNeW8OM9Tvoxg@mail.gmail.com
Whole thread Raw
Responses Re: Sharing data directories between machines  (Davide Setti <davide.setti@gmail.com>)
Re: Sharing data directories between machines  (Steve Atkins <steve@blighty.com>)
Re: Sharing data directories between machines  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: Davide Setti
Date:
Subject: Speedup filtering on citext[] columns
Next
From: Davide Setti
Date:
Subject: Re: Sharing data directories between machines