RES: session_user different from current_user after normal login

[Murillo corvino rocha <murillo_corvinorocha@xxxxxxxxxxx>]

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
Enviado:quinta-feira, 17 de novembro de 2022 19:54
Para: Murillo corvino rocha; pgsql-general@xxxxxxxxxxxxxxxxxxxx
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="">

for more information.

>
> Murillo.
>


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx