Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Point in time recovery: Recovery target is unreachable in combination with logging_collector = off #2168

Open
arenk opened this issue Jan 12, 2023 · 0 comments

Comments

@arenk
Copy link

arenk commented Jan 12, 2023

PostgreSQL 13 has changed the behavior when the recovery target is unreachable while cloning clusters. A fix has been implemented such that the behavior remains as in previous versions (see Spilo pull request)

However, this fix relies on screening the log files - something that doesn't work when logging_collector is set to off (e.g. because logs shall be collected by Promtail).

My current workaround: Set logging_collector to on during cloning and switch back back to off later

Since this cost me half a day, this issue serves two purposes :)

  1. maybe someone else has the same issue and it might be easier to find the solution in an issue in the postgres-operator repository instead of a comment in a pull request of the spilo repository
  2. I would suggest to add a brief note in the documentation of the postgres-operator (e.g. in https://postgres-operator.readthedocs.io/en/latest/user/#how-to-clone-an-existing-postgresql-cluster)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant