From 6a771d1d367d7e204edf78aee3f069f1b5ba36db Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Fri, 19 Mar 2010 19:19:38 +0000 Subject: Add connection messages for streaming replication. log_connections was broken for a replication connection and no messages were displayed on either standby or primary, at any debug level. Connection messages needed to diagnose session drop/reconnect events. Use LOG mode for now, discuss lowering in later releases. --- src/backend/utils/init/postinit.c | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'src/backend/utils/init/postinit.c') diff --git a/src/backend/utils/init/postinit.c b/src/backend/utils/init/postinit.c index 01cb07da2d3..026ee474844 100644 --- a/src/backend/utils/init/postinit.c +++ b/src/backend/utils/init/postinit.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/init/postinit.c,v 1.204 2010/02/26 02:01:13 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/init/postinit.c,v 1.205 2010/03/19 19:19:38 sriggs Exp $ * * *------------------------------------------------------------------------- @@ -217,7 +217,14 @@ PerformAuthentication(Port *port) if (!disable_sig_alarm(true)) elog(FATAL, "could not disable timer for authorization timeout"); - if (Log_connections) + /* + * Log connection for streaming replication even if Log_connections disabled. + */ + if (am_walsender) + ereport(LOG, + (errmsg("connection authorized: user=%s database=replication", + port->user_name))); + else if (Log_connections) ereport(LOG, (errmsg("connection authorized: user=%s database=%s", port->user_name, port->database_name))); -- cgit v1.2.3