On 12/17/2014 02:53 PM, pauld@jobready.com.au wrote:
> I have the following pg_hba entry on a PostgreSQL server (10.A.B.C)
>
> host repmgr all 10.X.Y.Z/32 trust
>
> (the user repmgr was created using "createuser --login --superuser repmgr"
> via the postgres system account)
You mixed up the "database" and "user" columns in pg_hba.conf. The
syntax is:
# host DATABASE USER ADDRESS METHOD [OPTIONS]
So your trust-entry above applies to all users connecting to "repmgr"
database. Try:
host all repmgr 10.X.Y.Z/32 trust
- Heikki