From: | Joshua Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Bug in pg_hba.conf or pg_basebackup concerning replication connections |
Date: | 2011-04-09 18:23:10 |
Message-ID: | 1058774855.53202.1302373390729.JavaMail.root@mail-1.01.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
All,
If I have the following line in pg_hba.conf:
host replication replication all md5
pg_basebackup -x -v -P -h master1 -U replication -D $PGDATA
pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry for replication connection from host "216.121.61.233", user "replication"
But, if I change it to "all" users, replication succeeds:
host replication all all md5
... even if the user "postgres" (the only other user in this test) is declared "with noreplication".
I can't figure out what's going wrong here; either HBA is broken and won't accept a replication line unless user is "all", or pgbasebackup is doing something to test a connection as "postgres", even though no such connection attempt shows up in the logs.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Berkus | 2011-04-09 18:26:14 | Feature request: pg_basebackup --force |
Previous Message | David Fetter | 2011-04-09 18:00:19 | Re: Evaluation of secondary sort key. |