Re: standby recovery fails (tablespace related) (tentative patch and discussion)

From:	Paul Guo <guopa(at)vmware(dot)com>
To:	Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, Asim Praveen <pasim(at)vmware(dot)com>, "thomas(dot)munro(at)gmail(dot)com" <thomas(dot)munro(at)gmail(dot)com>, "horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp" <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: standby recovery fails (tablespace related) (tentative patch and discussion)
Date:	2021-08-05 10:20:44
Message-ID:	SA1PR05MB85821DEC48A6841277BDBF57C3F29@SA1PR05MB8582.namprd05.prod.outlook.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-04-17 07:56:30 from Paul Guo <pguo(at)pivotal(dot)io> 📎  2019-04-19 04:38:04 from Asim R P <apraveen(at)pivotal(dot)io>   2019-04-22 04:36:43 from Paul Guo <pguo(at)pivotal(dot)io>    2019-04-22 07:15:13 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎     2019-04-22 07:40:27 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎      2019-04-22 12:19:33 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎       2019-04-23 02:34:38 from Michael Paquier <michael(at)paquier(dot)xyz>        2019-04-23 05:02:34 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>      2019-04-23 05:31:58 from Paul Guo <pguo(at)pivotal(dot)io>       2019-04-23 07:39:49 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>        2019-04-24 08:13:54 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎         2019-04-28 07:33:13 from Paul Guo <pguo(at)pivotal(dot)io>          2019-04-30 06:33:47 from Paul Guo <pguo(at)pivotal(dot)io> 📎           2019-05-07 06:47:11 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>            2019-05-13 09:37:50 from Paul Guo <pguo(at)pivotal(dot)io>             2019-05-14 03:06:13 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>              2019-05-27 13:39:03 from Paul Guo <pguo(at)pivotal(dot)io>               2019-06-19 07:21:54 from Paul Guo <pguo(at)pivotal(dot)io> 📎                2019-07-08 03:15:35 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                 2019-07-15 10:52:01 from Paul Guo <pguo(at)pivotal(dot)io> 📎                  2019-08-01 22:37:46 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                   2019-08-22 13:13:20 from Paul Guo <pguo(at)pivotal(dot)io> 📎                    2019-08-22 16:13:05 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                     2019-09-03 15:58:55 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2019-09-05 07:12:23 from Paul Guo <pguo(at)pivotal(dot)io>                     2019-09-10 11:42:55 from Asim R P <apraveen(at)pivotal(dot)io>                      2019-09-11 14:26:44 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                       2019-09-12 08:35:36 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                        2019-09-12 12:02:41 from Asim R P <apraveen(at)pivotal(dot)io> 📎                    2019-09-19 11:59:59 from Asim R P <apraveen(at)pivotal(dot)io> 📎                     2019-09-20 12:23:56 from Asim R P <apraveen(at)pivotal(dot)io> 📎                      2019-12-26 14:45:19 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                       2020-01-10 00:22:45 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                        2020-01-10 13:43:35 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                         2020-01-13 10:27:16 from Paul Guo <pguo(at)pivotal(dot)io>                          2020-01-15 10:18:15 from Paul Guo <pguo(at)pivotal(dot)io> 📎                           2020-01-27 15:24:37 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                            2020-03-25 05:52:10 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                             2020-07-07 21:12:30 from Daniel Gustafsson <daniel(at)yesql(dot)se>                            2020-07-08 12:56:44 from Paul Guo <guopa(at)vmware(dot)com> 📎                             2021-01-05 01:07:24 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                              2021-01-27 08:36:22 from Paul Guo <guopa(at)vmware(dot)com>                               2021-03-27 14:23:16 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                2021-03-30 07:12:19 from Paul Guo <guopa(at)vmware(dot)com> 📎                                 2021-07-09 19:37:57 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>                                  2021-08-05 10:20:44 from Paul Guo <guopa(at)vmware(dot)com> 📎                                   2021-08-10 20:56:37 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2021-08-11 07:58:51 from Paul Guo <paulguo(at)gmail(dot)com>                                     2021-08-11 12:59:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2021-09-24 18:14:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2021-11-04 12:34:33 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                      2021-11-08 08:55:16 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                       2021-11-09 03:51:15 from Michael Paquier <michael(at)paquier(dot)xyz>                                        2021-11-09 08:05:49 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                         2021-11-10 08:14:11 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                          2021-11-10 12:14:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                           2021-11-11 02:13:52 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                            2021-11-12 07:43:27 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                             2021-12-24 10:21:59 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                              2022-01-16 04:43:03 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                               2022-01-17 08:24:43 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                2022-01-20 04:25:41 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                               2022-01-20 06:07:22 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                2022-01-20 08:19:04 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                 2022-03-02 07:59:09 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                  2022-03-02 10:31:24 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                   2022-03-04 00:10:48 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                    2022-03-04 04:51:12 from Michael Paquier <michael(at)paquier(dot)xyz>                                                     2022-03-04 06:30:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                      2022-03-07 08:39:27 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                       2022-03-14 21:37:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                        2022-03-15 06:09:26 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                        2022-03-21 19:03:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2022-03-28 16:17:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2022-03-29 04:55:35 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                           2022-03-29 11:37:34 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                            2022-03-29 12:45:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                             2022-03-29 13:28:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                              2022-03-29 13:31:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                               2022-04-01 04:21:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                2022-04-01 18:51:58 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                 2022-04-04 08:29:48 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                  2022-04-04 08:54:49 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                   2022-04-04 15:44:27 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                    2022-04-05 02:16:44 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                     2022-04-05 07:38:06 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                                      2022-04-05 07:54:47 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                      2022-04-05 08:18:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                                       2022-07-13 16:43:45 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                                        2022-07-14 21:47:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                                         2022-07-15 07:30:59 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                          2022-07-15 07:56:10 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                          2022-07-15 10:58:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                           2022-07-15 12:03:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                         2022-07-20 10:50:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                                          2022-07-20 15:25:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                           2022-07-20 16:34:23 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                           2022-07-21 11:01:06 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                            2022-07-21 11:14:57 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                             2022-07-21 11:20:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                              2022-07-21 11:25:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                               2022-07-22 01:02:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                             2022-07-22 00:20:37 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                              2022-07-22 08:18:58 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                               2022-07-22 08:49:37 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                                2022-07-27 06:07:16 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                               2022-07-22 08:53:12 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                          2022-07-21 11:11:26 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                           2022-07-21 11:17:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                          2022-07-27 18:54:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                                           2022-07-28 18:04:38 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                            2022-07-28 21:57:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                             2022-07-28 23:27:01 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                              2022-07-29 05:20:08 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                                               2022-07-29 10:59:03 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                2022-07-30 14:37:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                 2022-07-30 16:51:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                  2022-07-30 23:08:01 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                   2022-07-30 23:17:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                    2022-08-04 02:54:41 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                  2022-08-05 20:29:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                 2022-07-31 03:46:33 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                  2022-08-02 19:58:08 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                 2022-08-01 02:01:04 from Andres Freund <andres(at)anarazel(dot)de>                                                       2022-03-21 18:43:52 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                        2022-03-25 12:26:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2022-03-28 01:01:05 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                          2022-03-28 01:34:44 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                           2022-03-28 06:25:51 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                           2022-03-29 01:57:42 from Michael Paquier <michael(at)paquier(dot)xyz>                                                          2022-03-28 08:20:42 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                         2022-03-28 14:37:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2022-03-29 01:34:42 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                     2022-03-21 11:24:38 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v12-0002-Tests-to-replay-create-database-operation-on-sta.patch	application/octet-stream	9.8 KB
v12-0001-Support-node-initialization-from-backup-with-tab.patch	application/octet-stream	4.9 KB
v12-0003-Fix-replay-of-create-database-records-on-standby.patch	application/octet-stream	10.4 KB
v12-0004-Fix-database-create-drop-wal-description.patch	application/octet-stream	1.9 KB

In response to

• Re: standby recovery fails (tablespace related) (tentative patch and discussion) at 2021-07-09 19:37:57 from Ibrar Ahmed

Responses

• Re: standby recovery fails (tablespace related) (tentative patch and discussion) at 2021-08-10 20:56:37 from Robert Haas

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2021-08-05 10:23:49	Re: Added schema level support for publication.
Previous Message	Paul Guo	2021-08-05 10:18:03	Re: Two patches to speed up pg_rewind.