PostgreSQL invalid listen_addresses

Annexe

This post originally appeared on the Annexe.

So now when I restarted Postgres:

Error: Invalid line 603 in /etc/postgresql/9.3/main/postgresql.conf: \
>listen_addresses="localhost,10.0.1.2"

See the bug? Yes, double quotes instead of single. From postgresql.conf:

listen_addresses='localhost, 10.0.1.2'

It’s been a long Monday!

Author bio and support

Me!

Ruben Schade is a technical writer and infrastructure architect in Sydney, Australia who refers to himself in the third person in bios. Hi!

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

If you found this post helpful or entertaining, you can shout me a coffee or send a comment. Thanks ☺️.