[Pkg-postgresql-public] Bug#871986: Bug#871986: postgresql-9.6: PostgreSQL fails to start after upgrade

2017-08-13 Thread Jacob Sparre Andersen

Christoph Berg wrote:


Is /etc/postgresql/9.6/main/start.conf set to "auto"?


No. :-(

It appears that I simply hadn't switched from "manual" to "auto" after I 
finished the upgrade from 9.4 (Jessie) to 9.6.


I'm sorry about filling trivial problems like that in the bug database.


> I've tried "sudo service postgresql restart" without any visible effect.

postgresql.service is just a stub which forwards all actions to the
individual services like postgresql@9.6-main.service. Unfortunately
systemctl doesn't really relay any errors back if there's any.


Could "postgresql.service" be expanded such that running "service 
postgresql" will output a suggestion to use "systemctl" instead?


Thanks for the help!

/Jacob

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public


[Pkg-postgresql-public] Bug#871986: Bug#871986: postgresql-9.6: PostgreSQL fails to start after upgrade

2017-08-13 Thread Christoph Berg
Control: tags -1 moreinfo

Re: Jacob Sparre Andersen 2017-08-13 
<150261237312.2459.10119247764903837989.report...@franka.jacob-sparre.dk>
> Last night I upgraded "postgresql-9.6" to the most recent version
> (went from 9.6.3-3 to 9.6.4-0+deb9u1).
> 
> As a part of the upgrade PostgreSQL was shut down, and it has not come
> up since then.

Hi Jacob,

can we see the output of "systemctl status postgresql@9.6-main"?

Is /etc/postgresql/9.6/main/start.conf set to "auto"?
Do you have /usr/sbin/policy-rc.d installed?

> I've tried "sudo service postgresql restart" without any visible effect.

postgresql.service is just a stub which forwards all actions to the
individual services like postgresql@9.6-main.service. Unfortunately
systemctl doesn't really relay any errors back if there's any.

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public