I'm implementing failover for streaming replication using HAProxy. I'm
trying to implement soft failover, (or failback), that will give
applications in the midst of transaction a clear indication of the
state of their transaction.
My question is, if you use:
pg_ctl -D [DIR] stop -m fast
a
Is it possible (or smart!) to run multiple pg_dumps simulataneously on a single
database, dumping different parts of the database to different files by using
table and schema exclusion? I'm attempting this and sometimes it works and
sometimes when I check the dump files with
pg_restore -Fc
