Re: archive command failed with exit code 1

Hi,
I resolved my issue. Everyone to thanks a lot.

ThanksAndRegards,
Mallikarjunarao.

On Thu, Jan 17, 2019 at 4:43 PM mallikarjun t <mallit333(at)gmail(dot)com> wrote:

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