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
Date: Sat, 22 Jun 2013 15:49:22 -0400
Message-ID: <23767.1371930562@sss.pgh.pa.us> (raw)
In-Reply-To: <51C50E33.1020109@comcast.net>
References: <51C50E33.1020109@comcast.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, wadedare4703@comcast.net
Subject: Re: Ubuntu Precise and auto startup of pg databases
In-Reply-To: <23767.1371930562@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox