Re: walreceiver fallback_application_name - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: walreceiver fallback_application_name
Date
Msg-id AANLkTikOkCU3Af7VM2VgnmEVwPMOCTwikcgC0K8vge=f@mail.gmail.com
Whole thread Raw
In response to Re: walreceiver fallback_application_name  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: walreceiver fallback_application_name  (Magnus Hagander <magnus@hagander.net>)
Re: walreceiver fallback_application_name  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On Mon, Jan 17, 2011 at 11:16 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sun, Jan 16, 2011 at 3:53 PM, Dimitri Fontaine
> <dimitri@2ndquadrant.fr> wrote:
>> Magnus Hagander <magnus@hagander.net> writes:
>>> Is "walreceiver" something that "the average DBA" is going to realize
>>> what it is? Perhaps go for something like "replication slave"?
>>
>> I think walreceiver is very good here, and the user is already
>> confronted to such phrasing.
>>
>>  http://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#GUC-MAX-WAL-SENDERS
>
> I agree that walreceiver is a reasonable default to supply in this case.

+1 though I could not find the mention to "walreceiver" in the doc.

> diff --git a/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c
> b/src/backend/replication/libpqwalreceiver/libpqwalreceiv
> index c052df2..962ee04 100644
> --- a/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c
> +++ b/src/backend/replication/libpqwalreceiver/libpqwalreceiver.c
> @@ -92,7 +92,7 @@ libpqrcv_connect(char *conninfo, XLogRecPtr startpoint)
>     * "replication" for .pgpass lookup.
>     */
>    snprintf(conninfo_repl, sizeof(conninfo_repl),
> -            "%s dbname=replication replication=true",
> +            "%s dbname=replication replication=true
> fallback_application_name=postgres",
>             conninfo);

Also the size of conninfo_repl needs to be enlarged.

Regards,

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


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Streaming base backups
Next
From: Greg Smith
Date:
Subject: Re: Spread checkpoint sync