From: | y-tsukada(at)xseed(dot)co(dot)jp |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Streaming replication stacked. |
Date: | 2016-01-04 12:08:16 |
Message-ID: | JX201601042108163.40361951@xseed.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I use streaming replication on systems.
But I have an problem.
I need your support.
The system sometimes stacks Postgres process.
So, postgresql data isn't syncing.
I checkd process that it was stacked "waiting" status on slave server.
e.g.) postgres: startup process recovering 0000000100000xxxxxxxxxx
waiting
And I think Master Server completed to transfer wal files but Slave
server couldn't read wal files.
In addition once about 10 hours later , suddenly waiting process
started .
Below is the replication status.
-----------------------------------------
state | streaming
sent_location | A3C/10D51570
write_location | A3C/10D51570
flush_location | A3C/10D51570
replay_location | A3C/10D4A4B8
sync_priority | 0
sync_state | async
-----------------------------------------
Replay_location was stopping and Other location was active.
And There is System Version.
-----------------------------------------
- PostgreSQL Version : 9.4
- OS : CentOS6.4
- Replicaion Type : async
-----------------------------------------
And Below is the Postgres configration.
-----------------------------------------
++ Master :
wal_level = hot_standby
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = 0.7
archive_mode = on
archive_command = 'cp %p /var/lib/pgsql/9.4/data/archive_log/%f'
max_wal_senders = 3
wal_keep_segments = 32
wal_sender_timeout = 20s
hot_standby = on
max_standby_archive_delay = -1
max_standby_streaming_delay = -1
wal_receiver_status_interval = 5s
hot_standby_feedback = on
++ Slave :
wal_level = hot_standby
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = 0.7
archive_mode = on
archive_command = 'cp %p /var/lib/pgsql/9.4/data/archive_log/%f'
max_wal_senders = 3
wal_keep_segments = 32
wal_sender_timeout = 20s
hot_standby = on
max_standby_archive_delay = -1
max_standby_streaming_delay = -1
wal_receiver_status_interval = 5s
hot_standby_feedback = on
-----------------------------------------
Do you have any solution?
Thanks in advance for any help.
Yoji Tsukada.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2016-01-04 12:28:10 | Re: Streaming replication stacked. |
Previous Message | Nicolas Paris | 2016-01-04 09:14:00 | Re: PostgreSQL GUI tools |