On Fri, Jan 11, 2008 at 04:10:48PM -0800, Glyn Astill wrote:
> You mention a long transaction against the origin. My assumption was
> that during a backup/pg_dump no other operations could happen, is
> this correct?

Nope.  But pg_dump runs in a transaction, and that will cause Slony's logs
to bloat.

> Is it a bad idea to purely rely regular schema and data dumps as a
> backup? Are there any other backups I should be thinking of doing?
> I.e. regular file system backups?

You should read the Postgres manual about backups.  All the advice there
applies.

A