On 08/02/10 10:38 AM, steeles@xxxxxxxxx wrote:
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)....
Windows network drive mappings are on a per user session basis. the drives you have mapped on your desktop will NOT be available to a service, which is probably running with different user credentials, anyways
instead, use UNC names, like \\server\sharename\path\... and also be sure to verify that the user the service is running as (postgres ?) has write access to the \\server\share. this can be pretty tricky to debug.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
