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

Paul Guo <pguo@pivotal.io>

From: Paul Guo <pguo@pivotal.io>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>, Asim R P <apraveen@pivotal.io>, Alexandra Wang <leiwang@pivotal.io>, Thomas Munro <thomas.munro@gmail.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Date: 2020-01-15T10:18:15Z

Lists: pgsql-hackers

Attachments

v9-0001-Support-node-initialization-from-backup-with-tabl.patch (application/octet-stream) patch v9-0001
v9-0003-Fix-replay-of-create-database-records-on-standby.patch (application/octet-stream) patch v9-0003
v9-0002-Tests-to-replay-create-database-operation-on-stan.patch (application/octet-stream) patch v9-0002

I further fixed the last test failure (due to a small bug in the test, not
in code). Attached are the new patch series. Let's see the CI pipeline
result.

Commits

Improve recently-added test reliability
- ad0e08394746 10.22 landed
- 9d5c96d9be64 14.5 landed
- 8c5d9ccca967 13.8 landed
- 782e5631e5dd 12.12 landed
- 772e6383d1da 11.17 landed
- 6c1c9f88ad54 16.0 landed
- 6390bc740f90 15.0 landed
Fix new recovery test for log_error_verbosity=verbose case
- b998196bb59a 16.0 cited
Fix test instability
- fcd72cf295c3 11.17 landed
- 7cfe688dee86 13.8 landed
- 798d64488ca9 15.0 landed
- 6ffaf75a8001 10.22 landed
- 658e5d53459f 12.12 landed
- 59be1c942a47 16.0 landed
- 4d8d85740c02 14.5 landed
Fix replay of create database records on standby
- 9e4f914b5eba 16.0 landed
- a3aacb7cbfc7 14.5 landed
- 9a7e26b9c2ac 13.8 landed
- 8348413dbded 15.0 landed
- 6d20f8c5a46a 12.12 landed
- 5a10c262fc60 11.17 landed
- 084318c33a1f 10.22 landed
- ffd28516e699 14.3 landed
- 50e3ed8e9172 13.7 landed
- 49d9cfc68bf4 15.0 landed
Allow "in place" tablespaces.
- 961cab0a5a90 14.5 landed
- 16e7a8fd8e97 13.8 landed
- ca347f5433ed 12.12 landed
- 7bdbbb87340f 10.22 landed
- 258c896418bf 11.17 landed
Fix get_dirent_type() for Windows junction points.
- fee0165fc1cf 14.5 landed
- 6d306ab73168 15.0 landed
- 9d3444dcce4d 16.0 landed
Revert "Fix replay of create database records on standby"
- bf902c13930c 15.0 landed
- adc943b4e1fe 14.3 landed
- a54ed2de80ec 13.7 landed
Add end-to-end testing of pg_basebackup's tar-format output.
- 081876d75ea1 14.0 cited
Make DROP DATABASE command generate less WAL records.
- e6d8069522c8 13.0 cited
Consolidate methods for translating a Perl path to a Windows path.
- 660a2b19038b 12.0 cited