archive command failed with exit code 1

From: mallikarjun t <mallit333(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: archive command failed with exit code 1
Date: 2019-01-16 15:38:17
Message-ID: CAOA8XiW7u6BGJmkAvx2sWmDmGZkGJAuH4RiWTAy9-nfLsMzTwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)192(dot)168(dot)59(dot)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(at)192(dot)168(dot)59(dot)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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2019-01-16 15:45:19 Re: archive command failed with exit code 1
Previous Message Achilleas Mantzios 2019-01-16 15:24:40 pgBackRest : "ERROR: [042]: unexpected EOF reading line from remote process on" and stale pgbackrest processes hanging