Re: restore_command ignored in recovery.conf on standby

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: restore_command ignored in recovery.conf on standby
Date: 2014-04-14 02:39:56
Message-ID: 20140414023956.GR2556@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rene,

* Rene Romero Benavides (rene(dot)romero(dot)b(at)gmail(dot)com) wrote:
> restore_command='/bin/tar -xzf /db/wal_archives/%f.tar.gz -C %p'
[...]
> I tested the restore_command replacing variables and it works. Any ideas on
> why it isn't being executed?

Are you sure that it isn't being executed and just immediately returning
'1' (meaning 'false'- aka, done with recovery)?

The -C option to tar is supposed to be "change directory" according to
the tar that I've got, and %p is the complete file name that PG wants
the WAL file to be copied to- it's not a directory (it's something like
pg_xlog/RECOVERY_WAL).

Thanks,

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rene Romero Benavides 2014-04-14 02:52:10 Re: restore_command ignored in recovery.conf on standby
Previous Message Rene Romero Benavides 2014-04-14 02:27:47 restore_command ignored in recovery.conf on standby