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

PostgreSQL "data" directory disappears simultaneously in 3-node cluster with Pgpool-II #89

Open
velasquezjr2022 opened this issue Feb 11, 2025 · 0 comments

Comments

@velasquezjr2022
Copy link

Hello Pgpool-II community,
I have a PostgreSQL cluster with 3 nodes (xxxxxl01, xxxxxl02, xxxxxl03) and Pgpool-II. The PostgreSQL data directory is located on a remote instance per company policy.
On the 29th of this month, an incident occurred where the "data" directory disappeared on all 3 nodes simultaneously without apparent cause. It's the third time it's happened. We suspect it may have been caused by a problem on the remote instance hosting the data directories.
Is it possible that a failure on the remote instance could cause the PostgreSQL data directories on all 3 nodes to disappear or be deleted at the same time?
Any suggestions on how to prevent these types of incidents or Pgpool-II and PostgreSQL configuration best practices to avoid data loss in scenarios like this?
I appreciate in advance any guidance or advice you can provide. Greetings.

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