Re: Need solution for weekly database "snapshot"

On Mon, Apr 22, 2013 at 1:41 PM, Christophe Pettus <xof(at)thebuild(dot)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
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle