Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade

Ken Beck <nekkceb(dot)durfee(at)gmail(dot)com> writes:

> I recently upgraded my OS from Ubuntu 14.04 LTS to 16.04 LTS and since,
> postgresql refuses to re-start. I am concerned that if I poke around too
> much, I may lose my old data. I have consulted various web postings here
> and in ubuntu forums, and have not found an obvious solution. But please
> excuse me, I am not a Linux expert, and I had a friend help me with
> setup issues several years ago. They are no longer available, and I am
> having trouble getting things to run.
>

This is likely a Ubuntu/Debian related issue. I vaguely remember that
following an upgrade of a Ubuntu system, the upgrade issued a warning
about additional steps needed to be taken in order to upgrade
postgres. I'm pretty sure that the default postgres for 16.04 was 9.6,
so it is possible that you need to upgrade your postgres installation to
9.6 or take other action to continue using 9.3 It might be worthwhile
looking in /usr/share/doc/postgresql-common and see if there is some
relevant documentation about upgrading etc.

I also suspect there may be some startup changes you will need to
verify. I think Ubuntu 16.04 uses systemd while 14.04 used upstart?

After a Ubuntu upgrade, there is usually an upgrade log you can also
check to see if anything failed or provided warnings regarding
additional actions required.

HTH

Tim

--
Tim Cross