Commit Graph

1565 Commits

Author SHA1 Message Date
Ian Barwick
1b51316989 doc: note downstream node (dis)connection monitoring in more places 2020-06-09 16:39:45 +09:00
Ian Barwick
1b6c184cad doc: update link to Debian package archive
See also https://www.df7cb.de/blog/2020/apt-archive.postgresql.org.html
2020-04-14 12:49:13 +09:00
Ian Barwick
e1365eaca4 Minor log output fixes 2020-04-06 13:20:20 +09:00
Tom Janson
3e9f156d3c fix inverted log message
When trying to follow a new primary, the type of the new primary is checked. When it is *not* of type primary, a warning is logged and the follow attempt is aborted. As far as I can tell, the message itself is exactly the opposite of what it should be: The node is not primary, thus it is standby / "in recovery". Feel free to correct me if I’m misunderstanding.
2020-04-03 12:40:47 +09:00
Ian Barwick
fd29a7ae28 doc: add note about granting permissions on pg_promote() 2020-04-02 11:37:07 +09:00
Ian Barwick
4acaca08c5 doc: update section about passwords when cloning standbys
Reference new password management section and remove duplicate
info.
2020-03-18 17:39:01 +09:00
Ian Barwick
116572c86e doc: add note about alternative passfile locations 2020-03-18 17:38:56 +09:00
Ian Barwick
192f8ff3c2 doc: add section about password management
This is briefly covered in the section about cloning, but is hard to
find.
2020-03-18 17:38:52 +09:00
Ian Barwick
cc233c90e8 doc: clarify database user permission requirements 2020-03-10 14:27:16 +09:00
Ian Barwick
d021810ce6 doc: move database permission configuration to separate file 2020-03-10 14:27:11 +09:00
Ian Barwick
11ddb08911 cluster show: correct timeline column length calculation
Unlikely to have made a difference unless abnormally long priority
or timeline values exist.
2020-03-10 14:26:53 +09:00
Ian Barwick
f5124a7750 standby clone: fix references to "recovery.conf" for Pg 12 and later
"standby clone --recovery-conf-only" still mentioned "recovery.conf" in a
couple of places; change that to the more generic "replication configuration"
for Pg 12 and later.
2020-02-27 15:06:05 +09:00
Ian Barwick
f64d28bc95 repmgrd: improve logging
Note node name and type when logging primary node visibility.
2020-02-24 15:38:15 +09:00
Ian Barwick
0c8a636293 doc: a witness server is also relevant for primary visibility consensus checks
Clarify documentation and example to make it clear that a witness
server, if present, is also used for primary visibility consensus
checks.
2020-02-24 15:38:12 +09:00
Ian Barwick
0c270242a3 repmgrd: improve logging
For easier log analysis, state which node is the current primary.
2020-02-24 15:38:08 +09:00
Ian Barwick
9a13d89a6b doc: link to latest blog article from README 2020-02-19 09:33:44 +09:00
Ian Barwick
d475ccdec2 doc: note PostgreSQL 9.4 EOL 2020-02-14 17:17:55 +09:00
Ian Barwick
55e3b11bdc Add optional check for unsupported future PostgreSQL releases
This is for backbranches to prevent them running against newer
PostgreSQL versions with which they are not compatible, for example
4.4.x with PostgreSQL 12 and later.
2020-02-14 17:17:51 +09:00
Ian Barwick
3145ccbe95 doc: add single quotes to "barman_config" example.
Mandatory from repmgr 5.x.
2020-02-14 17:17:32 +09:00
Ian Barwick
d19ccf74e8 standby switchover: display "shutdown_check_timeout" value in --dry-run mode
It's useful to be aware of this setting.
2020-01-30 10:31:20 +09:00
Ian Barwick
7bcf736a06 doc: link to latest blog article 2020-01-30 10:23:48 +09:00
Ian Barwick
fc678f97e3 Add missing values to action_name() 2020-01-29 15:35:20 +09:00
Ian Barwick
8b96b14397 standby switchover: fix repmgr execution confirmation in --dry-run mode
Inexplicably, "localhost" was hard-coded, rather than the remote host
name.
2020-01-29 14:07:35 +09:00
Ian Barwick
9319f212a9 standby switchover: improve wording of pending archive file messages 2020-01-29 14:07:30 +09:00
Ian Barwick
f5bfba4a5a doc: minor clarifications to Debian package info 2020-01-24 10:46:56 +09:00
Ian Barwick
e60d00543c doc: update repository links to https 2020-01-24 10:46:52 +09:00
Ian Barwick
be79f1e2c9 doc: note availability of RHEL 8 packages 2020-01-07 09:45:24 +09:00
Renaud Fortier
84d83a383a Update repmgr.conf.sample
Add empty single quotes to promote_command and follow_command
2019-12-16 12:28:12 +09:00
Ian Barwick
f288e7c6b5 repmgrd: fix configuration file reload handling
Usually repmgrd requires the parameters "promote_command" and
"follow_command" to be present in the configuration file. These are
not required if "failover=manual", but the configuration sanity check
following receipt of SIGHUP was not checking that.

Addresses issue reported in GitHub #614.
2019-12-16 11:35:41 +09:00
Ian Barwick
9d2d3296fb doc: update release notes 2019-12-10 16:48:36 +09:00
Ian Barwick
309f2a7000 standby follow: don't attempt to delete slot if new upstream is same as current
An attempt will be made to delete an existing replication slot on the
old upstream node (this is important during e.g. a switchover operation
or when attaching a cascaded standby to a new upstream). However if the
standby is currently attached to the follow target node anyway, the
replication slot should never be deleted.
2019-12-10 15:58:26 +09:00
Ian Barwick
656030b851 doc: add reference to "ssh_options"
This is listed in "repmgr.conf.sample" but not the main documentation.
2019-11-25 10:17:45 +09:00
Ian Barwick
b535daed89 doc: link PgBouncer fencing document from main docs 2019-11-21 09:58:01 +09:00
Ian Barwick
cd0ea1688c doc: document "tablespace_mapping" parameter.
This was previously only mentioned in "repmgr.conf.sample".
2019-11-20 16:54:49 +09:00
Ian Barwick
98021f1167 doc: fix minor punctuation typo 2019-11-11 15:54:59 +09:00
Ian Barwick
d963558baf doc: ensure various repmgr.conf values are quoted appropriately 2019-11-08 11:50:29 +09:00
Ian Barwick
b0bfed0495 doc: update repmgr.conf sample
Convert recovery.conf references to generic configuration descriptions,
and fix spacing.
2019-11-08 11:48:44 +09:00
Ian Barwick
017387dfd0 doc: clarify Barman configuation
Per confusion noted in GitHub #602.
2019-11-07 14:29:14 +09:00
Ian Barwick
0bde2fc00c standby clone: fix typo in log message 2019-10-28 14:09:31 +09:00
Ian Barwick
ff48789ea3 doc: note superuser requirement for "repmgr primary register" 2019-10-25 12:44:49 +09:00
Ian Barwick
87fe68032a primary register: improve debug log output 2019-10-25 12:44:05 +09:00
Ian Barwick
0112843f1b doc: note permission requirements for "repmgr standby (promote|switchover)
Per issues noted in GitHub #595.
2019-10-25 11:54:50 +09:00
Ian Barwick
8065a443dd Clarify usage of log_db_error() function 2019-10-24 10:05:12 +09:00
Ian Barwick
446d7426ba doc: note which repmgr versions are supported in the compatibility matrix 2019-10-24 09:49:28 +09:00
Ian Barwick
b4da7caa30 doc: update README
Link to compatibility matrix, support section.
2019-10-24 09:49:24 +09:00
Ian Barwick
2067c164fc doc: update README 2019-10-24 09:49:20 +09:00
Ian Barwick
4f0613cba2 Ensure postgresql.auto.conf is created with correct permissions 2019-10-18 16:47:42 +09:00
Ian Barwick
5bf05f7b2d Tweak "repmgr standby --help" output not to mention recovery.conf
Use the more generic "replication configuration" to cover Pg12
and later.
2019-10-18 14:11:39 +09:00
Ian Barwick
6c3b0dff4f doc: expand section about requesting support 2019-10-18 12:00:47 +09:00
Ian Barwick
676475dc1f doc: add link to blog entry about Pg12 replication configuration changes 2019-10-18 12:00:43 +09:00