Search Postgresql Archives

Standby problem after restore_command Implementation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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'



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux