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.klaver@aklaver.com