Обсуждение: Backup Issue for pg_basebackup
pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL on
FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e
Hello,
This is a specific error. You need to specify the IP information of the server where you are providing the replica and the user that will perform the replication in pg_hba.conf on the main cluster. You can find examples of this in many sources.
Have a nice day.
We are getting below error when running pg_basebackup for a database.pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL on
FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e
Hello,
This is a specific error. You need to specify the IP information of the server where you are providing the replica and the user that will perform the replication in pg_hba.conf on the main cluster. You can find examples of this in many sources.
Have a nice day.
We are getting below error when running pg_basebackup for a database.pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL on
FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e
On Fri, 2025-01-31 at 10:42 +0530, Somnath Som wrote: > We are getting below error when running pg_basebackup for a database. > > pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSLon > FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e Add an entry like host replication postgres 127.0.0.1/32 trust Reload PostgreSQL, and you should be fine. Yours, Laurenz Albe
On Fri, 2025-01-31 at 10:42 +0530, Somnath Som wrote: > We are getting below error when running pg_basebackup for a database. > > pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSLon > FATAL: no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e Add an entry like host replication postgres 127.0.0.1/32 trust Reload PostgreSQL, and you should be fine. Yours, Laurenz Albe