|
Hi, all I have 1 master and 2 slave PostgreSQL servers named e.g. server1(master), server2(slave) and server3(slave) OS: Ubuntu 16.04 Postgresql version is 9.6. Consider server1 down, then I touched a trigger file to server2, and then from server3 I run pg_rewind, But still get below errors: root@server3#: systemctl stop postgresql@9.6-main.service root@server3#: runuser -s /bin/bash postgres -c '/usr/lib/postgresql/9.6/bin/pg_rewind --target-pgdata /var/lib/postgresql/9.6/main/ --source-server="host=10.10.4.7 port=5432 user=postgres dbname=postgres"' servers diverged at WAL position 0/4B000060 on timeline 17 could not find previous WAL record at 0/4B000060: invalid record length at 0/4B000060: wanted 24, got 0 Failure, exiting What is wrong here? Thanks. |
