Re: Need help on WAL configure

On 08/02/10 10:38 AM, steeles(at)gmail(dot)com 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.