failed archive command

From: Joe Lester <joe_lester(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: failed archive command
Date: 2011-07-07 04:39:17
Message-ID: 45ABCC06-5316-498B-A412-8A7687391B8A@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)172(dot)20(dot)204(dot)55:/Volumes/DataDrive/wals_from_master/%f'

The problem is that I keep getting the following message over and over again in the postgres log:

FATAL: archive command failed with exit code 255
DETAIL: The failed archive command was: /usr/bin/scp -B /Volumes/DataDrive/data/pg_xlog/000000010000007400000086 postgres(at)172(dot)20(dot)204(dot)55:/Volumes/DataDrive/wals_from_master/000000010000007400000086
LOG: archiver process (PID 17771) exited with exit code 1
unknown user 502

The archive command works if I copy and paste it into the Terminal under the postgres user. Any pointers as to what I'm doing wrong? Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-07-07 04:45:08 Re: failed archive command
Previous Message Joe Lester 2011-07-07 04:29:09 failed archive command