Standby problem after restore_command Implementation
| От | Edson F. Lidorio |
|---|---|
| Тема | Standby problem after restore_command Implementation |
| Дата | |
| Msg-id | 5546C3DC.5070808@openmailbox.org обсуждение исходный текст |
| Ответы |
Re: Standby problem after restore_command Implementation
|
| Список | 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'
В списке pgsql-general по дате отправления: