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@xxxxxxxxxxxxxxxx> wrote:
On 26 October 2015 at 18:21, Lasse Westh-Nielsen <lassewesth@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/
