RES: session_user different from current_user after normal login

[Murillo corvino rocha]

No, I’m using a clean psql docker container everytime I need to connect to the 
database like below:

docker run -it --rm postgres psql -d database -h host -U user1


Murillo.

De: Adrian Klaver<mailto:adrian.kla...@aklaver.com>
Enviado:quinta-feira, 17 de novembro de 2022 19:54
Para: Murillo corvino rocha<mailto:murillo_corvinoro...@hotmail.com>; 
pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org>
Assunto: Re: RES: session_user different from current_user after normal login

On 11/17/22 13:26, Murillo corvino rocha wrote:
> I am just logging in (using psql) and doing the select: SELECT
> session_user, current_user;
>
> The PostgreSQL is an AWS RDS 12.12 instance. No script is being
> executed. No one besides me is connected to the database. Could it be
> any server level configuration? I’m pretty sure that few configurations
> were made to this database.

Is there a psqlrc file that has SET ROLE group_read_only;?

See the:

Files

psqlrc and ~/.psqlrc

section here:

https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fapp-psql.html&amp;data=05%7C01%7C%7Cc83926a17401426a2a0108dac8eebb62%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638043224916120207%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=Ut5e4LHw0nElI7xA6EL3v59LPApIn95RAfUpK1Mvq%2FQ%3D&amp;reserved=0

for more information.

>
> Murillo.
>


--
Adrian Klaver
adrian.kla...@aklaver.com