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

[Joanna Xu <Joanna.Xu@xxxxxxxxxx>]

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 driving change…

 

From: melvin6925 [mailto:melvin6925@xxxxxxxxx]
Sent: Wednesday, October 26, 2016 8:16 PM
To: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>; Michael Paquier <michael.paquier@xxxxxxxxx>; Joanna Xu <Joanna.Xu@xxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
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.klaver@xxxxxxxxxxx>

Date: 10/26/16 19:50 (GMT-05:00)

To: Michael Paquier <michael.paquier@xxxxxxxxx>, Joanna Xu <Joanna.Xu@xxxxxxxxxx>

Cc: pgsql-general@xxxxxxxxxxxxxx

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.Xu@xxxxxxxxxx> 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.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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