Hi Pierre,
This problem is related to SSH, not to Postgres. You might be able to
find further help on the proper mailing list.
Anyway, to me it looks like you did not exchange SSH keys between hosts.
regards,
fabio pardi
On 10/31/18 10:03 AM, Pierre Ochsenbein wrote:
> Dear all,
>
> how to fix this error about ssh permission?
> I have build new ssh-key on the standby server but it doesn't work...
>
> primary server :
> ....
> debug2: we sent a publickey packet, wait for reply
> debug3: receive packet: type 51
> debug1: Authentications that can continue:
> publickey,gssapi-keyex,gssapi-with-mic
> debug1: Offering ECDSA public key: /var/lib/pgsql/.ssh/id_ecdsa
> debug3: send_pubkey_test
> debug3: send packet: type 50
> debug2: we sent a publickey packet, wait for reply
> debug3: receive packet: type 51
> debug1: Authentications that can continue:
> publickey,gssapi-keyex,gssapi-with-mic
> debug1: Trying private key: /var/lib/pgsql/.ssh/id_ed25519
> debug3: *no such identity: /var/lib/pgsql/.ssh/id_ed25519: No such file
> or directory*
> debug2: we did not send a packet, disable method
> debug1: No more authentication methods to try.
> Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
> -bash-4.2$
>
> standby server :
> *Permission denied (publickey,gssapi-keyex,gssapi-with-mic)*.^M
> rsync: connection unexpectedly closed (0 bytes received so far) [sender]
> rsync error: unexplained error (code 255) at io.c(226) [sender=3.1.2]
> 2018-10-31 04:58:59.005 EDT [9938] FATAL: archive command failed with
> exit code 255
> 2018-10-31 04:58:59.005 EDT [9938] DETAIL: The failed archive command
> was: rsync -a pg_wal/000000010000000000000001
> postgres@10.0.2.159:/home/postgresql_wal/000000010000000000000001
> 2018-10-31 04:58:59.007 EDT [15184] LOG: archiver process (PID 9938)
> exited with exit code 1
>
> Cheers