SSH Connection ask password for postgres user

Question

I would like to get $PGDATA from server with SSH connection under postgres user but I have some issues:

ssh postgres@myServer
postgres@myServer's password:

But I don't know the password and I don't want to use it or know it...

So I tried something else;

ssh -p NumPortOK postgres@myServer
ssh_exchange_identification: Connectionn closed by remote host

How can I connect with postgres and get $PGDATA please ?

If you don't want to use passwords, you can use ssh keys instead. — Khaled, Feb 22 '18 at 15:04
Do you have access to the server as sudo? can you check on `auth.log`?... — Alvaro Niño, Feb 22 '18 at 17:01
Try running `ssh-add` before ssh in. Some of my colleagues have this issue where their private key doesn't load by default and as a result, they are asked to enter the password. — Prav, Feb 22 '18 at 19:44

score 2 · Answer 1 · answered Feb 23 '18 at 10:37

I have the solution,

I'm connected with postgres user in my server sudo su - postgres

And I did that, to authorize the the local machine to connect in ssh:

mkdir .ssh chmod 700 .ssh touch .ssh/authorized_keys chmod 600 .ssh/authorized_keys

and take the public key from local machine: ssh-keygen -y and paste it in .ssh/authorized_keys in the server cat >> .ssh/authorized_keys -> Ctrl+D

Everything is okay to connect on ssh under postgres user :D (or any other user...)

SSH Connection ask password for postgres user

1 Answers1