postgres-init cookbook does not successfully sync
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	hnowlan
	Feb 22 2021, 1:11 PM

Description

This cookbook does not currently successfully reimage a host. pg_basebackup will fail without the postgres directory existing to back up to, and without the recovery file being written, the postgres replica that would start up had the backup succeeded would configure itself as a master and therefore would be unsuitable to replicate from the master.

Details

	Subject	Repo	Branch	Lines +/-
	postgres: use remote script on replica to resync	operations/cookbooks	master	+13 -21
	postgres: add script for automatic resyncing	operations/puppet	production	+55 -0

Customize query in gerrit

Related Objects

Mentioned In: rCCKBda3b0b297a38: postgres: use remote script on replica to resync

Event Timeline

hnowlan created this task.Feb 22 2021, 1:11 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 22 2021, 1:11 PM

Change 666110 had a related patch set uploaded (by Hnowlan; owner: Hnowlan):
[operations/puppet@production] postgres: add script for automatic resyncing

https://gerrit.wikimedia.org/r/666110

gerritbot added a project: Patch-For-Review.Feb 22 2021, 1:23 PM

Change 666113 had a related patch set uploaded (by Hnowlan; owner: Hnowlan):
[operations/cookbooks@master] postgres: use remote script on replica to resync

https://gerrit.wikimedia.org/r/666113

Change 666110 merged by Hnowlan:
[operations/puppet@production] postgres: add script for automatic resyncing

https://gerrit.wikimedia.org/r/666110

Change 666113 merged by jenkins-bot:

[operations/cookbooks@master] postgres: use remote script on replica to resync

https://gerrit.wikimedia.org/r/666113

Maintenance_bot removed a project: Patch-For-Review.Jun 24 2021, 4:10 PM

hnowlan closed this task as Resolved.Aug 26 2021, 10:40 AM

hnowlan mentioned this in rCCKBda3b0b297a38: postgres: use remote script on replica to resync.Dec 14 2022, 3:28 PM