Skip site navigation (1) Skip section navigation (2)

Re: walreceiver fallback_application_name

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Magnus Hagander <magnus(at)hagander(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: walreceiver fallback_application_name
Date: 2011-01-17 03:05:22
Message-ID: AANLkTikOkCU3Af7VM2VgnmEVwPMOCTwikcgC0K8vge=f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Jan 17, 2011 at 11:16 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Sun, Jan 16, 2011 at 3:53 PM, Dimitri Fontaine
> <dimitri(at)2ndquadrant(dot)fr> wrote:
>> Magnus Hagander <magnus(at)hagander(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Greg SmithDate: 2011-01-17 03:13:59
Subject: Re: Spread checkpoint sync
Previous:From: Fujii MasaoDate: 2011-01-17 03:00:11
Subject: Re: Streaming base backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group