Re: Ubuntu Precise and auto startup of pg databases

Tony Dare <wadedare4703@comcast.net> 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