Re: no pg_hba.conf entry for replication connection from host

From: Volkan Unsal <spocksplanet(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Melvin Davidson <melvin6925(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: no pg_hba.conf entry for replication connection from host
Date: 2015-04-09 21:41:40
Message-ID: CAMcqKmmj62hu1RvGDn4K4FhdMSVW9Da_3gLMc7ZSM3U7Zw=wcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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*
volkanunsal.com <http://bit.ly/1h1ebjy>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-04-09 21:53:33 Re: no pg_hba.conf entry for replication connection from host
Previous Message Volkan Unsal 2015-04-09 21:38:25 Re: no pg_hba.conf entry for replication connection from host