Re: archive command failed with exit code 1

Thanks, I will check it out.

On Thu, Jan 17, 2019 at 4:39 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:

> 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.
>>
>>