[Pkg-postgresql-public] postgresql-server-dev-10 ICU support

[Денис Смирнов]

Hello,
It seems that PostgreSQL 10 in your package have been build with ICU
support. But postgresql-server-dev-10 doesn't have ICU devel package in
dependences.

Package: postgresql-server-dev-10
Source: postgresql-10
Version: 10.0-1.pgdg17.04+1
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <
pkg-postgresql-public@lists.alioth.debian.org>
Installed-Size: 4870
Depends: libpq-dev (>= 10~~), postgresql-common (>= 142~), libc6 (>= 2.14)
Breaks: postgresql-server-dev-all (<< 181~)
Section: libdevel
Priority: optional

It seems to be wrong. Can you be so kind to add libicu-dev to depentences?
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] pgaudit_1.1.1-2_amd64.changes ACCEPTED into unstable, unstable

[Debian FTP Masters]

Accepted:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Format: 1.8
Date: Fri, 06 Oct 2017 14:27:15 +0200
Source: pgaudit
Binary: postgresql-10-pgaudit
Architecture: source amd64
Version: 1.1.1-2
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers 

Changed-By: Michael Banck 
Description:
 postgresql-10-pgaudit - PostgreSQL Audit Extension
Changes:
 pgaudit (1.1.1-2) unstable; urgency=medium
 .
   * debian/control: Update for current PostgreSQL version in unstable.
   * debian/patches/support_10.patch: New patch, add support for v10, based on
 upstream commit 6ce6e006.
Checksums-Sha1:
 1d668fca45e38628108cbf522c234c321f074de9 2079 pgaudit_1.1.1-2.dsc
 ba1141207626e250ba00bb1a075a817e2227363e 9416 pgaudit_1.1.1-2.debian.tar.xz
 3832d0e2242613b1f8b8b05aa8b328737e2e7ae1 7575 pgaudit_1.1.1-2_amd64.buildinfo
 431f2378be3a5bf549e183696f9c97d30c8baeb6 49400 
postgresql-10-pgaudit-dbgsym_1.1.1-2_amd64.deb
 73c0a3f380a72944206c0fce0811bfb96ef99e67 18794 
postgresql-10-pgaudit_1.1.1-2_amd64.deb
Checksums-Sha256:
 6626f93b6beff3d68497bb41d4e9405db351edd1db35a6dbbfa0008c277c728b 2079 
pgaudit_1.1.1-2.dsc
 794af88d87469748e87b1a381b0d72625c7c4acc0b534f2540cff4ac2afa82a4 9416 
pgaudit_1.1.1-2.debian.tar.xz
 79f8d9cf6582d1f15a178fa0c3c9f6971f6d7afe807d297396f857c7e57696c8 7575 
pgaudit_1.1.1-2_amd64.buildinfo
 b6a40cde88b189e6c95115bffce1d960f64f6e4887ab79b934d720e96f6f0525 49400 
postgresql-10-pgaudit-dbgsym_1.1.1-2_amd64.deb
 48f7eb0d31fbadf96b144216c2cbed55829f2847daeb025eac36e3dc1e9b9bcb 18794 
postgresql-10-pgaudit_1.1.1-2_amd64.deb
Files:
 93c0d9c62805d628d1a7f1b3e635e765 2079 database optional pgaudit_1.1.1-2.dsc
 c3ecbeea582094c57f63d785e1f8a958 9416 database optional 
pgaudit_1.1.1-2.debian.tar.xz
 d6b0d4c2361959894871958d35804b8a 7575 database optional 
pgaudit_1.1.1-2_amd64.buildinfo
 f9e5fb386363f97a949184ad6ac704d7 49400 debug optional 
postgresql-10-pgaudit-dbgsym_1.1.1-2_amd64.deb
 00120b27e00b814be3e4a2935d729d7e 18794 database optional 
postgresql-10-pgaudit_1.1.1-2_amd64.deb

-BEGIN PGP SIGNATURE-

iQIzBAEBCAAdFiEEnKh3dJ+rLk+paGLs3GhqJ7Q0gbAFAlnXh3sACgkQ3GhqJ7Q0
gbBGYBAAkQrIaQOoq9/d+3xDstR19RkAK3ApvvOrb/WhZM5gO2II2SUI6ZiNk4+k
lo5+G70dhDgNSL9KkVER9PJWpeROXSrsBWJYUnEBS+KiEJJbRxuVDvGOzdO/8Ac8
4C3VfigA0db4orLRzQ0ryDdBf1hims+SrqFjcsY1I92JSpRtbeMFxNUrsIK/uh3l
M9/Ld2yDXmjLXKNLD0KekgAyB3afOskNrQKVIFw9Uj5yMRDb0xua0plpr49Cm/Su
FKgi7irpQP/3JIfAUVLLDWSodEcxqqZwaMdSEIQ4IknLs/CNrW2eX8TIsrRHsCbB
EM0Jxr10oKQpPnKEGRV1lyFjCPPhtUYb5Ln3tnpqG/2tXOiqjvVdSR1LYJ57cWrs
LlRpZSRQ4kIvKUR89MW2Gdysfl9DyFybmNO+mlvXO3SSHNZHek9zQeVOqewDlflD
MKU97WrtE22v8TZgn+TjijHm0UHbFzZ7bTnHov8hTxFGWUSikDHaQRShzCAaK4ef
c/8YaJZFRxsUArW9ZONp5TlREi06S6xBLFyY1DwPUkm3LLD1Xp3Ak/C3HdstRNvN
CLtjtRu8RKZ1+XB+B4QD5/9Wn1pf8SHKr7kHyuQvP3f5lwfSLtep6sgbmibERtYs
4+5nweju+Vb9KM1mYdfXCGRHe+vsY+/FuSe9EU96Xg5NLt1P7co=
=Jr6E
-END PGP SIGNATURE-


Thank you for your contribution to Debian.

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] powa-archivist_3.1.1_amd64.changes ACCEPTED into unstable, unstable

[Debian FTP Masters]

Accepted:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Format: 1.8
Date: Tue, 19 Sep 2017 10:40:00 +0200
Source: powa-archivist
Binary: postgresql-10-powa
Architecture: source amd64
Version: 3.1.1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers 

Changed-By: Christoph Berg 
Description:
 postgresql-10-powa - PostgreSQL Workload Analyzer -- PostgreSQL 10 extension
Changes:
 powa-archivist (3.1.1) unstable; urgency=medium
 .
   * Team upload.
   * New upstream version.
   * Packaging has been merged into upstream git.
   * Use source format 3.0 (native) to ease building snapshots.
   * Bump Standards-Version to 4.1.0.
Checksums-Sha1:
 93641e0dbf4c5433b77a7a23280f6553d2dc288e 1779 powa-archivist_3.1.1.dsc
 f7f64225e23971289141f63a46586d4e8677c7b4 23684 powa-archivist_3.1.1.tar.xz
 fccfee12681234baba9fe2d67099b0247d4d1529 38650 
postgresql-10-powa-dbgsym_3.1.1_amd64.deb
 692ef50c1520777cc119fa02f81df3d05ef9969c 22082 
postgresql-10-powa_3.1.1_amd64.deb
 607b74eda98c5c8f5392f41e006652d8b3feda25 7446 
powa-archivist_3.1.1_amd64.buildinfo
Checksums-Sha256:
 e0a4fd60f010bdf1c8f7937dd890ddd968245cf45b5880cf11af63f96f9390de 1779 
powa-archivist_3.1.1.dsc
 58308b9976778041d84d2d19f5189aea1601d5e88e0157b8f57da93defcf4900 23684 
powa-archivist_3.1.1.tar.xz
 5829b2b605e92083372dd3a92f23079d2207a2f611bf3b69fd8d6fb931fe0371 38650 
postgresql-10-powa-dbgsym_3.1.1_amd64.deb
 2feb1e109fc9ef58e4dac7c779d776ecccdcb385d7e660539e7ee2d49d21a29d 22082 
postgresql-10-powa_3.1.1_amd64.deb
 1a723c2a317b9063c3b3ff5f560279c9bb3ba4198f68d620eee8b7cd335d2245 7446 
powa-archivist_3.1.1_amd64.buildinfo
Files:
 4aa10b0439d656bb152b287b2f3346b3 1779 database optional 
powa-archivist_3.1.1.dsc
 9a15fa7db28689d178c3a6c6cad7b6fe 23684 database optional 
powa-archivist_3.1.1.tar.xz
 6694275ac7184abc26aad47982b092d6 38650 debug optional 
postgresql-10-powa-dbgsym_3.1.1_amd64.deb
 ca705a15c108ac9f17c3b496ac2e4087 22082 database optional 
postgresql-10-powa_3.1.1_amd64.deb
 e68148ee629c7a9d9ce63d21828935fc 7446 database optional 
powa-archivist_3.1.1_amd64.buildinfo

-BEGIN PGP SIGNATURE-

iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlnDspEACgkQTFprqxLS
p66vmw//V/4cGuqzWwFxXi4HlUK0sukVKIZ0P5Z9R+TCsOTJ53c7znYmC/WyIhcY
bFL5htOVYF34v3x+opUSpeOutk7Yp2VGj2aN40jcxk50TJ4OayNaMIB3DPEmriTd
g2+I/IvysyDqnB5xx8IzQpmQFKlaM82Dcnrh8NwsfJG1HzQw3qHjjOuiIBvKleoJ
FBfG1JUli/D9KDRncVrLHHFbC8wFYA19hPeoRBMXV4liwPxQO7kBwEAM2LdxXeaL
NsoRWa74RiQCohr52spoOs/diZ6EpX9o4rbFKlciPpbqQnTV2nf0QuFis/KpRBv0
ShlVhKw2kc/+Do9SqjHalhGs2jtNPZwSMcfYoDvHBlIWv/mc+uK3TqohV3B93naO
uzkfLkco1LLHQlO955RugMC6qUHUXvWagwFi3PsNsII74ckCK2bx9hY4SGAcu/k/
Z04IDpajeUk6irS7M436Wyp829EsIG6ZBDX9Al5ytwZoDqO6+NY/tP4ULf2ueM/S
7oY3PE/FALlf/er28V5/UpaVz1cxviftqqzHONV8Xe6fV4Evw9ZKbT7/M/pv1HjL
82KrnE6GN1kzjDbKULFxVMlrfHVrFnHhZ0QZ5WXtPS8BrZgEGXXBLIBzjjNAaf/x
vD+hMFmdZsPpCZ/jbSixWr6Rjmeyhvlv9hUeLNket8Lavi68lng=
=yBdf
-END PGP SIGNATURE-


Thank you for your contribution to Debian.

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877381: marked as done (plr: please make the build reproducible)

[Debian Bug Tracking System]

Your message dated Sat, 07 Oct 2017 16:04:12 +
with message-id 
and subject line Bug#877381: fixed in plr 1:8.3.0.17-3
has caused the Debian Bug report #877381,
regarding plr: please make the build reproducible
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
877381: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=877381
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Source: plr
Version: 1:8.3.0.17-2
Severity: wishlist
Tags: patch
User: reproducible-bui...@lists.alioth.debian.org
Usertags: timestamps
X-Debbugs-Cc: reproducible-b...@lists.alioth.debian.org

Hi,

Whilst working on the Reproducible Builds effort [0], we noticed
that plr could not be built reproducibly as it encodes the date
in generated HTML.

Patch attached.

 [0] https://reproducible-builds.org/


Regards,

-- 
  ,''`.
 : :'  : Chris Lamb
 `. `'`  la...@debian.org / chris-lamb.co.uk
   `-
--- a/debian/rules  2017-10-01 09:43:31.433455583 +0100
--- b/debian/rules  2017-10-01 09:52:20.327204302 +0100
@@ -10,6 +10,8 @@
 
 override_dh_installdocs:
dh_installdocs --all doc/plr-US.pdf doc/html/*.html
+   find debian/*/usr/share/doc/ -type f -name '*.html' -print0 | \
+   xargs -0r sed -i -e 's@CONTENT="[^"]*"@CONTENT=""@g'
 
 override_dh_auto_install:
+pg_buildext loop postgresql-%v-plr
--- End Message ---
--- Begin Message ---
Source: plr
Source-Version: 1:8.3.0.17-3

We believe that the bug you reported is fixed in the latest version of
plr, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 877...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Christoph Berg  (supplier of updated plr package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Format: 1.8
Date: Sat, 07 Oct 2017 17:21:25 +0200
Source: plr
Binary: postgresql-10-plr
Architecture: source
Version: 1:8.3.0.17-3
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers 

Changed-By: Christoph Berg 
Description:
 postgresql-10-plr - Procedural language interface between PostgreSQL and R
Closes: 877381
Changes:
 plr (1:8.3.0.17-3) unstable; urgency=medium
 .
   * Use SOURCE_DATE_EPOCH for documentation timestamp via openjade.
 Closes: #877381
Checksums-Sha1:
 a8221f6438a96d960c4860ac2f33b0e27450b703 2123 plr_8.3.0.17-3.dsc
 32903612552c9d1aceed859e50dd320906edd9ec 13532 plr_8.3.0.17-3.debian.tar.xz
 a8f19b614503a69a2085ef8592652d1e4197fd3f 10246 plr_8.3.0.17-3_source.buildinfo
Checksums-Sha256:
 213eb8a1729dba37b3ca84e14f0cec1baa7d4dde17c0bf32ee9e203242b9af5a 2123 
plr_8.3.0.17-3.dsc
 3704b8972031f69e8ffa80bc555f084fa841295f6e9638ff46fab19071681ff6 13532 
plr_8.3.0.17-3.debian.tar.xz
 3bac56c13c6e73207ba280ed27d622ddfa2b12364e60099d56d2d89583e8c94b 10246 
plr_8.3.0.17-3_source.buildinfo
Files:
 b09a376fafd336dc1e47fafe807399e4 2123 database optional plr_8.3.0.17-3.dsc
 0f688eaa2ba0ef52e533347c9ecefbd4 13532 database optional 
plr_8.3.0.17-3.debian.tar.xz
 653d57c545b5190bffb3011dfae5a064 10246 database optional 
plr_8.3.0.17-3_source.buildinfo

-BEGIN PGP SIGNATURE-

iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlnY9EQACgkQTFprqxLS
p67agBAArJTTlHQJDrPZmUphATTBUDnT7Aut70ZoRYGSYjnZ2I36r4ePL/tSOlbg
Pb1+enO6qMBDysRycn5ZyAN56APuXW0QC02U3Vpg25rpHqDoZJFaP72vHYNlH25f
S3keqv7uOepXCQe4ONNofzANHEAYi1V5castR4Pe2YZqBuLuvemjr/HHxiQhWbSG
5YngyXG6XVDNAvnJKo8UhpSvGixw+d/bI0sApihLVn0b74g/sY5GGqAgdM7Zh1Oo
Sv1CTfJRVehyB5mVNy3i/wgJc5IeqzvlCrAI4ThrxDnR/CK4zh3F1X4D96KPPj7S
2n++hHZT4MKKD9yjuIj1EAIZL4RUBcuahgODprjcexLduix/Ddl3pN59Lla90m+P
mo32TxyDQvyqqnpjJ3pDH4UCdN7FheIA0XR0KLRb5JclyVV9v+q6HrnWoST5D+Lt
cMP7hjIGcp2n8LifGQIsZj3RuXumaC9zwIzozbiwDex8MdHK68z9I3pF+Jb4fR7g
hCApyWQuEnprFw0tawm0usb/+kNljdg/pw8/DMjqSmkiEBrTRUqXzD32uwmHQNK2
5nKPZQeJeAxC6hcz/Ah+6ATYW8su8ZjQ8O5ShV8ESA1AyyDp18xZRNNh/OArY99I
VWNfVq5ZH0Y9nw4T02h76ZJA+eezsB8lVbVXS9OQvMX8bGrFwMg=
=J9KC
-END PGP SIGNATURE End Message ---
___
Pkg-postgresql-public mailing list

[Pkg-postgresql-public] plr_8.3.0.17-3_source.changes ACCEPTED into unstable

[Debian FTP Masters]

Accepted:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Format: 1.8
Date: Sat, 07 Oct 2017 17:21:25 +0200
Source: plr
Binary: postgresql-10-plr
Architecture: source
Version: 1:8.3.0.17-3
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers 

Changed-By: Christoph Berg 
Description:
 postgresql-10-plr - Procedural language interface between PostgreSQL and R
Closes: 877381
Changes:
 plr (1:8.3.0.17-3) unstable; urgency=medium
 .
   * Use SOURCE_DATE_EPOCH for documentation timestamp via openjade.
 Closes: #877381
Checksums-Sha1:
 a8221f6438a96d960c4860ac2f33b0e27450b703 2123 plr_8.3.0.17-3.dsc
 32903612552c9d1aceed859e50dd320906edd9ec 13532 plr_8.3.0.17-3.debian.tar.xz
 a8f19b614503a69a2085ef8592652d1e4197fd3f 10246 plr_8.3.0.17-3_source.buildinfo
Checksums-Sha256:
 213eb8a1729dba37b3ca84e14f0cec1baa7d4dde17c0bf32ee9e203242b9af5a 2123 
plr_8.3.0.17-3.dsc
 3704b8972031f69e8ffa80bc555f084fa841295f6e9638ff46fab19071681ff6 13532 
plr_8.3.0.17-3.debian.tar.xz
 3bac56c13c6e73207ba280ed27d622ddfa2b12364e60099d56d2d89583e8c94b 10246 
plr_8.3.0.17-3_source.buildinfo
Files:
 b09a376fafd336dc1e47fafe807399e4 2123 database optional plr_8.3.0.17-3.dsc
 0f688eaa2ba0ef52e533347c9ecefbd4 13532 database optional 
plr_8.3.0.17-3.debian.tar.xz
 653d57c545b5190bffb3011dfae5a064 10246 database optional 
plr_8.3.0.17-3_source.buildinfo

-BEGIN PGP SIGNATURE-

iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlnY9EQACgkQTFprqxLS
p67agBAArJTTlHQJDrPZmUphATTBUDnT7Aut70ZoRYGSYjnZ2I36r4ePL/tSOlbg
Pb1+enO6qMBDysRycn5ZyAN56APuXW0QC02U3Vpg25rpHqDoZJFaP72vHYNlH25f
S3keqv7uOepXCQe4ONNofzANHEAYi1V5castR4Pe2YZqBuLuvemjr/HHxiQhWbSG
5YngyXG6XVDNAvnJKo8UhpSvGixw+d/bI0sApihLVn0b74g/sY5GGqAgdM7Zh1Oo
Sv1CTfJRVehyB5mVNy3i/wgJc5IeqzvlCrAI4ThrxDnR/CK4zh3F1X4D96KPPj7S
2n++hHZT4MKKD9yjuIj1EAIZL4RUBcuahgODprjcexLduix/Ddl3pN59Lla90m+P
mo32TxyDQvyqqnpjJ3pDH4UCdN7FheIA0XR0KLRb5JclyVV9v+q6HrnWoST5D+Lt
cMP7hjIGcp2n8LifGQIsZj3RuXumaC9zwIzozbiwDex8MdHK68z9I3pF+Jb4fR7g
hCApyWQuEnprFw0tawm0usb/+kNljdg/pw8/DMjqSmkiEBrTRUqXzD32uwmHQNK2
5nKPZQeJeAxC6hcz/Ah+6ATYW8su8ZjQ8O5ShV8ESA1AyyDp18xZRNNh/OArY99I
VWNfVq5ZH0Y9nw4T02h76ZJA+eezsB8lVbVXS9OQvMX8bGrFwMg=
=J9KC
-END PGP SIGNATURE-


Thank you for your contribution to Debian.

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Re: Karsten Hilbert 2017-10-07 
<20171007154607.34udpgu2jxwsr...@hermes.hilbert.loc>
> >  chomp $ctype;
> >  chomp $collate;
> >  print STDERR "$ctype / $collate\n";
> >  return ($ctype, $collate);
> 
> Unfortunately not:
> 
>   root@hermes:~/bin# pg_upgradecluster 9.6 main
>   de_DE.UTF-8 / de_DE.UTF-8
>   0
>   Error: could not get cluster locales

This doesn't match the above code ("0"), did you edit the correct
file?

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Re: Karsten Hilbert 2017-10-07 
<20171007154139.bpvnx7477qcyh...@hermes.hilbert.loc>
>   condition: $? which is 0 which is "FALSE"

0 is a program exit code where 0 is true and everything else is false.
So yes, this is inverted logic.

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Processing of plr_8.3.0.17-3_source.changes

[Debian FTP Masters]

plr_8.3.0.17-3_source.changes uploaded successfully to localhost
along with the files:
  plr_8.3.0.17-3.dsc
  plr_8.3.0.17-3.debian.tar.xz
  plr_8.3.0.17-3_source.buildinfo

Greetings,

Your Debian queue daemon (running on host usper.debian.org)

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Karsten Hilbert]

On Sat, Oct 07, 2017 at 04:40:24PM +0200, Christoph Berg wrote:

> Can you check if the upgrade works properly if you remove the
> "unless"?
> 
>  chomp $ctype;
>  chomp $collate;
>  print STDERR "$ctype / $collate\n";
>  return ($ctype, $collate);

Unfortunately not:

root@hermes:~/bin# pg_upgradecluster 9.6 main
de_DE.UTF-8 / de_DE.UTF-8
0
Error: could not get cluster locales

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Karsten Hilbert]

On Sat, Oct 07, 2017 at 05:34:15PM +0200, Christoph Berg wrote:

> Re: Karsten Hilbert 2017-10-07 
> <20171007152609.i4m5zc6yuol4j...@hermes.hilbert.loc>
 return ($ctype, $collate) unless $?;
> > 
> > Actually, isn't this inverted logic ?
> > 
> > It should return(...) unless $? actually is NOT zero ?
> 
> The extracted values should be returned if the last psql call exited
> with status 0. (Yes this function isn't the most pretty one. I'm
> inclined to rewrite the whole psql handling from scratch...)

I'll try to think it through although I am not a perl expert:

psql 

success

now $? is 0 (which is "FALSE")

return ($ctype, $collate) unless $?;

definition: statement unless condition

execute statement unless condition is true

condition: $? which is 0 which is "FALSE"

statement: "return" ($ctype, $collate)

hence: execute "return" unless "FALSE" is true

Won't work, right ?

It should be

return ($ctype, $collate) unless ($? != 0);

or am I mistaken ?

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Re: Karsten Hilbert 2017-10-07 
<20171007152609.i4m5zc6yuol4j...@hermes.hilbert.loc>
> > > return ($ctype, $collate) unless $?;
> 
> Actually, isn't this inverted logic ?
> 
> It should return(...) unless $? actually is NOT zero ?

The extracted values should be returned if the last psql call exited
with status 0. (Yes this function isn't the most pretty one. I'm
inclined to rewrite the whole psql handling from scratch...)

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Karsten Hilbert]

On Sat, Oct 07, 2017 at 04:40:24PM +0200, Christoph Berg wrote:

> Re: Karsten Hilbert 2017-10-07 
> <20171007132123.7eqyzz7455f5x...@hermes.hilbert.loc>
> > root@hermes:/usr/share/perl5# pg_upgradecluster 9.6 main
> > de_DE.UTF-8 / de_DE.UTF-8
> > Error: could not get cluster locales
> 
> Hmm. At least the uninitialized value warning is gone now.

Yes, it does get one step further.

> > chomp $ctype;
> > chomp $collate;
> > print STDERR "$ctype / $collate\n";
> > return ($ctype, $collate) unless $?;
> 
> I wonder why $? is non-zero even if the $collate extraction worked.

Strangely enough:

chomp $ctype;
chomp $collate;
print STDERR "$ctype / $collate\n";
print STDERR "$?\n";
return ($ctype, $collate) unless $?;
return (undef, undef);

produces this:

root@hermes:~# pg_upgradecluster 9.6 main
de_DE.UTF-8 / de_DE.UTF-8
0
Error: could not get cluster locales

> Can you check if the upgrade works properly if you remove the "unless"?

Will do.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Re: Karsten Hilbert 2017-10-07 
<20171007132123.7eqyzz7455f5x...@hermes.hilbert.loc>
>   root@hermes:/usr/share/perl5# pg_upgradecluster 9.6 main
>   de_DE.UTF-8 / de_DE.UTF-8
>   Error: could not get cluster locales

Hmm. At least the uninitialized value warning is gone now.

> I also added a print statement:
> 
> chomp $ctype;
> chomp $collate;
> print STDERR "$ctype / $collate\n";
> return ($ctype, $collate) unless $?;
> return (undef, undef);
> 
> which produces the 
> 
>   de_DE.UTF-8 / de_DE.UTF-8

I wonder why $? is non-zero even if the $collate extraction worked.
Can you check if the upgrade works properly if you remove the
"unless"?

 chomp $ctype;
 chomp $collate;
 print STDERR "$ctype / $collate\n";
 return ($ctype, $collate);

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Re: Karsten Hilbert 2017-10-07 
<20171007104018.ax3cv7dwqg4s3...@hermes.hilbert.loc>
> Thanks for your response !

Thanks!

>   postgres@hermes:~$ psql -d template1
>   Ausgabeformat ist »wrapped«.

PgCommon.pm doesn't use 'psql -X' so your (or postgres') .psqlrc might
be getting in the way. Could you try the upgrade again after moving
.psqlrc away, or (better) adding an 'X' to PgCommon.pm lines 935 and
939?

open PSQL, '-|', $psql, '-h', $socketdir, '-p', $port, '-XAtc',
 ^
Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Karsten Hilbert]

Thanks for your response !

> could you provide the output of 'psql -l' for the old cluster?

Sure:

postgres@hermes:~$ psql -l
Ausgabeformat ist »wrapped«.
  Liste der Datenbanken
Name| Eigentümer | Kodierung | Sortierfolge | Zeichentyp  |  
Zugriffsprivilegien

++---+--+-+---
 akonadi| postgres   | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 gnumed_v20 | gm-dbo | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 gnumed_v21 | gm-dbo | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 gnumed_v22 | gm-dbo | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 orthanc_db | orthanc| UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 postgres   | postgres   | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 |
 template0  | postgres   | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 | 
=c/postgres  +
||   |  | | 
postgres=CTc/postgres
 template1  | postgres   | UTF8  | de_DE.UTF-8  | de_DE.UTF-8 | 
postgres=CTc/postgres+
||   |  | | 
=c/postgres
(8 Zeilen)

> Also, please run
> 
>  SHOW lc_ctype;
>  SHOW lc_collate;
> 
> in the old cluster's template1 database.

postgres@hermes:~$ psql -d template1
Ausgabeformat ist »wrapped«.
psql (10.0, Server 9.6.5)
Geben Sie »help« für Hilfe ein.

template1=# show lc_ctype;
  lc_ctype
-
 de_DE.UTF-8
(1 Zeile)

template1=# show lc_collate;
 lc_collate
-
 de_DE.UTF-8
(1 Zeile)

HTH,
Karsten

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Christoph Berg]

Control: tags -1 moreinfo

Re: Karsten Hilbert 2017-10-07 
<150737030347.16226.787705667158988632.report...@hermes.hilbert.loc>
>   Use of uninitialized value $ctype in scalar chomp at 
> /usr/share/perl5/PgCommon.pm line 947.
>   Use of uninitialized value $collate in scalar chomp at 
> /usr/share/perl5/PgCommon.pm line 948.
>   Error: could not get cluster locales
>   root@hermes:~/bin#
> 
> Anything else I can provide ?

Hi,

could you provide the output of 'psql -l' for the old cluster?
Also, please run

 SHOW lc_ctype;
 SHOW lc_collate;

in the old cluster's template1 database.

Christoph

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Processed: Re: Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Debian Bug Tracking System]

Processing control commands:

> tags -1 moreinfo
Bug #877920 [postgresql-common] postgresql-common: pg_upgradecluster 9.6 -> 10 
fails (locale problem)
Added tag(s) moreinfo.

-- 
877920: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=877920
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

[Karsten Hilbert]

Package: postgresql-common
Version: 186
Severity: important

Hello,

when upgrading

Ver Cluster Port Status OwnerData directory   Log file
9.6 main5432 online postgres /var/lib/postgresql/9.6/main 
/var/log/postgresql/postgresql-9.6-main.log

like so:

root@hermes:~/bin# pg_upgradecluster 9.6 main

the following happens:

Use of uninitialized value $ctype in scalar chomp at 
/usr/share/perl5/PgCommon.pm line 947.
Use of uninitialized value $collate in scalar chomp at 
/usr/share/perl5/PgCommon.pm line 948.
Error: could not get cluster locales
root@hermes:~/bin#

Anything else I can provide ?

Karsten


-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'stable-updates'), (500, 'unstable'), 
(500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 4.13.0-trunk-686-pae (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), 
LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-common depends on:
ii  adduser   3.116
ii  debconf   1.5.63
ii  init-system-helpers   1.49
ii  lsb-base  9.20170808
ii  postgresql-client-common  186
ii  procps2:3.3.12-3
ii  ssl-cert  1.0.39
ii  ucf   3.0036

Versions of packages postgresql-common recommends:
ii  logrotate  3.11.0-0.1

Versions of packages postgresql-common suggests:
ii  libjson-perl  2.94-1

-- Configuration Files:
/etc/postgresql-common/createcluster.conf changed:
initdb_options = '-k'
ssl = on
cluster_name = '%v/%c'
stats_temp_directory = '/var/run/postgresql/%v-%c.pg_stat_tmp'
log_line_prefix = '%%m [%%p] %%q%%u@%%d '
add_include_dir = 'conf.d'
include_dir '/etc/postgresql-common/createcluster.d'


-- debconf information:
  postgresql-common/catversion-bump:
  postgresql-common/ssl: true
* postgresql-common/obsolete-major:

___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public