pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUbuntu Precise and auto startup of pg databases
4+ messages / 4 participants
[nested] [flat]
* Ubuntu Precise and auto startup of pg databases
@ 2013-06-22 02:38 Tony Dare <wadedare4703@comcast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tony Dare @ 2013-06-22 02:38 UTC (permalink / raw)
To: pgsql-admin
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?)
The start command in /etc/init.d/postgresql does this check and then
executes the function that will/can create the /var/run/postgresql if
the aforementioned check passes...which it won't. So instead you get a
message that there are no database clusters on the server.
It's a fairly new install of 12.04 and I was wondering if subsequent
updates take care of it or am I going to have to hack the start/stop
script and maintain that over package updates?
Ubuntu 12.04
postgresql 9.2.0.4
x86_64
2 CPUs
Thanks
Tony Dare
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Ubuntu Precise and auto startup of pg databases
@ 2013-06-22 19:49 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tony Dare <wadedare4703@comcast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2013-06-22 19:49 UTC (permalink / raw)
To: Tony Dare <wadedare4703@comcast.net>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Ubuntu Precise and auto startup of pg databases
@ 2013-06-22 23:16 Christofer C. Bell <christofer.c.bell@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Christofer C. Bell @ 2013-06-22 23:16 UTC (permalink / raw)
To: pgsql-admin
On Sat, Jun 22, 2013 at 2:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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 ...
I'm not sure even that's appropriate. The version of PostgreSQL that comes
with Ubuntu 12.04, is 9.1, not 9.2 (there's an option for 8.3). Either the
original poster has made a typo in his post, or he's installed PostgreSQL
either by hand or from an unofficial package repository.
I have been using PostgreSQL 9.1 for months under Ubuntu 12.04 LTS, as
installed from the Ubuntu repositories, without any issue whatsoever.
--
Chris
"If you wish to make an apple pie from scratch, you must first invent the
Universe." -- Carl Sagan
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Ubuntu Precise and auto startup of pg databases
@ 2013-06-27 21:26 Magnus Hagander <magnus@hagander.net>
parent: Christofer C. Bell <christofer.c.bell@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2013-06-27 21:26 UTC (permalink / raw)
To: Christofer C. Bell <christofer.c.bell@gmail.com>; +Cc: pgsql-admin
On Sun, Jun 23, 2013 at 1:16 AM, Christofer C. Bell
<christofer.c.bell@gmail.com> wrote:
> On Sat, Jun 22, 2013 at 2:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> 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 ...
>
>
> I'm not sure even that's appropriate. The version of PostgreSQL that comes
> with Ubuntu 12.04, is 9.1, not 9.2 (there's an option for 8.3). Either the
> original poster has made a typo in his post, or he's installed PostgreSQL
> either by hand or from an unofficial package repository.
The repository at apt.postgresql.org fully supports 9.2 on Ubuntu
12.04, so it could be that.
However, the version referenced is postgresql 9.2.0.4, which is not a
PostgreSQL version number. But if it means 9.2.4, then that could
certainly be it.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-06-27 21:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-06-22 02:38 Ubuntu Precise and auto startup of pg databases Tony Dare <wadedare4703@comcast.net>
2013-06-22 19:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2013-06-22 23:16 ` Christofer C. Bell <christofer.c.bell@gmail.com>
2013-06-27 21:26 ` Magnus Hagander <magnus@hagander.net>
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