inchirags@gmail.com Chirag PostgreSQL DBA Tutorial https://www.chirags.in ************************************************************************************* How to Configure Nagios to Monitor a PostgreSQL 16 Database with Dashboards on Ubuntu 24.0...
Case Study create a database for bootcamp registration Flow main day-1 : open registration bootcamp day-2 : incoming registrants day-3 : assessment >= 60 = accepted, < 59-40 = reserve, <40 = rejected day-5 : remove those with lower scores and i...
First open and login to database Guest Book Problem context : Classes often have visitors (parents, alumni, stationery suppliers). It's important to note who's coming, what they need, and their contact information—so you can easily follow up. Main...
inchirags@gmail.com Chirags PostgreSQL DBA Tutorial https://www.chirags.in ************************************************************************************* PostgreSQL 16 pg_basebackup and Point in Time Recovery **********************************...
Today i want to create Database and ERD with case study is an exit permission for student in Dormitories Go to gemini and write like this if you already understand, go to draw.io, for create ERD create 3 list, for teacher, student, and licensi...
inchirags@gmail.com Chirag's PostgreSQL DBA Tutorial https://www.chirags.in ********************************************************************************************************* Manage Replication and Failover on a PostgreSQL 16 Cluster Using rep...
I recently started learning Odoo — exploring how it works and how it can actually solve real problems for enterprises. As the first step in my learning journey, I set up a local instance using Docker and Docker Compose. In my first article, I promise...
Welcome to Part 5 of the Ubuntu home lab series. This part expands on our Podman setup by deploying more advanced services inside containers. We’ll run PostgreSQL with pgAdmin in a shared Pod, Node-RED for workflows, and Homarr for a beautiful home l...
The world revolves around data. Economies are driven on data, intelligence is shaped on data, conglomerates rise and fall on data and most importantly, social mindset is constructed on data, whether by the consumer or not. You need to persist the ing...
Disaster recovery (DR) in PostgreSQL is a business-critical necessity, not just a technical requirement. From unexpected hardware failures to accidental data deletions, a robust DR plan ensures minimal downtime and faster recovery. Why It Matters: S...