restore_command ignored in recovery.conf on standby

From: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: restore_command ignored in recovery.conf on standby
Date: 2014-04-14 02:27:47
Message-ID: CANaGW089nF8oJUtO-uwTxCmh_iu3Q4hwyBrapdUn-MAzVJXFbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

- 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",""

# recovery.conf

standby_mode=on
restore_command='/bin/tar -xzf /db/wal_archives/%f.tar.gz -C %p'

where the /db/wal_archives/ looks like this:
00000001000001ED000000F7.tar.gz
00000001000001ED000000F8.tar.gz
00000001000001ED000000F9.tar.gz

as you can see, the time line is far ahead from where the standby claims to
have reached a consistent recovery state

I tested the restore_command replacing variables and it works. Any ideas on
why it isn't being executed?

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2014-04-14 02:39:56 Re: restore_command ignored in recovery.conf on standby
Previous Message Paul Jones 2014-04-13 21:50:58 Re: User defined operator fails to work in EXCLUDE constraint