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:melvin6...@gmail.com] Sent: Wednesday, October 26, 2016 8:16 PM To: Adrian Klaver <adrian.kla...@aklaver.com>; Michael Paquier <michael.paqu...@gmail.com>; Joanna Xu <joanna...@amdocs.com> Cc: pgsql-general@postgresql.org 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 <adrian.kla...@aklaver.com<mailto:adrian.kla...@aklaver.com>> Date: 10/26/16 19:50 (GMT-05:00) To: Michael Paquier <michael.paqu...@gmail.com<mailto:michael.paqu...@gmail.com>>, Joanna Xu <joanna...@amdocs.com<mailto:joanna...@amdocs.com>> Cc: pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org> 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 > <joanna...@amdocs.com<mailto:joanna...@amdocs.com>> 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 adrian.kla...@aklaver.com<mailto:adrian.kla...@aklaver.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>) 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
