| From: | Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru> |
|---|---|
| To: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | history file on replica and double switchover |
| Date: | 2020-08-27 13:02:44 |
| Message-ID: | 54b059d4-2b48-13a4-6f43-95a087c92367@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello!
I`ve noticed, that when running switchover replica to master and back to
replica, new history file is streamed to replica, but not archived,
which is not great, because it breaks PITR if archiving is running on
replica. The fix looks trivial.
Bash script to reproduce the problem and patch are attached.
--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| history_replica.patch | text/x-patch | 694 bytes |
| double_switchover.sh | application/x-shellscript | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2020-08-27 13:15:04 | Re: list of extended statistics on psql |
| Previous Message | Surafel Temesgen | 2020-08-27 12:31:15 | Evaluate expression at planning time for two more cases |