Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Feb 14, 2013 at 5:20 AM, René Romero Benavides
<ichbinrene@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux