Re: allow online change primary_conninfo - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: allow online change primary_conninfo
Date
Msg-id 1796751585307082@sas1-ac0cb6954dcf.qloud-c.yandex.net
Whole thread Raw
In response to Re: allow online change primary_conninfo  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: allow online change primary_conninfo  (Sergei Kornilov <sk@zsrv.org>)
Re: allow online change primary_conninfo  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hello

> I realized that the reason the tests broke after Sergei's patch is that
> recovery/t/001_stream_rep.pl's get_slot_xmins() is broken for temp
> walreceiver slots, since it's using the non-temp name it tries to give
> to the slot, rather than the temp name under which it is actually
> created. The workaround proposed by 0002 is to edit standby_1's config
> to set walreceiver's slot to be non-temp.

This is bug in behavior, not in tests.
We need walrcv->is_temp_slot = false; somewhere in RequestXLogStreaming to works correctly.

HEAD is not affected since primary_slot_name cannot be changed online.

> (The thing is: if I specify primary_slot_name in the config, why is the
> temp walreceiver slot code not obeying that name? I think walreceiver
> should create a temp slot, sure, but using the given name rather than
> coming up with a random name.)

Hm, interesting idea.

regards, Sergei



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)
Next
From: Peter Eisentraut
Date:
Subject: Re: INSERT ... OVERRIDING USER VALUE vs GENERATED ALWAYS identitycolumns