I’m trying to increase the postgres volume. I’ve followed this post: https://community.fly.io/t/how-to-convert-your-not-free-postgres-to-free-postgres/3888
It worked the first time. It didn’t when I tried it again.
New volume created, same region, same pgname.
> fly scale count 2 -a <pgname>
Count changed to 2
> fly scale show -a <pgname>
VM Resources for <pgname>
VM Size: shared-cpu-1x
VM Memory: 256 MB
Count: 2
Max Per Region: Not set
> fly status -a <pgname>
App
Name = <pgname>
Owner = gm
Version = 13
Status = running
Hostname = <pgname>.fly.dev
Deployment Status
ID = fe2b1013-327f-ac5a-d984-cdba7bc51185
Version = v13
Status = running
Description = Deployment is running
Instances = 2 desired, 0 placed, 0 healthy, 0 unhealthy
Instances
ID PROCESS VERSION REGION DESIRED STATUS HEALTH CHECKS RESTARTS CREATED
fa5cb9e0 app 12 ams run running (leader) 3 total, 3 passing 1 27m28s ago
db logs show repeating in loop these four lines
... our db requested role is master
... already master
... postgres parameters not changed
... postgres hba entries not changed
Scaling back to 1 and then back to 2 doesn’t help. Restarting also didn’t help
2022-04-30T17:42:17Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:17.488Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:17Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:17.488Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:22Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:22.538Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:22Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:22.538Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:22Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:22.558Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:22Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:22.559Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:27Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:27.630Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:27Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:27.631Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:27Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:27.652Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:27Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:27.652Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:32Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:32.712Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:32Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:32.713Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:32Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:32.733Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:32Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:32.734Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:37Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:37.780Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:37Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:37.781Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:37Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:37.805Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:37Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:37.806Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:42Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:42.859Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:42Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:42.860Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:42Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:42.881Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:42Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:42.882Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:47Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:47.989Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:47Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:47.990Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:48Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:48.013Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:48Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:48.013Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:53Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:53.163Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:53Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:53.164Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:53Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:53.184Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:53Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:53.185Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:42:58Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:58.238Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:42:58Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:58.238Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:42:58Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:58.260Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:42:58Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:42:58.260Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:43:03Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:03.330Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:43:03Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:03.331Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:43:03Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:03.352Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:43:03Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:03.352Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:43:08Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:08.484Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:43:08Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:08.485Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:43:08Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:08.510Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:43:08Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:08.510Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:43:13Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:13.565Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:43:13Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:13.566Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:43:13Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:13.589Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:43:13Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:13.590Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:43:18Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:18.645Z INFO cmd/keeper.go:1504 our db requested role is master
2022-04-30T17:43:18Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:18.646Z INFO cmd/keeper.go:1542 already master
2022-04-30T17:43:18Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:18.666Z INFO cmd/keeper.go:1675 postgres parameters not changed
2022-04-30T17:43:18Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:18.666Z INFO cmd/keeper.go:1702 postgres hba entries not changed
2022-04-30T17:43:23Z app[fa5cb9e0] ams [info]keeper | 2022-04-30T17:43:23.791Z INFO cmd/keeper.go:1504 our db requested role is master