Answer the question
In order to leave comments, you need to log in
Passwordless ssh access for Postgres user?
OC Centos 7.3.1611. The postgresql-server package is installed. Need passwordless access for the postgres user from one host to another host. Access is not to the database, but to the system itself.
The following steps have been taken
1) passwd postgres
2) su postgres
3) ssh-keygen
4) ssh-copy-id - at this stage, the password from point 1 is requested
. Similarly, on the second host. Passwordless access is not configured. id_rsa.pub and authorized_keys are the same.
Permissions for files and folders:
1) ~/.ssh 0700
2) ~/.ssh/authorized_keys 0600 Asks
for a password when connecting.
Maybe someone dealt with a similar problem, I ask for advice.
Answer the question
In order to leave comments, you need to log in
You did everything wrong)
1. Go to psql.
2. SHOW hba_file;
3. Google and read about pg hba
4. Correctly set up access (trust) and restart the service.
5. ...
6. profit!!!
If you meant that you need encryption, then read the section about hostssl especially carefully
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question