Re: Service not starting on Ubuntu 15.04 - Mailing list pgsql-general

From Lasse Westh-Nielsen
Subject Re: Service not starting on Ubuntu 15.04
Date
Msg-id CAFyxdeT+=x-d0oNbFPoe+4xnt0Qdfi+zAEn+rQmEK0AZbJFRtg@mail.gmail.com
Whole thread Raw
In response to Re: Service not starting on Ubuntu 15.04  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
Stuart,

You are a life-saver!

With those two commands inserted into the cloud-init script, the service actually starts and can complete my CREATE command.

Thanks!

 - Lasse




On Mon, Oct 26, 2015 at 2:31 PM, Stuart Bishop <stuart@stuartbishop.net> wrote:
On 26 October 2015 at 18:21, Lasse Westh-Nielsen <lassewesth@gmail.com> wrote:
> Hey,
>
> I posted to stackoverflow about my problem upgrading from Ubuntu 14.04 to
> Ubuntu 15.04:
> http://stackoverflow.com/questions/33306475/ubuntu-15-04-postgresql-doesnt-start
>
> Tl;dr: postgresql service does not start properly when installed as a
> package using cloud-init.
>
> And I can't figure out if I am doing something wrong, if the AMI is no good,
> if the package has problems, ... I reckon I cannot be the first person to
> use Postgres on Ubuntu Vivid, but I have been hammering my head against the
> wall with this for hours.
>
> Any help greatly appreciated!

I'd be trying 'pg_ctlcluster --force 9.4 main stop'  and
'pg_ctlcluster 9.4 main start' instead of service start/stop. If it
works, you have narrowed down the problem to systemd and/or the
startup scripts. If it doesn't work, the problem is elsewhere (eg.
some required path like /var/run or /tmp or /var/log/postgresql
doesn't exist or has peculiar permissions). If nothing else, you
should get more informative output rather than systemd hiding it away
somewhere.

--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

pgsql-general by date:

Previous
From: Lasse Westh-Nielsen
Date:
Subject: Re: Service not starting on Ubuntu 15.04
Next
From: Rob Sargent
Date:
Subject: Re: Recursive Arrays 101