Re: [GENERAL] pg on Debian servers

Поиск
Список
Период
Сортировка
От rob stone
Тема Re: [GENERAL] pg on Debian servers
Дата
Msg-id 1510516369.4986.11.camel@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] pg on Debian servers  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime