pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRemoving second slave server
3+ messages / 2 participants
[nested] [flat]
* Removing second slave server
@ 2021-01-14 12:18 Yambu <hyambu@gmail.com>
2021-01-14 15:51 ` Re: Removing second slave server Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: Yambu @ 2021-01-14 12:18 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
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?
Im using PG v10,streaming replication
regards
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Removing second slave server
2021-01-14 12:18 Removing second slave server Yambu <hyambu@gmail.com>
@ 2021-01-14 15:51 ` Jerry Sievers <gsievers19@comcast.net>
2021-01-15 07:46 ` Re: Removing second slave server Yambu <hyambu@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jerry Sievers @ 2021-01-14 15:51 UTC (permalink / raw)
To: Yambu <hyambu@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Removing second slave server
2021-01-14 12:18 Removing second slave server Yambu <hyambu@gmail.com>
2021-01-14 15:51 ` Re: Removing second slave server Jerry Sievers <gsievers19@comcast.net>
@ 2021-01-15 07:46 ` Yambu <hyambu@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Yambu @ 2021-01-15 07:46 UTC (permalink / raw)
To: franklinferreiradelima83@gmail.com; +Cc: Jerry Sievers <gsievers19@comcast.net>; rkurrle@hotmail.com, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Im not using replication slot
On Thu, Jan 14, 2021 at 6:02 PM franklin ferreira de lima <
franklinferreiradelima83@gmail.com> wrote:
> 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
>>
>>
>>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-01-15 07:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-14 12:18 Removing second slave server Yambu <hyambu@gmail.com>
2021-01-14 15:51 ` Jerry Sievers <gsievers19@comcast.net>
2021-01-15 07:46 ` Yambu <hyambu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox