John DeSoi wrote:
> I have a 9.2 hot standby setup with replication via rsync. For the second time, it has stopped working with no
apparenterror on the primary or standby. Last time this happened I fixed it by restarting the primary. Yesterday I
starteda new base backup around noon and it replicated without any problems for about 12 hours. Then it just stopped
andI don't see any errors in the Postgres log (primary or standby). I looked at other system logs and still don't see
anyproblems.
>
> I'm running Postgres 9.2.4 on CentOS 6.4. Thanks for any ideas or debug suggestions.
>
> John DeSoi, Ph.D.
>
> =====
>
> wal_level = hot_standby
> wal_keep_segments = 48
> max_wal_senders = 2
>
> archive_mode = on
> archive_command = 'rsync --whole-file --ignore-existing --delete-after -a %p bak-postgres:/pgbackup/%f'
> archive_timeout = 300
>
If there are no errors in the log, how did you conclude that replication
has stopped working? Since you're using a hot standby, you've also setup
streaming replication in addition to the WAL archiving, correct?
Regards,
Daniel Serodio