Here is the current recovery.conf on slave. Does the trigger_file need to be changed? If it does, can you give me an example?
# Note that recovery.conf must be in $PGDATA directory. # Specifies whether to start the server as a standby. In streaming replication, # this parameter must to be set to on. standby_mode = 'on' #recovery_target_timeline = 'latest' # Specifies a connection string which is used for the standby server to connect # with the primary. primary_conninfo = 'host=10.53.199.61 port=5432 user=postgres' # Specifies a command to load archive segments from the WAL archive. If # wal_keep_segments is a high enough number to retain the WAL segments # required for the standby server, this may not be necessary. But # a large workload can cause segments to be recycled before the standby # is fully synchronized, requiring you to start again from a new base backup. restore_command = 'cp /opt/postgres/9.1/archive/%f %p' trigger_file='/opt/postgres/9.1/data/trigger' Thanks, Joanna Xu Senior Oracle DBA Data Experience Solution BU +1 613 595 5234 AMDOCS | EMBRACE CHALLENGE EXPERIENCE SUCCESS POLICY CONTROL IN THE FAST LANE What’s making policy control strategic in 2015 and beyond? Check out the top ten factors<http://www.policycontrolinthefastlane.com/> driving change… From: melvin6925 [mailto:[email protected]] Sent: Wednesday, October 26, 2016 8:16 PM To: Adrian Klaver <[email protected]>; Michael Paquier <[email protected]>; Joanna Xu <[email protected]> Cc: [email protected] Subject: Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1 It's simple just look in recovery. conf on slave and put stated trigger. then slave becomes stand alone. Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone -------- Original message -------- From: Adrian Klaver <[email protected]<mailto:[email protected]>> Date: 10/26/16 19:50 (GMT-05:00) To: Michael Paquier <[email protected]<mailto:[email protected]>>, Joanna Xu <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> Subject: Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1 On 10/26/2016 04:43 PM, Michael Paquier wrote: > On Wed, Oct 26, 2016 at 11:18 PM, Joanna Xu > <[email protected]<mailto:[email protected]>> wrote: >> I’ve been looking for a procedure (step by step) on how to remove Standby >> (SLAVE) from Primary (MASTER) for Postgres9.1 in google and the archived >> postings, but no luck. > > Standby and master servers are two separate Postgres instances. So if > you would like to remove a standby from a cluster. You just need to > basically stop it, then remove its data folder. And you are done. > There is no complicated science here. Not sure that is what OP wants. From the original post: " ... 2. After the standby is removed from the primary, both of nodes are in standalone configuration. " -- Adrian Klaver [email protected]<mailto:[email protected]> -- Sent via pgsql-general mailing list ([email protected]<mailto:[email protected]>) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp
