Restarting postgres DB servers in a master-slave setup

Posted by NRS on Stack Overflow See other posts from Stack Overflow or by NRS
Published on 2010-05-06T00:03:59Z Indexed on 2010/05/06 0:08 UTC
Read the original article Hit count: 519

Filed under:

master-slave

|

server-restart

|

postgresql

|

pitr

Is there any documentation on gracefully restarting servers that have PITR implemented. We have a master-slave setup. I want to make sure servers are rebooted in the correct order so as not to mess up WAL shipping. Should i disable WAL shipping prior to server restart?

© Stack Overflow or respective owner

Related posts about master-slave

How to validate selects / inserts are hitting the right server with MySQL Master/Slave

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rails app using the master_slave_adapter plugin (http://github.com/mauricio/master_slave_adapter/tree/master) to send all selects to a slave, and all other statements to the master. Replication is setup using Mysql master / slave. I'm trying to validate that all the SQL statements are… >>> More
Restarting postgres DB servers in a master-slave setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any documentation on gracefully restarting servers that have PITR implemented. We have a master-slave setup. I want to make sure servers are rebooted in the correct order so as not to mess up WAL shipping. Should i disable WAL shipping prior to server restart? >>> More
Changing postgres user password in a master-slave setup

as seen on Stack Overflow - Search for 'Stack Overflow'
We have PITR setup and WAL shipping enabled. We would like to change the password for the user postgres. The process is simple enough. However, since we cannot connect to the SLAVE how would we make sure all passwords are in synch? Would temporarily disabling WAL shipping allow me to connect to the… >>> More
Master/Slave DNS setup vs. rsync'ed DNS servers

as seen on Server Fault - Search for 'Server Fault'
We currently have primary and secondary DNS servers on our corporate network. They are setup in a master/slave type setup, where the slave gets its DNS information from the master. I'm trying to figure out what the real advantage is for the master/slave setup instead of just setting up an automated… >>> More
MongoDB -what's the safest and most efficient way to change from Master-Slave to ReplicaSet?

as seen on Server Fault - Search for 'Server Fault'
I now have two mongo servers with a Master-Slave configuration (all read-writes are done with the Master, the Slave is just a cold backup) serving a pretty demanding web app. I want to switch to ReplicaSet of 3 servers - I have these 3 already configured and working (still not connected to the web… >>> More

Related posts about server-restart

Automatic start of Tomcat on server restart (Linux)

as seen on Server Fault - Search for 'Server Fault'
I have 4 Tomcat instances I wish to start when the server (Cent OS 2.6.9) restarts. After all other services have started I would like to start these up - but I am a bit worried about the load of starting all 4 at the same time, so maybe a short delay would be necessary. How should I go about this? >>> More
server restart server 2003

as seen on Server Fault - Search for 'Server Fault'
i have a server of hp and i facing that problem when i login the server ll restart and if i connect to remote desktop system ll work properly please solve my problem >>> More
Server restart commando?

as seen on Server Fault - Search for 'Server Fault'
How can i restart the Server automaticcaly on this Operating System( http://bit.ly/dq1TQP ) Thanks for your answers! >>> More
Apache Mina Server Restart java.net.BindException: Address already in use

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a rather annoying problem in my server application. I bind Apache Mina with the following code: acceptor.bind(new InetSocketAddress(PORT)); Where acceptor is an NioSocketAcceptor. Over a HTTP interface I can shutdown the server so I can restart it. Server.ioAcceptor.unbind(new InetSocketAddress(Server… >>> More
enable profiler / Traceon after SQL server restart automatically

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, My client is facing some deadlocks while using our application. I want to track all the deadlocks for my research and to solve the deadlocks. i am currently run the SQL profiler for the event deadlock graph to capture the deadlock scenario. the actual problem is that the SQL server gets restarted… >>> More