Re: pg_basebackup with hostssl ?

On 2/2/22 07:48, Laura Smith wrote:
> 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 ?

I am not following. pg_basebackup is a stand alone client that is not
involved in replication other then establishing a starting point from
which to later establish a replication relationship.

The error is saying that whatever instance you are pointing
pg_basebackup at does not have entry in pg_hba.conf for the
host/user/encryption combination pg_basebackup is trying to connect as.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com