PgAdmin One Dark Theme

PgAdmin One Dark Theme
This color scheme uses the same colors from the SSMS One Dark Theme I posted, it is just slightly different as pgAdmin does not have all of the same syntax highlighting options as SSMS. (Imagine that) For those interested I created this theme on a Windows 10 machine running pgAdminIII version 1.20. You can install ...

Postgres Orphaned Temp Tables

LOG: autovacuum: found orphan temp table “pg_temp_23″.”a_temp_table_temp” in database “productiondb” I recently came across this issue after performing a PITR (Point in Time Restore) on a Postgres Instance. The Log message from autovacuum was throwing multiple times a second, and I don’t know about you but I couldn’t stand to let my log fill up ...