Tony Dare <wadedare4703@xxxxxxxxxxx> writes: > I don't know if anyone else has had this problem but i found that the > /etc/init.d/postgresql script simply would not start up my databases > after a reboot. though it worked fine just after creating the database > and getting all the config files in the expected places. Was able to > down and up the dbs all day long, if I wished. Then I rebooted and there > was no databases started. Executing /etc/init.d/postgresql start 9.2 > resulted in "No database clusters on the system" or suchlike. > I tracked the problem down to the script calling on pg_lsclusters, which > in turn looks for a /var/run/postgresql directory. All well and good, > except that /var/run/postgresql is on a tempfs filesystem and is wiped > out after a reboot. (Q: should that even be on a tempfs?) You should complain about that to the Ubuntu packager (ie, file an Ubuntu bug). It's unlikely that that person reads this list ... regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin