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 chan...@otg-nc.com 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

[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

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: