[Debian-ha-maintainers] Bug#862719: resource-agents: pgsql RA needs update for default stretch Postgres version

[Michael Banck]

Package: resource-agents
Version: 1:4.0.0~rc1-3
Severity: important
Tags: stretch, patch

Dear Maintainer,

there have been two relevant commits to the pgsql resource agent since
4.0.0rc1, which add support for quoting synchronous standby names in the
configuration.  Since Postgres-9.6 now treats the standby names as SQL
identfiers, they need to be quoted or else dashes etc. in the names will
make it break. So this should be fixed for stretch.

The relevant upstream commits are
6e91193f0e4d3f72d22564e1fe393e7391691f9d and
6ad25cf64e00cebe5d90ec96430d94a38b240d31, the latter fixes up the former
(and is not in a release yet AFAICT).

There is one other commit to the pgsql RA since 4.0.0r1 but this one
(c7bb30e9584c9613f816861f4924fe3f5154bd4f) is for support of Pacemaker
1.1.17 and up, so not needed for stretch at this point.

I've attached a debian/patches-ready patch.


Michae


-- System Information:
Debian Release: 8.7
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.16.0-4-686-pae (SMP w/1 CPU core)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgsql_postgres-9.6.patch
Type: text/x-diff
Size: 2063 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/debian-ha-maintainers/attachments/20170516/89064884/attachment.patch>