From: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: restore_command ignored in recovery.conf on standby |
Date: | 2014-04-14 03:13:17 |
Message-ID: | CANaGW08-HszMdJuv5K-yn7MbDA8GoeH5dw5Mz7A4LMBV1GqJHg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What I did (I bet there's a better way) is this:
restore_command='/db/standby_node/scripts/wal_restore.sh %f %p'
# wal_restore.sh
#!/bin/bash
/bin/tar -xzf /db/wal_archives/$1.tar.gz -C /tmp
cp /tmp/$1 $2
rm /tmp/$1
My best regards to Stephen Frost.
2014-04-13 21:58 GMT-05:00 Stephen Frost <sfrost(at)snowman(dot)net>:
> * Rene Romero Benavides (rene(dot)romero(dot)b(at)gmail(dot)com) wrote:
> > Yep, I checked:
> >
> > [postgres(at)uxmal standby_node]$ /bin/tar -xzf
> > /db/wal_archives/00000001000001ED000000FB.tar.gz -C
> > /db/standby_node/pg_xlog/
> > [postgres(at)uxmal standby_node]$ echo $?
> > 0
>
> Err, sure, but that isn't actually what is being passed via %p. %p will
> be something like 'pg_xlog/RECOVERY_WAL', as I said, which *won't* work
> for your tar command, eg:
>
> sfrost(at)tamriel:/home/sfrost> tar -xzf zz.tar.gz -C zz/zz
> tar: zz/zz: Cannot open: No such file or directory
> tar: Error is not recoverable: exiting now
> sfrost(at)tamriel:/home/sfrost> echo $?
> 2
>
> > [postgres(at)uxmal standby_node]$ ls /db/standby_node/pg_xlog/ | grep
> > 00000001000001ED000000FB
> > 00000001000001ED000000FB
>
> Noooo, PG tells you via %p the *specific* filename to use, do not just
> overwrite files in pg_xlog willy-nilly with a tar command.
>
> Thanks,
>
> Stephen
>
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2014-04-14 03:22:47 | Re: restore_command ignored in recovery.conf on standby |
Previous Message | Stephen Frost | 2014-04-14 02:58:55 | Re: restore_command ignored in recovery.conf on standby |