Don't make "replication" magical as a user name, only as a database name, in pg_hba.conf.

adunstan · adunstan · commit 290bb9b61c64 · 2011-04-12T07:44:23.000-04:00
Per gripe from Josh Berkus. Backported from commit ed557a3.
diff --git a/src/backend/libpq/hba.c b/src/backend/libpq/hba.c
@@ -490,6 +490,8 @@ check_role(const char *role, Oid roleid, char *param_str)
 				return true;
 		}
 		else if (strcmp(tok, role) == 0 ||
+				 (strcmp(tok, "replication\n") == 0 && 
+				  strcmp(role,"replication") ==0) ||
 				 strcmp(tok, "all\n") == 0)
 			return true;
 	}

Original file line number	Diff line number	Diff line change
`@@ -490,6 +490,8 @@ check_role(const char role, Oid roleid, char param_str)`
`490`	`490`	`return true;`
`491`	`491`	`}`
`492`	`492`	`else if (strcmp(tok, role) == 0 \|\|`
	`493`	`+ (strcmp(tok, "replication\n") == 0 &&`
	`494`	`+ strcmp(role,"replication") ==0) \|\|`
`493`	`495`	`strcmp(tok, "all\n") == 0)`
`494`	`496`	`return true;`
`495`	`497`	`}`