fly-apps / fly-apps/postgres-flex

PITR fails if max_connections has been increased

Open
#255 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Go
Stars
171
Forks
76
Avg merge
1h 19m
Merged PRs (30d)
1

Description

1. Create a db
2. Run `fly pg config update --max-connections 320`
3. Enable backups with `fly pg backups enable`
4. Restore from backup with `fly pg backups restore new-db`
5. The new DB fails to become healthy, and I don't think postgres ever exits recovery mode:
```
2024-08-12T19:55:42Z app[3d8dd719a93e78] iad [info]postgres | 2024-08-12 19:55:42.084 UTC [393] FATAL: recovery aborted because of insufficient parameter settings
2024-08-12T19:55:42Z app[3d8dd719a93e78] iad [info]postgres | 2024-08-12 19:55:42.084 UTC [393] DETAIL: max_connections = 300 is a lower setting than on the primary server, where its value was 320.
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.