* Rene Romero Benavides (rene.romero.b@xxxxxxxxx) wrote: > Yep, I checked: > > [postgres@uxmal standby_node]$ /bin/tar -xzf > /db/wal_archives/00000001000001ED000000FB.tar.gz -C > /db/standby_node/pg_xlog/ > [postgres@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@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@tamriel:/home/sfrost> echo $? 2 > [postgres@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
Attachment:
signature.asc
Description: Digital signature
