Re: Removing second slave server

Fundação de apoio à escola técnica 

franklin ferreira de lima

Em Qui, 14 de jan de 2021 12:51, Jerry Sievers <gsievers19@comcast.net> escreveu:

Yambu <hyambu@gmail.com> writes:

> Hello
>
> I want to reinstall my second slave server and I have to stop
> replication.
>
> May i know if it's enough to just run the command below on the second
> slave
>
> touch /tmp/postgresql.trigger.5432
You don't even have to do that if you're going to decom and put the
server up again.

>
> Trigger file in recovery.conf is 
>
> trigger_file = '/tmp/postgresql.trigger.5432'   
>
> Do i need to do anything on the master server so that wal files do
> not build up since the second slave is no longer active?

Perhaps, if you are using a replication slot which is typical on $recent
releases such as Pg10.

After the standby is down, drop the related replication slot on your
primary else you'll retain WAL files unnecessarily and could fill the
disk.

HTH

>
> Im using PG v10,streaming replication
>
> regards
>
>
>  
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net