On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus <xof@thebuild.com> wrote:
> Not bad, but the transaction logs would fill up the file system.
I'm not sure I understand that comment. Why would the transaction logs be particularly voluminous in this case?
I assumed the logs would be shipping to the slave and accumulating if the replication stopped. Is that not the case?
Is it possible for the slave to pause replication indefinitely and pick up where it left off without requiring huge volumes of transaction logs?
> Besides, it would not be worth it to set up a whole database cluster just for this purpose.
It does seem to meet all of your needs in a very efficient way; setting up a PG cluster is not that complex.
We don't have enough disk space to create a whole new copy of the database cluster. Until now we have been restoring from a pg_dump backup that does not include all of the audit logs.
Thanks!
--
Moshe Jacobson Nead Werx, Inc. | Manager of Systems Engineering