diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2024-06-17 09:42:51 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2024-06-17 09:42:51 +0200 |
| commit | 04c8634c0c4d636540c9283efdd695558403dc4e (patch) | |
| tree | 244e8d12bb0393825590f359f3c4e455de556ff3 /doc/src | |
| parent | 8f1888eb6d6023b80525fbf7a8a1053daa6eb31e (diff) | |
| download | postgresql-04c8634c0c4d636540c9283efdd695558403dc4e.tar.gz postgresql-04c8634c0c4d636540c9283efdd695558403dc4e.zip | |
pg_createsubscriber: Only --recovery-timeout controls the end of recovery process
It used to check if the target server is connected to the primary
server (send required WAL) to rapidly react when the process won't
succeed. This code is not enough to guarantee that the recovery
process will complete. There is a window between the walreceiver
shutdown and the pg_is_in_recovery() returns false that can reach
NUM_CONN_ATTEMPTS attempts and fails.
Instead, rely only on the --recovery-timeout option to give up the
process after the specified number of seconds.
This should help with buildfarm failures on slow machines.
Author: Euler Taveira <euler.taveira@enterprisedb.com>
Reviewed-by: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Discussion: https://www.postgresql.org/message-id/776c5cac-5ef5-4001-b1bc-5b698bc0c62a%40app.fastmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_createsubscriber.sgml | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/pg_createsubscriber.sgml b/doc/src/sgml/ref/pg_createsubscriber.sgml index 142bffff023..a700697f887 100644 --- a/doc/src/sgml/ref/pg_createsubscriber.sgml +++ b/doc/src/sgml/ref/pg_createsubscriber.sgml @@ -326,13 +326,6 @@ PostgreSQL documentation </para> <para> - During the recovery process, if the target server disconnects from the - source server, <application>pg_createsubscriber</application> will check a - few times if the connection has been reestablished to stream the required - WAL. After a few attempts, it terminates with an error. - </para> - - <para> Since DDL commands are not replicated by logical replication, avoid executing DDL commands that change the database schema while running <application>pg_createsubscriber</application>. If the target server has |