I'm running Postgres16 on Windows server.
Start researching on pg_basebackup - when I execute the following command,
pg_basebackup.exe -h SERVERNAME -U postgres -p 5432 -D Z:\PostgreSQL\16\backups\ -Fp -Xs -P -R --checkpoint=fast --max-rate=1024M
I'm getting the following error:
> pg_basebackup: error: connection to server at "servername" port 5432
> failed: FATAL: no pg_hba.conf entry for replication connection from
> host, user "postgres", no encryption
I think it's because I added the SSPI connections .
I have the following entries before the sspi but still getting error
host all all 0.0.0.0/0 scram-sha-256
host all all 127.0.0.1/32 scram-sha-256
host all all ::0/0 sspi map=sspi
How do I fix pg_hba so I can use sspi for certain usernames will able to allow connections for local logins (much like mixed mode in MSSQL)?
Thank you
Asked by Student
(29 rep)
Dec 18, 2023, 09:08 PM
Last activity: Dec 18, 2023, 11:45 PM
Last activity: Dec 18, 2023, 11:45 PM