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

Hi Mallikarjunarao,

It looks ssh-keygen does not set between your postgres users and make sure you are entering the correct password.

Also, verify postgres user owner permission for the target archive directory if not.

Go through the below link for ssh-keygen.

https://www.digitalocean.com/community/tutorials/how-to-configure-ssh-key-based-authentication-on-a-linux-server

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

On Wed, Jan 16, 2019 at 9:08 PM mallikarjun t <mallit333@gmail.com> wrote:

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.