From: | "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br> |
---|---|
To: | John DeSoi <desoi(at)pgedit(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: replication stops working |
Date: | 2013-07-08 22:41:21 |
Message-ID: | 51DB4011.2070509@mandic.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-07-08 22:46:29 | Re: Longest Common Subsequence in Postgres - Algorithm Challenge |
Previous Message | Robert James | 2013-07-08 20:04:52 | Re: Longest Common Subsequence in Postgres - Algorithm Challenge |