Re: [GENERAL] pg on Debian servers - Mailing list pgsql-general

From rob stone
Subject Re: [GENERAL] pg on Debian servers
Date
Msg-id 1510516369.4986.11.camel@gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg on Debian servers  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general

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. There was a script in init.d which read thru
/usr/lib/postgresql and it started running Postgres for each version it
found. Fortunately, all listening on different ports.

The fix was to disable that script as well as the systemd service.

Doing the upgrade to 10 in a few weeks. Will let you know how it goes.

I assume you are aware of this DSA:-


Debian Security Advisory DSA-4029-1

-----------------------------------------------------------------------

Package        : postgresql-common
CVE ID         : CVE-2017-8806

It was discovered that the pg_ctlcluster, pg_createcluster and
pg_upgradecluster commands handled symbolic links insecurely which
could result in local denial of service by overwriting arbitrary files.

For the oldstable distribution (jessie), this problem has been fixed
in version 165+deb8u3.

For the stable distribution (stretch), this problem has been fixed in
version 181+deb9u1.


Cheers,
Rob




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time
Next
From: Andres Freund
Date:
Subject: Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime