Re: archive command failed with exit code 1

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: archive command failed with exit code 1
Дата
Msg-id CAGDYbUP0bV_TWxK2ynowE6iMvzVqXFp3KmQ7vz47g-wYE2nyyw@mail.gmail.com
обсуждение исходный текст
Ответ на archive command failed with exit code 1  (mallikarjun t <mallit333@gmail.com>)
Ответы Re: archive command failed with exit code 1  (mallikarjun t <mallit333@gmail.com>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
Следующее
От: mallikarjun t
Дата:
Сообщение: Re: archive command failed with exit code 1