From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Cascade Standby - HELP! |
Date: | 2014-04-02 19:09:57 |
Message-ID: | BD7563973EF8894D905C80593EE9A4ED35CB53@MAIL01.fnal.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am not sure if I am hitting a bug... I am running 9.2.4
I created cascade standby as follows:
Master->cascading-standby->standby
I configured streaming replication. At first I thought everything worked. I created some data in master and went to cascading-standby and from there to standby. So, I thought it worked.
And then, I shutdown standby (the last one in the chain) and created data load in master for several hours. Everything got replicated to cascading-standby. However, when I restarted the standby (the one I shut down before), I got an error saying
"[2014-04-02 12:55:49 CDT][][]FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 000000010000001C00000013 has already been removed"
So, everything worked in standby as long as the logs were available in pg_xlog area of cascading-standby. Once they are removed from pg_xlog, the streaming broke (this is expected).
Is there a way I can make cascading-standby send every log it gets from master down to standby server before it gets cleaned up by archive_cleanup_command? Or some other way??? (I don't want master send logs to both slaves. That will be defeating the purpose of cascade set up.)
Thanks for your help.
Murthy
From | Date | Subject | |
---|---|---|---|
Next Message | Burgholzer, Robert (DEQ) | 2014-04-02 20:28:42 | Re: Cascade Standby - HELP! |
Previous Message | Murthy Nunna | 2014-04-02 12:49:24 | Archive param questions? |