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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
