pg_basebackup with hostssl ?

From: Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>
To: postgre <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_basebackup with hostssl ?
Date: 2022-02-02 15:48:17
Message-ID: u4Ap-j-o9BPs6E3w5BxzpDTvGCzkTspSkq6Nn56_lHoDWbWH14IUa8UkUTNRkHczE4wuIpAXLe5ucMGQZ-w1UVJf78BfrtyAygZXWYkBMpc=@protonmail.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've had a quick glance through the man page for pg_basebackup but can't see any flags to set ssl.

Long story short, I've got the following in pg_hba.conf of the master:
hostssl replication all 10.0.0.0/8 md5

But the slave is complaining:
FATAL: no pg_hba.conf entry for replication connection from host "10.1.2.3", user "myrepl", no encryption

I suspect this is almost certainly because I'm using "hostssl" instead of "host".

But other than the obvious and undesirable quick-fix, how should I be calling pg_basebackup to make sure it uses encryption ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-02-02 16:30:16 Re: pg_basebackup with hostssl ?
Previous Message David G. Johnston 2022-02-02 15:22:46 Re: Regular Expression For Duplicate Words