Skip to content
Friday, May 09, 2025

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
  • mongodb
DBA Notes

Categories

  • AWS (9)
  • Docker (7)
  • General (4)
  • Linux (14)
  • mongodb (1)
  • MySQL (10)
  • notepad++ (2)
  • Oracle (90)
  • performance (44)
  • Postgres (92)
  • postgresql (8)
  • SQL (16)
  • Windows (7)

Month: November 2021

Linux

How to Configure and Use PAM in Linux

Bulent Soylu November 26, 2021 linuxpam

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
Postgres

PostgreSQL Replication Slots

Bulent Soylu November 13, 2021 postgresreplication 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
Postgres

Vacuum problems solving

Bulent Soylu November 13, 2021 postgresvacuum

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
Postgres

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

Bulent Soylu November 13, 2021 asyncmasterpg_basebackuppostgresprimaryreplicationslavestandbysync

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
Postgres

Replication Slots in PostgreSQL ?

Bulent Soylu November 12, 2021 postgresreplicationreplication slots

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 ?
Postgres

Postgresql-14 Installation on Centos 7

Bulent Soylu November 12, 2021 postgres

yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

View More Postgresql-14 Installation on Centos 7
Postgres

Integrate LDAP with local users in PostgreSQL

Bulent Soylu November 10, 2021 LDAPpg_hba.confpostgres

You want to allow LDAP users can use their passwords in login but you don’t want to create non-person accounts like application users in LDAP.…

View More Integrate LDAP with local users in PostgreSQL
Log in

oracle (86)postgres (51)performance (37)postgresql (32)index (11)upgrade (9)linux (9)multitenant (7)pdb (6)partitioning (6)docker (6)windows (5)memory (5)mysql (5)replication (5)execution plan (5)aws (5)sql profiles (4)tuples (4)SQL (4)

Recent Posts

  • 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝘆 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗢𝗿𝗱𝗲𝗿!
  • TABLE FRAGMENTATION IN ORACLE DATABASE
  • Configuring Huge Pages for MySQL Server on Red Hat Linux
  • HUGE PAGES AND POSTGRESQL
  • How to configure HugePages for Oracle Database Server

Archives

  • October 2024 (1)
  • August 2024 (1)
  • March 2024 (3)
  • January 2024 (3)
  • December 2023 (7)
  • October 2023 (17)
  • September 2023 (6)
  • August 2023 (23)
  • July 2023 (10)
  • June 2023 (4)
  • May 2023 (11)
  • April 2023 (15)
  • March 2023 (6)
  • February 2023 (2)
  • January 2023 (11)
  • December 2022 (1)
  • August 2022 (3)
  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved