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.

Reply via email to