Re: [GENERAL] Rebuild streaming replication

2015-03-13 Thread Dara Unglaube
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

Re: [GENERAL] Rebuild streaming replication

2015-03-12 Thread Chander Ganesan
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/

[GENERAL] Rebuild streaming replication

2015-03-12 Thread Dara Unglaube
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