Hey Amitkapila,
Thank you for the quick reply.
How can implement this patch in windows, because I am using windows 9.1.1
postgreSQL application ??
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-avoid-base-backup-in-automated-failover-tp5711147p5728562.html
Hey Haas,What does the standby server have to wait for replication to catch
up before promoting ?? Is there any parameter to configure this ??Few more
questions on this part 1. How could we ensure the standby has received all
transactions sent by primary till the point primary server is dead.
Hey Haas,
What does the standby server have to wait for replication to catch up before
promoting ?? Is there any parameter to configure this ??
Few more questions on this part
1. How could we ensure the standby has received all transactions sent by
primary till the point primary server is
Hi All,
It would be helpful if someone tell me, how to verify the streaming
replication started in standby server successfully, just after the service
is started ?? Like knowing the exit code of the service started...
I know we can do it by verifying the below functions after the service is
Hi all,
Recently I was writing an application to implement automated failover with
env: Two 2008 R2 servers, Network area storage, asynchronous replication,
WAL archive on primary enabled.
Is there any way to avoid starting standby server always from base backup in
automated failover. I see the
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
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:
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
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,
