Re: Failing backups, canceling statement due to conflict with recovery

From: Stuart Bishop <stuart(at)stuartbishop(dot)net>
To: René Romero Benavides <ichbinrene(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Failing backups, canceling statement due to conflict with recovery
Date: 2013-02-14 04:50:15
Message-ID: CADmi=6OBhix9Q-HkcK=pDsfqSc4LLe6nHAc+_Lum3wSU1n2HPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 14, 2013 at 5:20 AM, René Romero Benavides
<ichbinrene(at)gmail(dot)com> wrote:
> What does the following query give you on the standby ?
> select * from pg_settings where category = 'Replication / Standby Servers';

name | setting
------------------------------+---------
hot_standby | on
hot_standby_feedback | on
max_standby_archive_delay | 30000
max_standby_streaming_delay | 30000
wal_receiver_status_interval | 10

--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Bishop 2013-02-14 04:59:02 Re: Failing backups, canceling statement due to conflict with recovery
Previous Message Noah Misch 2013-02-14 02:40:20 Re: BUG #7493: Postmaster messages unreadable in a Windows console