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'
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 |