Re: pg_primary_conninfo

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Magnus Hagander <magnus@hagander.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-12-28T14:58:28Z
Lists: pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> Attached patch implements a function called pg_primary_conninfo() that
> returns, well, the primary_conninfo used on the standby when in
> streaming replication mode (otherwise NULL).

> Objections?

What's the use case?  And aren't there security reasons to NOT expose
that?  It might contain a password for instance.

> + 	if (recptr.xlogid == 0 && recptr.xrecoff == 0 && conninfo[0] != '\0')
> + 		PG_RETURN_NULL();

This test seems a bit incoherent.

			regards, tom lane