Re: postgresql doesn't start at boot

[Glyn Astill <glynastill@yahoo.co.uk>]

> From: Bzzzz <lazyvirus@gmx.com>
>To: debian-user@lists.debian.org 
>Sent: Wednesday, 6 August 2014, 15:58
>Subject: postgresql doesn't start at boot
> 
>
>sid
>amd64
>================
>
>Hi mailing-listers,
>
>since the upgrade from 9.3 to 9.4, postgresql doesn't automatically start
>at boot anymore.
>I added a symlink to /lib/systemd/system/postgresql.service
>into /etc/systemd/system but I'm not sure this will be enough; is it?
>(3.5 pages of looong mans listed, options in every corner, systemd seems
>to have the art of transforming something formerly trivial to an
>indigestible gas plant). 
>
>

Indeed; but is that really the issue?  Check your postgresql server logs for something along the lines of "database files are incompatible with server".


Since 9.3 -> 9.4 is a major version upgrade, you need to make sure your data directory is migrated to the new internal storage format. You most likely want to upgrade with pg_upgrade or a dump restore.