Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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-serverThanks & Regards,Shreeyansh DBA Teamwww.shreeyansh.comOn 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=postgresPermission 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/000000010000000000000001I am searching error information but I didn't know that? Could you please help me out situation ?ThanksAndRegards,Mallikarjunarao.
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=postgresPermission 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/000000010000000000000001I am searching error information but I didn't know that? Could you please help me out situation ?ThanksAndRegards,Mallikarjunarao.
В списке pgsql-admin по дате отправления: