Postgres Pro
Downloads
Home   >   mailing lists

replication requires redundant rule in pga_hba? - Mailing list pgsql-general

From Wells Oliver
Subject replication requires redundant rule in pga_hba?
Date
Msg-id CAOC+FBWbSVWg5rZXFyCpqn_Cek6DFvkD03o+T2rMYpHV3uX4yA@mail.gmail.com
Whole thread Raw
Responses Re: replication requires redundant rule in pga_hba?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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@gmail.com

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Tables with lots of dead tuples despite autovacuum
Next
From: Tom Lane
Date:
Subject: Re: replication requires redundant rule in pga_hba?