[Pkg-postgresql-public] Bug#859551: pgbouncer: Please migrate to openssl1.1 in buster

[Sebastian Andrzej Siewior]

Hi,

this is a remainder about the openssl transition [0]. We really want to
remove libssl1.0-dev from unstable for Buster. I will raise the severity
of this bug to serious in a month. Please react before that happens.

[0] https://bugs.debian.org/871056#55

Sebastian

___
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#859550: pgadmin3: Please migrate to openssl1.1 in buster

[Sebastian Andrzej Siewior]

Hi,

this is a remainder about the openssl transition [0]. We really want to
remove libssl1.0-dev from unstable for Buster. I will raise the severity
of this bug to serious in a month. Please react before that happens.

[0] https://bugs.debian.org/871056#55

Sebastian

___
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] postgresql-pgmp_1.0.2-5_source.changes ACCEPTED into unstable

[Debian FTP Masters]

Accepted:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Format: 1.8
Date: Thu, 12 Oct 2017 20:39:43 +0200
Source: postgresql-pgmp
Binary: postgresql-10-pgmp
Architecture: source
Version: 1.0.2-5
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers 

Changed-By: Christoph Berg 
Description:
 postgresql-10-pgmp - arbitrary precision integers and rationals for PostgreSQL 
10
Changes:
 postgresql-pgmp (1.0.2-5) unstable; urgency=medium
 .
   * Sort file lists in Makefile to make build reproducible.
Checksums-Sha1:
 832ac2ec2400a7d51e94a12dd0b83d5bf93d6601 2158 postgresql-pgmp_1.0.2-5.dsc
 f02380b5d6e079761a15431781206f700ec34cef 5288 
postgresql-pgmp_1.0.2-5.debian.tar.xz
 ecc4b8a8eee138af945cbc5fb3b3171acffce8b8 7118 
postgresql-pgmp_1.0.2-5_source.buildinfo
Checksums-Sha256:
 65cfca567a6ed3478aea0497fb03189b3152058bb5e3af1576bd58bbb33d2185 2158 
postgresql-pgmp_1.0.2-5.dsc
 0b70d9833193d33fc9704ba94c4c468908551d058394bd82ae7d88ea095c9de3 5288 
postgresql-pgmp_1.0.2-5.debian.tar.xz
 d318a4d0e557d1751140c64262531e42eb80ef0489d8569df9000d6e34c0e7af 7118 
postgresql-pgmp_1.0.2-5_source.buildinfo
Files:
 ed6a4a4074fc0afa7a6a7ddbc7562782 2158 database optional 
postgresql-pgmp_1.0.2-5.dsc
 487581980734512828caf40f2a8bf564 5288 database optional 
postgresql-pgmp_1.0.2-5.debian.tar.xz
 2979334d4528952b6f619a6581e190ae 7118 database optional 
postgresql-pgmp_1.0.2-5_source.buildinfo

-BEGIN PGP SIGNATURE-

iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlnfvJMACgkQTFprqxLS
p659DBAAog26IRKihzNwWUI5/z9vqVQ/1hEw0sV/F9lPcfpzKInRNKUFX1xYZw7F
m+2CiqMvuUmLpihKP25AYI/59FTIdva7QdT6wFXQEi4AA2AzA1Y/afYfp3rXZL4Y
dAqiVCEYML9/ZDmrigqc3SqZmds7duQ6z4zWkFW4I2axaRijOFFGW07kbjTAre9W
dwm5ANpneCiy0FwdOLK7vZHNWfqI5zPKqbAA7UFCM8TxnQL9TvzvhTKya1DU3+F5
0vhv/Vi2Y+ns9iPetR8qKHFQbUByfq15A5YIaUFtyRQJvMLSqjbmA1HaqrOAGo2n
fJoq7robccH83n4PNxiKDMB3Qv4W5rW9x4//n0HY+CXHhO4Msd+VyNy8ezynRf6O
5KD6TyTkYWcDp0S+xmbIwVVnWv8+AEH7GM/aqOtvjRAGqSVKxzXihNBW1t4JnT6S
ttIKH3fc0ZVSnb2W92vKsLyr4v+dlE1Td9hFdSB1b2aURNL5e9P1y6xdpLUxuyM4
BuCzkaS+asiDiqGgXGSrwtHxYFvd9gIPELpmZSINqO5uHIGbwzA/4NQWE3o9ZFK1
wPIH+mzNuHl++Y/HlaGWI6dp5Bjl/yshTC83ddXQ9XxxAJFA5j7rTWmud5zaK1WD
E2euF/5r2iO8gOQ51zn79fd3hSJ5vvMc86ySwrR+gVLmEwbeEqQ=
=65O1
-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] Processing of postgresql-pgmp_1.0.2-5_source.changes

[Debian FTP Masters]

postgresql-pgmp_1.0.2-5_source.changes uploaded successfully to localhost
along with the files:
  postgresql-pgmp_1.0.2-5.dsc
  postgresql-pgmp_1.0.2-5.debian.tar.xz
  postgresql-pgmp_1.0.2-5_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] postgresql-9.4_9.4.14-0+deb8u1~bpo7+1_amd64.changes REJECTED

[Debian FTP Masters]

The suite "wheezy-backports" does not accept source uploads.



===

Please feel free to respond to this email if you don't understand why
your files were rejected, or if you upload new files which address our
concerns.


___
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#878295: pgadmin3 changes for PG10

[Christoph Berg]

Package: pgadmin3
Version: 1.22.2-1

- Forwarded message from Bernhard Rieder  -

Date: Wed, 11 Oct 2017 16:10:53 +0200
From: Bernhard Rieder 
To: christoph.b...@credativ.de
Subject: pgadmin3 anpassungen für PG10
diff -ur pgadmin3-1.22.2/pgadmin/include/pgAdmin3.h pgadmin3-1.22.2-PG10/pgadmin/include/pgAdmin3.h
--- pgadmin3-1.22.2/pgadmin/include/pgAdmin3.h	2016-11-10 15:13:28.0 +0100
+++ pgadmin3-1.22.2-PG10/pgadmin/include/pgAdmin3.h	2017-10-11 14:40:38.835409091 +0200
@@ -58,8 +58,8 @@
 // Supported server minimum and maximum values.
 const short SERVER_MIN_VERSION_N = 0x0804;
 const wxString SERVER_MIN_VERSION_T = wxT("8.4");
-const short SERVER_MAX_VERSION_N = 0x0906;
-const wxString SERVER_MAX_VERSION_T = wxT("9.6");
+const short SERVER_MAX_VERSION_N = 0x0A00;
+const wxString SERVER_MAX_VERSION_T = wxT("10.0");
 
 // Supported Greenplum Database and Greenplum HAWQ minimum and maximum values.
 const short GP_MIN_VERSION_N = 0x0802;
diff -ur pgadmin3-1.22.2/pgadmin/schema/pgServer.cpp pgadmin3-1.22.2-PG10/pgadmin/schema/pgServer.cpp
--- pgadmin3-1.22.2/pgadmin/schema/pgServer.cpp	2016-02-08 11:25:13.0 +0100
+++ pgadmin3-1.22.2-PG10/pgadmin/schema/pgServer.cpp	2017-10-11 14:55:57.274751845 +0200
@@ -905,13 +905,24 @@
 		if (conn->BackendMinimumVersion(8, 5))
 		{
 			sql += wxT(", CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery");
-			sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc");
-			sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc");
+			if (conn->BackendMinimumVersion(10, 0))
+			{
+sql += wxT(", CASE WHEN usesuper THEN pg_last_wal_receive_lsn() ELSE NULL END as receiveloc");
+sql += wxT(", CASE WHEN usesuper THEN pg_last_wal_replay_lsn() ELSE NULL END as replayloc");
+			}
+			else
+			{
+			sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc");
+			sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc");
+		}
 		}
 		if (conn->BackendMinimumVersion(9, 1))
 		{
 			sql += wxT(", CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp");
-			sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused");
+			if (conn->BackendMinimumVersion(10, 0))
+sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_wal_replay_paused() ELSE NULL END as isreplaypaused");
+			else
+			sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused");
 		}
 
 		pgSet *set = ExecuteSet(sql + wxT("\n  FROM pg_user WHERE usename=current_user"));
@@ -1434,7 +1445,11 @@
 bool pgServer::PauseReplay()
 {
 	SetReplayPaused(true);
-	wxString sql = wxT("SELECT pg_xlog_replay_pause()");
+	wxString sql;
+	if (conn->BackendMinimumVersion(10, 0))
+		sql = wxT("SELECT pg_wal_replay_pause()");
+	else
+		sql = wxT("SELECT pg_xlog_replay_pause()");
 	return conn->ExecuteVoid(sql);
 }
 
@@ -1442,7 +1457,11 @@
 bool pgServer::ResumeReplay()
 {
 	SetReplayPaused(false);
-	wxString sql = wxT("SELECT pg_xlog_replay_resume()");
+	wxString sql;
+	if (conn->BackendMinimumVersion(10, 0))
+		sql = wxT("SELECT pg_wal_replay_resume()");
+	else
+		sql = wxT("SELECT pg_xlog_replay_resume()");
 	return conn->ExecuteVoid(sql);
 }
 
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public