sorintlab / stolon

PostgreSQL cloud native High Availability and more.
https://talk.stolon.io
Apache License 2.0
4.66k stars 447 forks source link

standby center: stolon-keeper do pg_rewind fail for pg master is in recovery mode #811

Open zhangyuzhou-nj opened 3 years ago

zhangyuzhou-nj commented 3 years ago

Standby Center switch pg master node original pg master change to slave do pg_rewind got the error "source server must not be in recovery mode"

but the new pg master is in recovery mode (replication from primary center) source server shound be set to primary center?

2020-11-26T16:54:26.026+0800 INFO cmd/keeper.go:852 syncing using pg_rewind {"masterDB": "73bb9362", "keeper": "postgres_94"} 2020-11-26T16:54:26.026+0800 INFO postgresql/postgresql.go:921 running pg_rewind pg_rewind: fatal: source server must not be in recovery mode 2020-11-26T16:54:26.053+0800 ERROR cmd/keeper.go:855 error syncing with pg_rewind {"error": "error: exit status 1"} 2020-11-26T16:54:26.137+0800 INFO cmd/keeper.go:878 syncing from followed db {"followedDB": "73bb9362", "keeper": "postgres_94"} 2020-11-26T16:54:26.137+0800 INFO postgresql/postgresql.go:964 running pg_basebackup pg_basebackup: initiating base backup, waiting for checkpoint to complete WARNING: skipping special file "./postgresql.auto.conf" pg_basebackup: checkpoint completed pg_basebackup: write-ahead log start point: 3C/6F000028 on timeline 3 pg_basebackup: starting background WAL receiver 0/92117 kB (0%), 0/1 tablespace (...ata/pgdata/postgres/backup_label)