[pgpool-hackers: 4416] Re: Why pgpool.conf value of recovery_user is set to 'nobody'?

[Bo Peng]

Hi,

> I am fixing to make NULL string as default values for all three
> parameters, "recovery_user", "wd_lifecheck_user" &
> "health_check_user".
> Seeking an opinion here...

Thank you.

The default values will be discussed within the development team.
I will let you know once it has been decided.

On Thu, 18 Jan 2024 08:06:06 +0530
Sadhuprasad Patro <b.sadhu at gmail.com> wrote:

> On Thu, Jan 4, 2024 at 11:19 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
> >
> > Hello,
> >
> > It seems that it's just a question, so please post it to
> > pgpool-general at pgpool.net rather than pgpool-hackers at pgpool.net.
> > This ML is basically used for development purpose such as feature discussion.
> >
> > > > Wish you all a Very Happy New Year...
> > > >
> > > > Few parameters like recover_user, wd_lifecheck_user &
> > > > health_check_user0, in PgPool.conf file have default value as
> > > > 'nobody'. But in the code, the same has been set to zero-length
> > > > character string or NULL string...
> > > >
> > > > Why is it like this? Is there any specific reason?
> >
> > Could you please point out where is the code?
> 
> [sadhuprasad at localhost bin]$ ./psql --port=9999 -d postgres -c "PGPOOL
> SHOW recovery_user"
>  recovery_user
> ---------------
> 
> (1 row)
> 
> [sadhuprasad at localhost bin]$ ./psql --port=9999 -d postgres -c "PGPOOL
> SHOW wd_lifecheck_user"
>  wd_lifecheck_user
> -------------------
>  nobody
> (1 row)
> 
> 
> From "pgpool.conf.sample", we can see, the recovery_user parameter
> default value is 'nobody':
> 
> #------------------------------------------------------------------------------
> # ONLINE RECOVERY
> #------------------------------------------------------------------------------
> 
> #recovery_user = 'nobody'
>                                    # Online recovery user
> 
> 
> So there is a mismatch in default values mentioned in pgpool.conf file
> and SHOW recovery_user output.
> 
> >
> > I think the default values of "wd_lifecheck_user" and "health_check_user" are "nobody",
> > and the default value of "recovery_user" is "".
> 
> Yes, but I think we should have all default values as NULL String.
> Because 'nobody' also may be a user name :-)
> 
> I am fixing to make NULL string as default values for all three
> parameters, "recovery_user", "wd_lifecheck_user" &
> "health_check_user".
> Seeking an opinion here...


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/