WAL stream sync broken on postgres-4 #382

New Issue

raucao · 2022-02-07T16:32:33Z

raucao commented

2022-02-07 16:32:33 +00:00

Ran into this bug after stopping and restarting the service on postgres-4: https://dba.stackexchange.com/questions/284146/could-not-receive-data-from-wal-stream-error-requested-wal-segment-has-already

Ran into this bug after stopping and restarting the service on `postgres-4`: https://dba.stackexchange.com/questions/284146/could-not-receive-data-from-wal-stream-error-requested-wal-segment-has-already

raucao added the

ops

label 2022-02-07 16:32:39 +00:00

raucao self-assigned this 2022-02-07 17:17:07 +00:00

raucao added this to the Current operational issues project 2022-02-07 17:17:23 +00:00

raucao commented

2022-02-07 17:19:53 +00:00

Apparently there's pg_rewind for this, but the command is missing for some reason. I ended up just re-syncing all data from scratch.

Apparently there's [`pg_rewind`](https://www.postgresql.org/docs/12/app-pgrewind.html) for this, but the command is missing for some reason. I ended up just re-syncing all data from scratch.

raucao closed this issue

2022-02-07 17:19:56 +00:00

Sign in to join this conversation.

No Milestone

No project

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: kosmos/chef#382