Re: PostgreSQL 9.3 PITR from remote server failing

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.3 PITR from remote server failing
Date: 2014-01-02 16:52:53
Message-ID: 1388681573001-5785077.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kido Kouassi wrote
> restore_command ='ssh pgu(at)backup_server "gunzip /bkp/wal%f" && scp
> pgu(at)backup_server:/bkp/wal/%f %p'
>
> scp: /bkp/wal/f%: No such file or directory

typo? try: "gunzip /bkp/wal/%f" (note the added "/" after 'wal')

Also the 'scp' error indicates "/bkp/wal/f%" but you claim you are using
"/bkp/wal/%f" - which would substitute the %f with an actual file instead of
passing around the literal 'f%'. Likely the error is correct and you have a
typo there as well.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-9-3-PITR-from-remote-server-failing-tp5785074p5785077.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kido Kouassi 2014-01-02 17:13:50 Re: PostgreSQL 9.3 PITR from remote server failing
Previous Message Rene Romero Benavides 2014-01-02 16:25:33 Re: PostgreSQL 9.3 PITR from remote server failing