pgBackRest 2.07 and macOS Mojave

Hunleyd, Nov 16, 2018, Postgresql Osx Howto

pgBackRest 2.07 was announced today. As usual, I immediately downloaded it and tried to get it up and running on my MacBook (currently running Mojave).

#Postgresql, #Osx, #Howto,

read more

Monitoring pgBackRest with tail_n_mail

Hunleyd, Sep 24, 2018, Postgresql Howto

After a lively discussion at work today about monitoring tools and use cases, I decided to see if I could use tail_n_mail, which I already use to monitor my PostgreSQL logs, to monitor my pgBackRest logs.

#Postgresql, #Howto,

read more

pgBouncer and auth pass-through

Hunleyd, Aug 7, 2018, Postgresql

I’ve noticed several individuals inquiring lately about pgBouncer and how they can avoid putting all users and their passwords in it’s auth_file.

#Postgresql,

read more

Upgrading PostgreSQL from 9.4 to 10.3 with pglogical

Hunleyd, Apr 5, 2018, Postgresql Howto

I recently helped a customer upgrade their PostgreSQL instance from 9.

#Postgresql, #Howto,

read more

updated PostgreSQL homebrew script

Hunleyd, Oct 16, 2017, Postgresql Osx Howto

With the release of PostgreSQL 10, I’ve updated my pg script.

#Postgresql, #Osx, #Howto,

read more