scram-sha-256 Authentication Configuration To perform the password-based authentication, Pgpool-II requires a password file which contains a list of database users and passwords in format username:password. The…
View More How to Configure SCRAM and MD5 Authentication in Pgpool-II
In Postgres and Oracle schemas and users (roles) are different entities. When you create a user in Oracle it is a schema at the same…
View More Schema vs User (Role) in Postgres
How to kill long running queries or IDLE queries of a user or another session of user itself. you can create one function and assign…
View More Non-Superuser kill own session in PostgreSQL