connection error barman -> postgres server

111 views
Skip to first unread message

dulh...@mailbox.org

unread,
Dec 2, 2021, 5:27:38 PM12/2/21
to pgba...@googlegroups.com
I am testing the connection from the barman backup server to my postgres server with this command

psql -c 'SELECT version()' -U barman -h hostnam.org postgres

which returns the error below

no pg_hba.conf entry for host "10.4.253.209", user "barman", database "postgres", SSL off

eventhoug I have this line in the pg_hba.conf

host postgres barman 10.4.253.209 trust   (the same error occurs with md5 instead of trust)

can anybody provide me with a hint on what is going wrong here? expecially the SSL off part is confusing to me

dulh...@mailbox.org

unread,
Dec 3, 2021, 3:18:07 AM12/3/21
to pgba...@googlegroups.com
On 12/02/2021 11:27 PM dulhaver via Barman, Backup and Recovery Manager for PostgreSQL <pgba...@googlegroups.com> wrote:

I am testing the connection from the barman backup server to my postgres server with this command
psql -c 'SELECT version()' -U barman -h hostnam.org postgres

which returns the error below
no pg_hba.conf entry for host "10.4.253.209", user "barman", database "postgres", SSL off

eventhoug I have this line in the pg_hba.conf
host postgres barman 10.4.253.209 trust   (the same error occurs with md5 instead of trust)
I simply missed the subet mask /24 in the ADDRESS section

host postgres barman 10.4.253.209/24 trust
Reply all
Reply to author
Forward
0 new messages