From: | Selva manickaraja <mavles78(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Standby function after fail-over |
Date: | 2011-02-20 07:24:16 |
Message-ID: | AANLkTim3JAZRY1J+JM3KABfY=AGWDuzrMd7eEHJA8oU7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear All,
We are in the midst of setting up fail-over arrangements between a primary
and secondary.
In the primary we have set the "archive_command" to copy the WAL(s) to a
shared directory "archive_dir" accessible by both Primary and Secondary.
As the Secondary is meant to fail-over. The "restore_command" will recover
the WAL(s) from "archive_dir". Once it becomes the Primary, can it assume
the role of the initial Primary to copy the WAL(s) to "archive_dir". This
means the "archive_command" and "archive_mode" settings need to be as same
as the initial Primary. One thing to note here is that the "hot_standby" has
been to "on" in the Secondary to function as a read-only server. What is
expected to happen if the Secondary fails-over? Can it copy the WAL(s) to
"archive_dir" just as the Primary did? Or must be change the setting after
the fail-over and initiate a restart?
Thank you.
Regards,
Selvam
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-02-20 16:52:57 | Re: Corrupted disk |
Previous Message | Kevin Grittner | 2011-02-19 14:53:27 | Re: Corrupted disk |