My DBA Notebook

Postgres women founder, PostgreSQL Europe treasurer, PostgreSQL recognized contributor.
Practice Leader, Postgres & Security at EDB.
Opinions are my own.

2024

Jun 5

A Tuning Guide: a good starting point

PostgreSQL Administration Performance

2023

Jan 2

Don't do this: creating useless indexes

PostgreSQL Administration PGSQL Phriday

2022

Nov 4

How to do proper backups

PostgreSQL PGSQL Phriday Administration

2021

Sep 30

3 ways to auto-increment with Postgres

Administration PostgreSQL

Sep 17

pglog, a flexible and simple log analyzer

Administration PostgreSQL

Apr 4

A Tip a day takes the GUI away!

Administration PostgreSQL

Mar 21

No space left on device

Administration PostgreSQL Troubleshooting

Feb 26

Simply auditing your database changes

Administration PostgreSQL

Jan 29

The vicious circle of huge writes

PostgreSQL Administration

2020

Dec 16

Replica identity for logical replication

PostgreSQL Administration

Dec 1

Is my port open?

PostgreSQL Administration

Apr 19

Where do my Postgres settings come from ?

Hacking PostgreSQL Administration

Mar 30

Can't connect to Postgres

Administration PostgreSQL Troubleshooting

Mar 22

What's wrong with Postgres?

Administration PostgreSQL Troubleshooting

Mar 20

Is Postgres running ?

Administration PostgreSQL Troubleshooting

2019

Oct 22

SSO on Postgres with Active Directory : troubleshooting

Administration PostgreSQL

Sep 7

Managing conf files

Administration PostgreSQL

Jan 23

Testing replication connections

PostgreSQL Administration