Thank you - it worked beautifully.
Dara
On Thu, Mar 12, 2015 at 4:28 PM, Chander Ganesan wrote:
> Hi Dara,
>
> A few things:
>
> 1. Replication is a binary process - that means that you can never set it
> up with using any of the pg_dump type tools (i.e., pg_dumpall/pg_dump can
> never be used
Hi Dara,
A few things:
1. Replication is a binary process - that means that you can never set
it up with using any of the pg_dump type tools (i.e., pg_dumpall/pg_dump
can never be used.)
2. PostgreSQL provides a special tool to make this process
super-simple:
http://www.postgresql.org/docs/9.1/
We had two servers set up with streaming replication. I believe when we did
a full vacuum analyze to the database on the master, it caused the slave to
not be able to catch up (wal_keep_segments = 32, but still not enough and
had archive off). I am trying to re-set up the slave to streaming
replica