Re: no pg_hba.conf entry for replication connection from host - Mailing list pgsql-general

From Volkan Unsal
Subject Re: no pg_hba.conf entry for replication connection from host
Date
Msg-id CAMcqKmmj62hu1RvGDn4K4FhdMSVW9Da_3gLMc7ZSM3U7Zw=wcw@mail.gmail.com
Whole thread Raw
In response to Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

Could it be that pg_basebackup is still running and your CONNECTION LIMIT on the replication user is preventing any more connections?

They are literally back to back. I didn't log the disconnections at first, but when I turn that on you can see they disconnect back to back also. pg_basebackup finishes quickly. I can see its progrss from the standby server.

I removed the connection limit completely on the REP_USER, and also started trying to use the superuser for replications. It didn't make any difference alas.





--
Volkan Unsal
web and mobile development

pgsql-general by date:

Previous
From: Volkan Unsal
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host
Next
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host