I tried to use only %p to specify the path, but it does not seem to output the
full path according to the server log. It only starts at /pg_xlog:
archive_command = '/usr/bin/scp -B "%p"
postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/%f'
DETAIL: The failed archive co
On 7/07/2011 12:39 PM, Joe Lester wrote:
DETAIL: The failed archive command was: /usr/bin/scp -B
/Volumes/DataDrive/data/pg_xlog/000100740086
postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/000100740086
LOG: archiver process (PID 17771) exited with exit cod
This message has been digitally signed by the sender.
Re___GENERAL__failed_archive_command.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Wed, 2011-07-06 at 23:39 -0500, Joe Lester wrote:
> archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
> postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/%f'
%p is expanded to the *full* path, so /Volumes/DataDrive/data/%p might
not be the correct. I'd use just %p instead o
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
