
Time zones are an unfortunately complex subject when dealing with PostgreSQL. You may be running your local time zone on your on-premises server or on your own laptop. Or you may be using the time zone of your server’s physical location.…

The archiver only runs when a WAL segment is complete. On a busy database that happens constantly; on a quiet one it might not happen for hours or days. archive_timeout exists to prevent the resulting “our database has been accepting…

Hello everyone, here comes a series of my annual posts about the Chicago Postgres Conference, and what I am most excited about. And I want to start with the training sessions we offer. All three training sessions are presented by my…
PgBackRest Is Dead Yesterday the maintainer of PgBackRest, David Steele, published the NOTICE OF OBSOLESCENCE. For further information please read the blog post pgBackRest is dead. Now what? by Lætitia Avrot. She also points to how to go…