Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.

On Sat, Mar 20, 2010 at 4:19 AM, Simon Riggs <sriggs(at)postgresql(dot)org> wrote:
> Log Message:
> -----------
> 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.

LOG: connection authorized: user=foo database=replication

Currently, when the primary accepts the connection from the standby,
it emits the above message. But "database=replication" is not accurate
because no "database" is supplied by the standby unless it's explicitly
specified in primary_conninfo parameter. So, how about changing the
message as follow?

LOG: replication connection authorized: user=foo

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center