Postgres – Page 5

Linux Postgres

Adding postgres as SUDOERS in centos

Postgres

How to Configure SCRAM and MD5 Authentication in Pgpool-II

Bulent Soylu December 26, 2021 AES authentication md5 pg_enc pg_md5 pgpool

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…

Postgres

Schema vs User (Role) in Postgres

Bulent Soylu December 25, 2021 postgresql read-only user read-write user schema schema vs role user vs role

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…

Postgres

Non-Superuser kill own session in PostgreSQL

Bulent Soylu December 11, 2021 non-superuser pg_cancel_backend

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…

Postgres

PostgreSQL Replication Slots

Bulent Soylu November 13, 2021 postgres 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…

Postgres

Vacuum problems solving

Bulent Soylu November 13, 2021 postgres vacuum

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…

Postgres

PostgreSQL 14 Streaming Replication (Sync / Async) on CentOS 7

Bulent Soylu November 13, 2021 async master pg_basebackup postgres primary replication slave standby sync

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…