Sample Header Ad - 728x90

Error running pg_basebackup

1 vote
1 answer
1354 views
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