On Tue, May 22, 2012 at 12:15 PM, chinnaobi wrote:
> You mean when the primary which is going to switch its role to standby might
> not have sent all the WAL records to the standby and If it is switched to
> standby it has more WAL records than the standby which is now serves as
> primary. Is it ?
Sorry to mention, In my setup the primary and standby servers receive same
traffic, so no issue with the
"network fault between the primary and the standby, but not between the
primary and some of the clients updating it"
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/R
Dear Kevin,
Thank you for your reply. Yeah I am writing an application using powershell,
it's true it is not trivial and especially a guy like me who has no idea on
database.
You raised all the cases which I am muddling with, But currently I am
testing this setup:
Always standby server is confi
chinnaobi wrote:
> You mean when the primary which is going to switch its role to
> standby might not have sent all the WAL records to the standby and
> If it is switched to standby it has more WAL records than the
> standby which is now serves as primary. Is it ??
What happens when there is a
Dear Robert,
Thank you very much for the reply.
You mean when the primary which is going to switch its role to standby might
not have sent all the WAL records to the standby and If it is switched to
standby it has more WAL records than the standby which is now serves as
primary. Is it ??
It is
On Mon, May 14, 2012 at 8:18 AM, chinnaobi wrote:
> I do base backup only first time on standby when it is going to be
> replicated. when ever primary goes down, standby becomes primary and
> primary becomes standby when primary comes up. When primary becomes standby
> I am restoring data from WA
Hi All,
I have implemented hot standby for PostgreSQL with a group of two Primary
and Standby in windows 2008 servers.
Currently below are the settings:
1. Archiving is enabled on primary, stored on network storage.
2. Asynchronous Streaming replication from primary to standby.
wal-senders=5, wa
