Re: [GENERAL] pg on Debian servers

2017-11-13 Thread Mark Morgan Lloyd
On 12/11/17 19:15, Karsten Hilbert wrote: On Sat, Nov 11, 2017 at 01:03:18PM +, Mark Morgan Lloyd wrote: Several legacy programs written in Delphi ground to a halt this morning, which turned out to be because a Debian system had updated its copy of PostgreSQL and restarted the server, which

Re: [GENERAL] pg on Debian servers

2017-11-12 Thread rob stone
On Sat, 2017-11-11 at 14:30 +0100, Magnus Hagander wrote: > > > > The init.d script is not used with systemd. > > > Hello Magnus, Many months ago on a bog standard Debian set-up did a re-boot and ended up with postmasters running for 9.2, 9.4, 9.5 and 9.6 all started one after the other.

Re: [GENERAL] pg on Debian servers

2017-11-12 Thread Karsten Hilbert
On Sat, Nov 11, 2017 at 01:03:18PM +, Mark Morgan Lloyd wrote: > Several legacy programs written in Delphi ground to a halt this morning, > which turned out to be because a Debian system had updated its copy of > PostgreSQL and restarted the server, which broke any live connections. > > At le

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Mark Morgan Lloyd
On 11/11/17 16:45, Jan Claeys wrote: On Sat, 2017-11-11 at 14:23 +, Mark Morgan Lloyd wrote: I think that the "preventing upgrades" route is the one to follow, since inhibiting the restart would obviously present a risk that something loaded dynamically could get out of step. As an at least

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Jan Claeys
On Sat, 2017-11-11 at 14:23 +, Mark Morgan Lloyd wrote: > I think that the "preventing upgrades" route is the one to follow, > since inhibiting the restart would obviously present a risk that > something loaded dynamically could get out of step. As an at least > temporary hack I've disabled una

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Mark Morgan Lloyd
On 11/11/17 13:45, Christoph Berg wrote: Re: Magnus Hagander 2017-11-11 Is there any way that either the package maintainer or a site administrator/programmer such as myself can mark the Postgres server packages as "manual upgrade only" or similar? Or since I'm almost certainly not the first p

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Magnus Hagander
On Sat, Nov 11, 2017 at 2:23 PM, rob stone wrote: > > > On Sat, 2017-11-11 at 13:03 +, Mark Morgan Lloyd wrote: > > Apologies for something which is distro related, but I was bitten by > > a > > "silly mistake"- one of my own, I hasten to say- earlier. > > > > Several legacy programs written

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Christoph Berg
Re: Magnus Hagander 2017-11-11 > > Is there any way that either the package maintainer or a site > > administrator/programmer such as myself can mark the Postgres server > > packages as "manual upgrade only" or similar? Or since I'm almost certainly > > not the first person to be bitten by this,

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread rob stone
On Sat, 2017-11-11 at 13:03 +, Mark Morgan Lloyd wrote: > Apologies for something which is distro related, but I was bitten by > a > "silly mistake"- one of my own, I hasten to say- earlier. > > Several legacy programs written in Delphi ground to a halt this > morning, > which turned out t

Re: [GENERAL] pg on Debian servers

2017-11-11 Thread Magnus Hagander
On Sat, Nov 11, 2017 at 2:03 PM, Mark Morgan Lloyd < markmll.pgsql-gene...@telemetry.co.uk> wrote: > Apologies for something which is distro related, but I was bitten by a > "silly mistake"- one of my own, I hasten to say- earlier. > > Several legacy programs written in Delphi ground to a halt thi

[GENERAL] pg on Debian servers

2017-11-11 Thread Mark Morgan Lloyd
Apologies for something which is distro related, but I was bitten by a "silly mistake"- one of my own, I hasten to say- earlier. Several legacy programs written in Delphi ground to a halt this morning, which turned out to be because a Debian system had updated its copy of PostgreSQL and restar