pgsql: Improve errors related to incorrect TLI on checkpoint record rep

2022-01-24 Thread Michael Paquier
Improve errors related to incorrect TLI on checkpoint record replay WAL replay would cause a hard crash if the timeline expected by a XLOG_END_OF_RECOVERY, a XLOG_CHECKPOINT_ONLINE, or a XLOG_CHECKPOINT_SHUTDOWN record is not the same as the timeline being replayed, using the same error message fo

pgsql: doc: Fix some grammar

2022-01-24 Thread Michael Paquier
doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 10 Branch -- REL_11_STABLE Details --- h

pgsql: doc: Fix some grammar

2022-01-24 Thread Michael Paquier
doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 10 Branch -- REL_14_STABLE Details --- h

pgsql: doc: Fix some grammar

2022-01-24 Thread Michael Paquier
doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 10 Branch -- REL_10_STABLE Details --- h

pgsql: doc: Fix some grammar

2022-01-24 Thread Michael Paquier
doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 10 Branch -- REL_12_STABLE Details --- h

pgsql: doc: Fix some grammar

2022-01-24 Thread Michael Paquier
doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 10 Branch -- REL_13_STABLE Details --- h

pgsql: Fix various typos, grammar and code style in comments and docs

2022-01-24 Thread Michael Paquier
Fix various typos, grammar and code style in comments and docs This fixes a set of issues that have accumulated over the past months (or years) in various code areas. Most fixes are related to some recent additions, as of the development of v15. Author: Justin Pryzby Discussion: https://postgr.e

pgsql: Unbreak pg_verifybackup/t/008_untar.pl on msys

2022-01-24 Thread Andrew Dunstan
Unbreak pg_verifybackup/t/008_untar.pl on msys Commit 0ad8032910 contains the same pattern fixed in commit 4f0bcc7350. Apply the same fix. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c817a072aae8441a11d6a0336953ecd69dc548ba Modified Files -- src/bin

pgsql: Add tests of the CREATEROLE attribute

2022-01-24 Thread Andrew Dunstan
Add tests of the CREATEROLE attribute The current regression tests do not contain much testing of CREATEROLE. This patch, extracted from a larger patch set to modify how that feature works, remedies that omission. Author: Mark Dilger Discussion: https://postgr.es/m/d9065dfb-56db-4e89-a73e-db8cc

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Fix limitations on what SQL commands can be issued to a walsende

2022-01-24 Thread Tom Lane
Fix limitations on what SQL commands can be issued to a walsender. In logical replication mode, a WalSender is supposed to be able to execute any regular SQL command, as well as the special replication commands. Poor design of the replication-command parser caused it to fail in various cases, not

pgsql: Server-side gzip compression.

2022-01-24 Thread Robert Haas
Server-side gzip compression. pg_basebackup's --compression option now lets you write either "client-gzip" or "server-gzip" instead of just "gzip" to specify where the compression should be performed. If you write simply "gzip" it's taken to mean "client-gzip" unless you also use --target, in whic

pgsql: pg_upgrade: Preserve database OIDs.

2022-01-24 Thread Robert Haas
pg_upgrade: Preserve database OIDs. Commit 9a974cbcba005256a19991203583a94b4f9a21a9 arranged to preserve relfilenodes and tablespace OIDs. For similar reasons, also arrange to preserve database OIDs. One problem is that, up until now, the OIDs assigned to the template0 and postgres databases have

pgsql: Unbreak pg_basebackup/t/010_pg_basebackup.pl on msys

2022-01-24 Thread Andrew Dunstan
Unbreak pg_basebackup/t/010_pg_basebackup.pl on msys Once again we ran foul of the rather baroque msys2 path translation rules. The cure as in many cases is to do the translation ourselves. Discussion: https://postgr.es/m/ca+tgmozu+1yj8tz8pzrphxpmr6wz84v2rfznsd5hnzugytq...@mail.gmail.com Branch

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real

pgsql: Remember to reset yy_start state when firing up repl_scanner.l.

2022-01-24 Thread Tom Lane
Remember to reset yy_start state when firing up repl_scanner.l. Without this, we get odd behavior when the previous cycle of lexing exited in a non-default exclusive state. Every other copy of this code is aware that it has to do BEGIN(INITIAL), but repl_scanner.l did not get that memo. The real