Postgres Pro
Downloads
Home   >   mailing lists

archive command failed with exit code 1 - Mailing list pgsql-admin

From mallikarjun t
Subject archive command failed with exit code 1
Date
Msg-id CAOA8XiW7u6BGJmkAvx2sWmDmGZkGJAuH4RiWTAy9-nfLsMzTwQ@mail.gmail.com
Whole thread Raw
Responses Re: archive command failed with exit code 1
Re: archive command failed with exit code 1
List pgsql-admin
Tree view
Hi,

This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version. In  SSL streaming replication I am facing following issues.

alter system set archive_command to 'scp %p postgres@192.168.59.149:/home/postgres/data_archive/%f';

<2019-01-15 21:38:38.648 IST [4599]>LOG:  connection received: host=192.168.59.149 port=41464
<2019-01-15 21:38:38.656 IST [4599]>LOG:  replication connection authorized: user=postgres
Permission denied, please try again.
Permission denied, please try again.
Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).
lost connection
<2019-01-15 21:38:38.950 IST [4333]>LOG:  archive command failed with exit code 1
<2019-01-15 21:38:38.950 IST [4333]>DETAIL:  The failed archive command was: scp pg_xlog/000000010000000000000001 postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000001


I am searching error information but I didn't know that? Could you please help me out situation ?

ThanksAndRegards,
Mallikarjunarao.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: pgBackRest : "ERROR: [042]: unexpected EOF reading line from remoteprocess on" and stale pgbackrest processes hanging
Next
From: Fabio Pardi
Date:
Subject: Re: archive command failed with exit code 1