upgrade to repmgr3

From: Pekka Rinne <tsierkkis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrade to repmgr3
Date: 2016-08-04 08:57:03
Message-ID: CACAG2VVZ2t-oonbnuXLXLkQGRCq0WS_WrTGpZiVjsUDnuKxQxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi!

I have been using postgres 9.4 and repmgr2.0 combination and been doing
replication (hot standby). Now I'd like to start doing slot based
replication and have installed repmgr3 and exeuted the provided sql scripts
and also added use_replication_slots=1 into repmgr.conf.

The question is that what is the correct procedure to switch into using
slots (max_replication_slots) in this case as the system has been set up
already without them? Do I have to unregister and re-register all the
standbys? Hopefully re-clone could be avoided.

What I tried was that I configured max_replication_hosts=5, restarted
master, created some slots using select * from
pg_create_physical_replication_slot(<name>), configured one created slot
into recovery.conf in the slave. What I noticed was that replication seemed
to be still working after this but in repl_nodes table slot_name remained
empty. Then I did standby re-register with force and slot_name was filled
with repmgr_slot_2 value which is not the name I gave for the slot. I think
repmgr invented this name but in the pg_replication_slots table
repmgr_slot_2 does not exist. There is only the slot I created myself
(active=t). So I guess this approach is not quite right.

What if I just skip doing the re-register. Does is matter if slot_name
remains empty in repl_nodes?

br,
Pekka

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Periko Support 2016-08-04 13:01:40 Re: Tunning Server 9.1.
Previous Message Francisco Olarte 2016-08-04 06:44:04 Re: [SPAM] Re: [SPAM] Re: WAL directory size calculation