Need some help to configure the WAl files shipping and restore it to the target server.here is what I configured in the source server. (both windows)In postgresql.conf, I enabled the following option.# WRITE AHEAD LOGfsync = on synchronous_commit = on wal_sync_method = fsync # - Archiving -archive_mode = onarchive_command = 'copy "%p" "D:\\PG_DATA\\%f"' #archive_timeout = 0 D drive is on the same source server ( I am also having trouble to ship it to target, had a network drive mapped in the source server, for some reason I couldn't get it copy over to this network drive, so had to copy it local D drive first).created the checkpoint, then make the base backup and copy the backup file to target along with archived WAL files. (filename: 0000000100000.... etc)Next step is to restore the base backup in the target server,after restore the base backup, stop PG service, then move away any file (filename: 0000200000000... etc) under pg_xlog, and copy source's WAL files to pg_xlogcreate recovery.conf file with the following line.restore_command = 'copy "C:\\pgwal\\%f" "%p"'when I tried to start PG service, for some reason, the recovery command is always looking for 0000200000000, which was created during the base backup restore. and it didn't even look for those archived WAL files from sources.Once I copied back those files that I moved away during the backup restore, it completes the recovery.Now, why it won't recognize the WAL files from source server.Did I miss any step? Sent from my BlackBerry device on the Rogers Wireless Network -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
