Postgres Pro
Downloads
Home   >   mailing lists

Re: almost-super-user problems that we haven't fixed yet - Mailing list pgsql-hackers

From tushar
Subject Re: almost-super-user problems that we haven't fixed yet
Date
Msg-id CAC6VRoaG+Us2_9=qiF1nbuzUYoCOw_bp=mEu8imW0v+zn+rPyQ@mail.gmail.com
Whole thread Raw
In response to Re: almost-super-user problems that we haven't fixed yet  (tushar <tushar.ahuja@enterprisedb.com>)
Responses Re: almost-super-user problems that we haven't fixed yet
List pgsql-hackers
Tree view


On Thu, Jan 19, 2023 at 6:50 PM tushar <tushar.ahuja@enterprisedb.com> wrote:
and in the error message too 

[edb@centos7tushar bin]$ ./psql postgres -U r2

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  remaining connection slots are reserved for roles with privileges of pg_use_reserved_backends

[edb@centos7tushar bin]$ 
 

I think there is also a need to improve the error message if non super users are not able to connect due to slot unavailability. 
--Connect to psql terminal, create a user
create user t1;

--set these GUC parameters in postgresql.conf and restart the server

max_connections = 3                     # (change requires restart)

superuser_reserved_connections = 1      # (change requires restart)

reserved_connections = 1        


psql terminal ( connect to superuser),  ./psql postgres 
psql terminal (try to connect to user t1) ,  ./psql postgres -U t1 
Error message is 

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  remaining connection slots are reserved for roles with privileges of pg_use_reserved_backends



that is not true because the superuser can still able to connect, 

probably in this case message should be like this -

"remaining connection slots are reserved for roles with privileges of pg_use_reserved_connections and for superusers" or something better.


regards,


pgsql-hackers by date:

Previous
From: "2903807914@qq.com"
Date:
Subject: Re: Re: Support plpgsql multi-range in conditional control
Next
From: Peter Eisentraut
Date:
Subject: Re: ANY_VALUE aggregate