Re: restore_command ignored in recovery.conf on standby - Mailing list pgsql-general

From Jeff Janes
Subject Re: restore_command ignored in recovery.conf on standby
Date
Msg-id CAMkU=1xEnAfdyvhtjhmgc8w0pCSUAZq-JBOeC+1HebsO3_mq=Q@mail.gmail.com
Whole thread Raw
In response to restore_command ignored in recovery.conf on standby  (Rene Romero Benavides <rene.romero.b@gmail.com>)
List pgsql-general


On Apr 13, 2014 7:30 PM, "Rene Romero Benavides" <rene.romero.b@gmail.com> wrote:
>
> - Base backup taken with 9.2.6 (via pg_basebackup command)
> - binaries updated to 9.2.8
> - set up the base backup to replicate from the master and archives, and started
> - the restore_command option is ignored, with the following message:
>
> 2014-04-13 21:07:21.386 CDT,,,22055,,534b42d7.5627,4,,2014-04-13 21:07:19 CDT,1/0,0,LOG,00000,"consistent recovery state reached at 1E6/F9FFE880",,,,,,,,"CheckRecoveryConsistency, xlog.c:7371",""
> 2014-04-13 21:07:21.387 CDT,,,22053,,534b42d6.5625,1,,2014-04-13 21:07:18 CDT,,0,LOG,00000,"database system is ready to accept read only connections",,,,,,,,"sigusr1_handler, postmaster.c:4261",""
>

Are you sure there is actually a problem? "Ready to accept read-only connections" doesn't mean recovery has ended.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: restore_command ignored in recovery.conf on standby
Next
From: Michael Paquier
Date:
Subject: Re: streaming replication and recovery