homebrew-postgresql icon indicating copy to clipboard operation
homebrew-postgresql copied to clipboard

Rebooting looses the cluster conf.d directory

Open jschoolcraft opened this issue 5 years ago • 2 comments

I'm not sure if this is the right place to report this or not. When I reboot my cluster's conf.d is missing and prevents me starting pg.

I have:

Set up clusters with:

pg_createcluster --locale en_US.UTF-8 --start 9.4 main -- -A trust --auth-host=trust

After a reboot:

pg_lsclusters
Ver Cluster Port Status Owner        Data directory                         Log file
9.4 main    5432 down   jschoolcraft /usr/local/var/lib/postgresql/9.4/main /usr/local/var/log/postgresql/postgresql-9.4-main.log

Trying to start:

pg_ctlcluster 9.4 main start
The PostgreSQL server failed to start. Please check the log output:
LOG:  could not open configuration directory "/usr/local/etc/postgresql/9.4/main/conf.d": No such file or directory
FATAL:  configuration file "/usr/local/etc/postgresql/9.4/main/postgresql.conf" contains errors

If I:

mkdir /usr/local/etc/postgresql/9.4/main/conf.d

Then pg_ctlcluster 9.4 main start works as expected.

jschoolcraft avatar Sep 27 '19 14:09 jschoolcraft

Can confirm—still an (annoying) issue.

voltechs avatar Feb 24 '21 23:02 voltechs

I'm facing the same issue, @jschoolcraft your solution worked, thanks!

matteo95g avatar Jul 25 '22 13:07 matteo95g