Re: restore_command ignored in recovery.conf on standby

On Apr 13, 2014 7:30 PM, "Rene Romero Benavides" <rene(dot)romero(dot)b(at)gmail(dot)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