homebrew-postgresql
homebrew-postgresql copied to clipboard
Rebooting looses the cluster conf.d directory
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:
-
postgresql-common
-
[email protected]
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.
Can confirm—still an (annoying) issue.
I'm facing the same issue, @jschoolcraft your solution worked, thanks!