Re: archive command failed with exit code 1

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(at)gmail(dot)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(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.
>
>