Monday Postgres derp


Reloading a test Postgres server:

# /etc/init.d/postgresql reload
==>* Reloading PostgreSQL 9.3 database server
==>* pg_ctl: PID file "/var/lib/postgresql/9.3/main/" \
==> does not exist  [fail]

The problem? Yes, I attempted to reload a service I hadn’t started.

# /etc/init.d/postgresql start
==> * Starting PostgreSQL 9.3 database server    [ OK ] 

This is why people regard me as a professional.

Author bio and support


Ruben Schade is a technical writer and IaaS engineer in Sydney, Australia who refers to himself in the third person in bios. Wait, not BIOS… my brain should be EFI by now.

The site is powered by Hugo, FreeBSD, and OpenZFS on OrionVM, everyone’s favourite cloud infrastructure provider.

If you found this post helpful or entertaining, you can shout me a coffee or buy some silly merch. Thanks!