From: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | New Slave - timeline ERROR |
Date: | 2016-01-09 04:44:05 |
Message-ID: | CAE_gQfVijr1DWFW-2hykmLLqHiY0mgO1pCpgN8j5MHq99a8ggQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've started a new SLAVE PostgreSQL server set up.
** NOTE: I run the pg_basebackup from another STANDBY SERVER. Not from the
MASTER*
1 - screen -t basebackup
2 - su - postgres
3 - cd ~/9.2/data/
4 - ssh postgres(at)slave01 'pg_basebackup --pgdata=- --format=tar
--label=bb_master --progress --host=localhost --port=5432
--username=replicator --xlog | pv --quiet --rate-limit 100M' | tar -x
--no-same-owner
5 - I've commented the "primary_conninfo =" and "standby_mode=" so the
slave can get the files from WAL_ARCHIVE
6 - Afte I got the logs:
postgres(iostreams)[10037]: 2016-01-09 00:07:26.604
UTC|10085|LOG: database system is ready to accept read only
connections
7 - After the server finished the WAL_ARCHIVE, I turned on replication from
MASTER on recovery.conf:
*recovery.conf on the New Slave:*
restore_command = 'exec nice -n 19 ionice -c 2 -n 7
../../bin/restore_wal_segment.bash "../wal_archive/%f" "%p"'
archive_cleanup_command = 'exec nice -n 19 ionice -c 2 -n 7
../../bin/pg_archivecleaup_mv.bash -d "../wal_archive" "%r"'
recovery_target_timeline = 'latest'
standby_mode = on
primary_conninfo = 'host=192.168.100.XX port=5432 user=replicator
application_name=replication_slave02'
But, once I've restarted the POSTGRESQL I got this error:
WAL segment `../wal_archive/00000005.history` not found2016-01-09
01:13:39.183 UTC|774|FATAL: timeline 2 of the primary does not match
recovery target timeline 4
What can I do to solve the problem?
It's really important as it's a production New Slave. Thank you!
From | Date | Subject | |
---|---|---|---|
Next Message | Deven Phillips | 2016-01-09 04:45:50 | Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question |
Previous Message | Deven Phillips | 2016-01-09 04:38:21 | Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question |