Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
![]() |
![]() |
![]() |
5 Sample BART System with Local and Remote Database Servers : 5.2 Establishing SSH/SCP Password-Less Connections : 5.2.5 Configuring Access from Remote PostgreSQL to BART Host
On the remote host 192.168.2.24, create the public key file for the remote database server user account, postgres, for access to the BART user account, enterprisedb, on the BART host 192.168.2.22.This is for scenario 1 as described in the Required BART Connections with No Password section of the EDB Postgres Backup and Recovery Installation and Upgrade Guide.Create and copy the generated public key file, id_rsa.pub, to the BART user account, enterprisedb, on the BART host, 192.168.2.22:Log into the BART host as the BART user account and append the temporary public key file, /tmp/tmp.pub, onto the authorized_keys file owned by the BART user account.Make sure the authorized_keys file has file permission 600 as shown, otherwise the password-less connection fails.Test the password-less connection. From the remote host, while logged in as user account postgres, verify that you can log into the BART host with the BART user account without being prompted for a password:
5 Sample BART System with Local and Remote Database Servers : 5.2 Establishing SSH/SCP Password-Less Connections : 5.2.5 Configuring Access from Remote PostgreSQL to BART Host
![]() |
![]() |
![]() |