Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

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:melvin6925(at)gmail(dot)com]
Sent: Wednesday, October 26, 2016 8:16 PM
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; Michael Paquier <michael(dot)paquier(at)gmail(dot)com>; Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com>
Cc: pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>>
Date: 10/26/16 19:50 (GMT-05:00)
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com<mailto:michael(dot)paquier(at)gmail(dot)com>>, Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com<mailto:Joanna(dot)Xu(at)amdocs(dot)com>>
Cc: pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)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(dot)Xu(at)amdocs(dot)com<mailto:Joanna(dot)Xu(at)amdocs(dot)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(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)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