pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to auto swtich the roles of primary and standby 5+ messages / 2 participants [nested] [flat]
* How to auto swtich the roles of primary and standby @ 2011-07-03 07:35 jenopob <jenopob@126.com> 2012-04-17 05:42 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> 0 siblings, 1 reply; 5+ messages in thread From: jenopob @ 2011-07-03 07:35 UTC (permalink / raw) To: pgsql-admin hi all my architecture follows as: Master/Slave with Streaming Replication and pgpool-II version of pgpool-II is pgpool-II.3.0.4 version of PostgreSQL is 9.0.2 http://postgresql.1045698.n5.nabble.com/file/n4546630/pgpool-II.png I want to confirm some questions as follows: 1.how about the performance of the architecture ,about what params should I pay most attention to 2.when the primary server goes down , pgpool will execute the command :failover_command and then the standby server becomes the new primary,this is no problem, but when I restart former primary ,what should pgpool do to change the former primary server to new standby ,any command like failover_command to execute? the content of http://www.postgresql.org/docs/9.1/static/warm-standby-failover.html say should recreate the new standby ,but I have no idea about this , could pgpool-II manage the process ,I also find the command failback_command(command to execute when attaching a new node) at pgpool.conf ,I am not sure this command can do something correctly to change the former primary to new standby the question most like http://postgresql.1045698.n5.nabble.com/Switchover-of-Master-and-Slave-roles-td4462251.html thanks for any help jenopob -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to auto swtich the roles of primary and standby 2011-07-03 07:35 How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> @ 2012-04-17 05:42 ` videanuadrian <videanuadrian@yahoo.com> 2012-04-19 02:34 ` Re: How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 0 siblings, 1 reply; 5+ messages in thread From: videanuadrian @ 2012-04-17 05:42 UTC (permalink / raw) To: pgsql-admin Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to auto swtich the roles of primary and standby 2011-07-03 07:35 How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 2012-04-17 05:42 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> @ 2012-04-19 02:34 ` jenopob <jenopob@126.com> 2012-04-19 10:47 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> 0 siblings, 1 reply; 5+ messages in thread From: jenopob @ 2012-04-19 02:34 UTC (permalink / raw) To: pgsql-admin hi we did a new shell script named recovery_config_chage.sh at standby server. the script I wanted to change the fail down postgres master config ,let it start as standby server and build the communication with the former standby now is master server,then started it by remotestart.sh the above hopes to help you something At 2012-04-17 13:42:50,"videanuadrian [via PostgreSQL]" <ml-node+s1045698n5645680h54@n5.nabble.com> wrote: Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to auto swtich the roles of primary and standby 2011-07-03 07:35 How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 2012-04-17 05:42 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> 2012-04-19 02:34 ` Re: How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> @ 2012-04-19 10:47 ` videanuadrian <videanuadrian@yahoo.com> 2012-04-20 06:01 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> 0 siblings, 1 reply; 5+ messages in thread From: videanuadrian @ 2012-04-19 10:47 UTC (permalink / raw) To: pgsql-admin so, just to make sure that i understand: after the master failed, the slave become the new master, the you have changed postgresql.conf from master to slave and viceversa and restarted the old master as slave ? --- On Thu, 4/19/12, jenopob [via PostgreSQL] <ml-node+s1045698n5650704h68@n5.nabble.com> wrote: From: jenopob [via PostgreSQL] <ml-node+s1045698n5650704h68@n5.nabble.com> Subject: Re:Re: How to auto swtich the roles of primary and standby To: "videanuadrian" <videanuadrian@yahoo.com> Date: Thursday, April 19, 2012, 5:34 AM hi we did a new shell script named recovery_config_chage.sh at standby server.the script I wanted to change the fail down postgres master config ,let it start as standby serverand build the communication with the former standby now is master server,then started it by remotestart.sh the above hopes to help you something At 2012-04-17 13:42:50,"videanuadrian [via PostgreSQL]" <[hidden email]> wrote: Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to auto swtich the roles of primary and standby 2011-07-03 07:35 How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 2012-04-17 05:42 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> 2012-04-19 02:34 ` Re: How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 2012-04-19 10:47 ` Re: How to auto swtich the roles of primary and standby videanuadrian <videanuadrian@yahoo.com> @ 2012-04-20 06:01 ` videanuadrian <videanuadrian@yahoo.com> 0 siblings, 0 replies; 5+ messages in thread From: videanuadrian @ 2012-04-20 06:01 UTC (permalink / raw) To: pgsql-admin hi, i tried the exact setup that you described here, but unfortunately i had to restart the new master(former slave) in order to get the new settings and this will conduct to a downtime and service interruption. anyway thanks for sharing your experience. Adrian Videanu --- On Fri, 4/20/12, jenopob [via PostgreSQL] <ml-node+s1045698n5653287h41@n5.nabble.com> wrote: From: jenopob [via PostgreSQL] <ml-node+s1045698n5653287h41@n5.nabble.com> Subject: Re:Re:Re: How to auto swtich the roles of primary and standby To: "videanuadrian" <videanuadrian@yahoo.com> Date: Friday, April 20, 2012, 6:18 AM hi thereI prepared two postgresql.conf on the servers ,use shell script to change which config should use .there are some config fields not the smae between the two config files .At 2012-04-19 18:47:26,"videanuadrian [via PostgreSQL]" <[hidden email]> wrote: so, just to make sure that i understand: after the master failed, the slave become the new master, the you have changed postgresql.conf from master to slave and viceversa and restarted the old master as slave ? --- On Thu, 4/19/12, jenopob [via PostgreSQL] <[hidden email]> wrote: From: jenopob [via PostgreSQL] <[hidden email]> Subject: Re:Re: How to auto swtich the roles of primary and standby To: "videanuadrian" <[hidden email]> Date: Thursday, April 19, 2012, 5:34 AM hi we did a new shell script named recovery_config_chage.sh at standby server.the script I wanted to change the fail down postgres master config ,let it start as standby serverand build the communication with the former standby now is master server,then started it by remotestart.sh the above hopes to help you something At 2012-04-17 13:42:50,"videanuadrian [via PostgreSQL]" <[hidden email]> wrote: Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-04-20 06:01 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-07-03 07:35 How to auto swtich the roles of primary and standby jenopob <jenopob@126.com> 2012-04-17 05:42 ` videanuadrian <videanuadrian@yahoo.com> 2012-04-19 02:34 ` jenopob <jenopob@126.com> 2012-04-19 10:47 ` videanuadrian <videanuadrian@yahoo.com> 2012-04-20 06:01 ` videanuadrian <videanuadrian@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox