How CURSOR_SHARING works in ORACLE?CURSOR_SHARING determines what kind of SQL statements can share the same cursors. The possible values are EXACT which is the default value and…
View More CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
Adding postgres as SUDOERS in centos
Login as root: :wq!
View More Adding postgres as SUDOERS in centos
How to Configure SCRAM and MD5 Authentication in Pgpool-II
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
Schema vs User (Role) in Postgres
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
Non-Superuser kill own session in PostgreSQL
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
How to Configure and Use PAM in Linux
Linux-PAM (short for Pluggable Authentication Modules which evolved from the Unix-PAM architecture) is a powerful suite of shared libraries used to dynamically authenticate a user to applications (or…
View More How to Configure and Use PAM in Linux
PostgreSQL Replication Slots
Back in the days when “Replication Slots” were not yet introduced, managing the WAL segments were a challenge. In standard streaming replication, the master has…
View More PostgreSQL Replication Slots
Vacuum problems solving
Why VACUUM?Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid of them so that the space…
View More Vacuum problems solving
PostgreSQL 14 Streaming Replication (Sync / Async) on CentOS 7
Using High Availability is a requirement for companies all over the world. Streaming replication allows a standby server to stay more up-to-date than is possible…
View More PostgreSQL 14 Streaming Replication (Sync / Async) on CentOS 7
Replication Slots in PostgreSQL ?
What are WAL Files? Write-Ahead Log (WAL) is a record of the changes made to the data. It ensures that when there is a crash…
View More Replication Slots in PostgreSQL ?