From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tony Dare <wadedare4703@comcast.net>
cc: pgsql-admin@postgresql.org
Subject: Re: Ubuntu Precise and auto startup of pg databases
In-reply-to: <51C50E33.1020109@comcast.net>
References: <51C50E33.1020109@comcast.net>
Comments: In-reply-to Tony Dare <wadedare4703@comcast.net>
 message dated "Fri, 21 Jun 2013 19:38:43 -0700"
Date: Sat, 22 Jun 2013 15:49:22 -0400
Message-ID: <23767.1371930562@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin