Standby problem after restore_command Implementation

From: "Edson F(dot) Lidorio" <edson(at)openmailbox(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Standby problem after restore_command Implementation
Date: 2015-05-04 00:57:00
Message-ID: 5546C3DC.5070808@openmailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm having trouble on Standby after the implementation of the
restore_command.
I performed all the settings and it worked normally and after restart
the slave server, started to generate errors in the log of the slave:

I'm using Debian 8 with PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu,
compiled by gcc-4.9. real (Debian 4.9.2-10) 4.9.2, 64-bit

Slave error log:
5/3/2015 16:46:01 BRT [10210-1] @ Replicator [unknown] error: WAL
segment requested 00000001000000000000002C has been removed
5/3/2015 16:46:05 BRT [10211-1] @ Replicator [unknown] error: WAL
segment requested 00000001000000000000002C has been removed
5/3/2015 16:46:10 BRT [10214-1] @ Replicator [unknown] error: WAL
segment requested 00000001000000000000002C has been removed
5/3/2015 16:46:15 BRT [10216-1] @ Replicator [unknown] error: WAL
segment requested 00000001000000000000002C has been removed

Master error log
5/3/2015 19:13:35 BRT [3339-1] @ Replicator [unknown] error: WAL segment
requested 00000001000000000000002C has been removed
5/3/2015 19:13:40 BRT [3341-1] @ Replicator [unknown] error: WAL segment
requested 00000001000000000000002C has been removed
5/3/2015 19:13:44 BRT [3343-1] @ Replicator [unknown] error: WAL segment
requested 00000001000000000000002C has been removed

Settings files are as follows:

master

postgresql.conf

listen_addresses = '*'
wal_level = hot_standby
archive_mode = on
archive_command = 'cp "%p" /mnt/server/archivedir/"%f"'
max_wal_senders = 2
wal_keep_segments = 20

pg_hba.conf
host replication replicador 192.168.0.112/32 trust

secondary

postgresql.conf

listen_addresses = '*'
hot_standby = on

pg_hba.conf
host all all 0.0.0.0/0 md5

recover.conf em (/var/lib/postgresql/9.4/main)

standby_mode=on
primary_conninfo='host=192.168.0.100 user=replicador application_name=
jessie-stby'
trigger_file='/tmp/pgtrigger'
restore_command = 'cp /mnt/server/archivedir/%f %p'
archive_cleanup_command = 'pg_archivecleanup /mnt/server/archivedir %r'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-05-04 01:39:23 Re: Removing and readding bdr nodes
Previous Message Adrian Klaver 2015-05-04 00:29:03 Re: Errors using JDBC batchUpdate with plpgsql function