Re: pg_primary_conninfo - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_primary_conninfo
Date
Msg-id 19080.1293548308@sss.pgh.pa.us
Whole thread Raw
In response to pg_primary_conninfo  (Magnus Hagander <magnus@hagander.net>)
Responses Re: pg_primary_conninfo  (Magnus Hagander <magnus@hagander.net>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "writable CTEs"
Next
From: Magnus Hagander
Date:
Subject: Re: pg_primary_conninfo