New answers tagged

1 vote

What does psql do on connect (that could be taking 1 to 10 minutes)?

So psql was a bit of a red herring... it was mostly this: ~10k in pg_roles And the fact that the connecting user connecting was GRANTed many of these roles, which were themselves each granted many ...
Michal Charemza's user avatar
0 votes

Difference between Authentication, session, outer and current user in postgres

"Authenticated user" is the same as "session user", except that the latter can be changed with SET SESSION AUTHORIZATION by a superuser. The "current user" is the ...
Laurenz Albe's user avatar
  • 51.7k

Top 50 recent answers are included