show primary_conninfo unchanged after promotion?

Поиск
Список
Период
Сортировка
От Wiwwo Staff
Тема show primary_conninfo unchanged after promotion?
Дата
Msg-id CAFe70G4Aqbthx2f8TRm=SoxEZOyHEuhj2wPY6=c-+LzczqacOA@mail.gmail.com
обсуждение исходный текст
Ответы Re: show primary_conninfo unchanged after promotion?  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-general
Hi!
i might be doing something wrong, but I cannot see what...

Server is 14.3 (Debian 14.3-1.pgdg110+1)
(at the time of writing, in Dockerfile FROM postgres:14)

I have a 3 node cluster, starting with pg_red (172.26.0.2) as primary.
I promote pg_green (172.26.0.4) as new primary, all other aligned.

Now, on pg_green (172.26.0.4):

=# select inet_server_addr();
 inet_server_addr
------------------
 172.26.0.4

=# select pg_is_in_recovery();
 pg_is_in_recovery
-------------------
 f

=# select * from pg_stat_replication; (CUT)
 pid | usesysid | usename | application_name | client_addr
-----+----------+---------+------------------+-------------
 486 |   16,384 | rep     | walreceiver      | 172.21.0.2  
 625 |   16,384 | rep     | walreceiver      | 172.21.0.4  

But, if I execute show primary_conninfo, i get
=# show primary_conninfo ;
                                                                      primary_conninfo
------------------------------------------------------------------------------------------------------------------------------------------------------------
 user=rep passfile='/.pgpass' channel_binding=prefer host=pg_red port=5432 sslmode=prefer sslcompression=0 sslsni=1 ssl_min_protocol_version=TLSv1.2 g.
.ssencmode=prefer krbsrvname=postgres target_session_attrs=any

which says primary is pg_red, which is the old primary.

What is that I am doing wrong?!?
Tnx!


В списке pgsql-general по дате отправления:

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Who am I? Where am I connected?
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: show primary_conninfo unchanged after promotion?