replication stops working

From: John DeSoi <desoi(at)pgedit(dot)com>
To: "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Subject: replication stops working
Date: 2013-07-08 14:27:41
Message-ID: 82392D6A-EB02-4A46-87CD-09220BC821A0@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a 9.2 hot standby setup with replication via rsync. For the second time, it has stopped working with no apparent error on the primary or standby. Last time this happened I fixed it by restarting the primary. Yesterday I started a new base backup around noon and it replicated without any problems for about 12 hours. Then it just stopped and I don't see any errors in the Postgres log (primary or standby). I looked at other system logs and still don't see any problems.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2013-07-08 14:45:19 Re: Longest Common Subsequence in Postgres - Algorithm Challenge
Previous Message pg noob 2013-07-08 13:54:13 Re: odd locking behaviour