New Slave - timeline ERROR

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!

Responses

Browse pgsql-general by date

  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