Hi,
when I used the postgres login 'replication' as the account for streaming replication I get the following error message:
2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server: FATAL: no pg_hba.conf entry for replication connection from host "172.16.56.122", user "replication", SSL off
The corresponding pg_hba.conf entry was correct and there was no other matching entry before that line.
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host replication replication
172.16.56.122/32 md5
By changing the account name - everything worked as smoth as I am used to with postgres.
Best Regards,
Uwe