replication requires redundant rule in pga_hba?

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: replication requires redundant rule in pga_hba?
Date: 2012-09-13 02:22:53
Message-ID: CAOC+FBWbSVWg5rZXFyCpqn_Cek6DFvkD03o+T2rMYpHV3uX4yA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems like the following is redundant:

host all all 0.0.0.0/0 md5
hostnossl replication replicationuser 0.0.0.0/0 md5

The first one allows either SSL or non SSL to all users for all DBs from
any address via MD5. Good for everything, no? Yet if I remove the second
line, I see a bunch of:

FATAL: no pg_hba.conf entry for replication connection from host 10....,
user "replicationuser", SSL off

Why is this? What am I missing?

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-09-13 02:28:14 Re: replication requires redundant rule in pga_hba?
Previous Message Jeff Janes 2012-09-13 02:18:41 Re: Tables with lots of dead tuples despite autovacuum