[Pkg-postgresql-public] Bug#812206: Bug#812206: postgresql-common: pg_upgradecluster (9.1 -> 9.4) fails under lxc; please provide a workaround

[Christoph Berg]

Control: tags -1 pending

Re: Antonio Terceiro 2016-01-21 <20160121143633.GA1320 at debian.org>
> It would be nice to either get those patches applied upstream and in
> Debian, or at least to have some documented workaround.
> 
> In the case we get the patches applied, it would also be awesome if they
> could be included in a stable update for jessie.

Hi Antonio,

I had completely forgotten that the problem is already fixed in
unstable, but unfortunately the jessie version (165) doesn't have it
yet. I'll work on getting the patch below into stable.

diff --git a/debian/changelog b/debian/changelog
index 7751170..55ef96a 100644
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,10 @@
+postgresql-common (165+deb8u1) UNRELEASED; urgency=medium
+
+  * pg_upgradecluster: Set default dynamic_shared_memory_type = mmap.
+    (Closes: #784005, #812206)
+
+ -- Christoph Berg <christoph.berg at credativ.de>  Thu, 04 Feb 2016 14:54:56 +0100
+
 postgresql-common (165) unstable; urgency=medium
 
   * Debconf translation updates, thanks!
diff --git a/pg_upgradecluster b/pg_upgradecluster
index db541be..d674fbb 100755
--- a/pg_upgradecluster
+++ b/pg_upgradecluster
@@ -170,6 +170,10 @@ sub adapt_conffiles {
 
     if ($newversion >= '9.4') {
         deprecate \%c, 'krb_srvname', 'native krb5 authentication deprecated in favor of GSSAPI';
+        # d_s_m_t defaults to 'posix', but that has various problems. Pick a safer variant here
+        unless ($c{dynamic_shared_memory_type}) {
+            set 'dynamic_shared_memory_type', 'mmap';
+        }
     }
 }
 

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20160204/d7e81118/attachment.sig>