On Mar 4, 2008, at 6:02 PM, Alan Hodgson wrote:
On Tuesday 04 March 2008, "libra dba" <libra.dba@xxxxxxxxx> wrote:
How else can i replicate the wal_files? ( i don't want to user common
file system ,,, NFS,,, etc.)?
scp
Actually, scp is a bad choice for transfering wal files if you're
planning on continuous replay. You want something that supports
atomic transfers. rsync is a typical choice and I've been meaning to
check out unison for a while now.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
