About a recently-added permission-related error message - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject About a recently-added permission-related error message
Date
Msg-id 20230320.170541.1446670788521796869.horikyota.ntt@gmail.com
Whole thread Raw
Responses Re: About a recently-added permission-related error message
List pgsql-hackers
I found an error message added by de4d456b406bf502341ef526710d3f764b41e2c8.

When I incorrectly configured the primary_conninfo with the wrong
user, I received the following message on the server logs of both
servers involved in a physical replcation set.

[27022:walsender] FATAL:  permission denied to start WAL sender
[27022:walsender] DETAIL:  Only roles with the REPLICATION attribute may start a WAL sender process.

I'm not sure if adding the user name in the log prefix is a common
practice, but without it, the log line might not have enough
information. Unlike other permission-related messages, this message is
not the something human operators receive in response to their
actions. It seems similar to connection authorization logs where the
user name is important. So, I'd like to propose the following
alternative.

[27022:walsender] DETAIL:  The connection user "r1" requires the REPLICATION attribute.

What do you think about this change?

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Missing rules for queryjumblefuncs.{funcs,switch}.c for maintainer-clean
Next
From: Peter Eisentraut
Date:
Subject: Re: Timeline ID hexadecimal format