Hello community, here is the log from the commit of package postgresql93 for openSUSE:Factory checked in at 2014-07-31 21:50:07 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/postgresql93 (Old) and /work/SRC/openSUSE:Factory/.postgresql93.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "postgresql93" Changes: -------- --- /work/SRC/openSUSE:Factory/postgresql93/postgresql93-libs.changes 2014-05-02 09:51:51.000000000 +0200 +++ /work/SRC/openSUSE:Factory/.postgresql93.new/postgresql93-libs.changes 2014-07-31 21:50:24.000000000 +0200 @@ -1,0 +2,49 @@ +Thu Jul 31 11:09:52 UTC 2014 - coolo@suse.com + +- postgresql93-libs doesn't require systemd - avoid cycles + +------------------------------------------------------------------- +Tue Jul 29 13:52:03 UTC 2014 - darin@darins.net + +- fix systemd unresolvable for SLE_11 + http://en.opensuse.org/openSUSE:Systemd_packaging_guidelines + +------------------------------------------------------------------- +Fri Jul 25 12:34:07 UTC 2014 - max@suse.com + +- bnc#888564: Move the server socket from /tmp to /var/run to avoid + problems with clients that use PrivateTmp. + postgresql-var-run-socket.patch +- Rediff patches. + +------------------------------------------------------------------- +Thu Jul 24 11:56:13 UTC 2014 - max@suse.com + +- Update to 9.3.5. The most important changes are: + * In pg_upgrade, remove pg_multixact files left behind by + initdb. If you used a pre-9.3.5 version of pg_upgrade to + upgrade a database cluster to 9.3, it might have left behind a + file $PGDATA/pg_multixact/offsets/0000 that should not be + there and will eventually cause problems in VACUUM. However, + in common cases this file is actually valid and must not be + removed. + * Correctly initialize padding bytes in contrib/btree_gist + indexes on bit columns. This error could result in incorrect + query results due to values that should compare equal not + being seen as equal. Users with GiST indexes on bit or bit + varying columns should REINDEX those indexes after installing + this update. + * Protect against torn pages when deleting GIN list pages. + This fix prevents possible index corruption if a system crash + occurs while the page update is being written to disk. + * Don't clear the right-link of a GiST index page while + replaying updates from WAL. This error could lead to + transiently wrong answers from GiST index scans performed in + Hot Standby. + * See release notes for a full list of changes: + http://www.postgresql.org/docs/9.3/static/release-9-3-5.html + /usr/share/doc/packages/postgresql93/HISTORY + +- Remove obsolete postgresql-plperl.patch + +------------------------------------------------------------------- postgresql93.changes: same change Old: ---- postgresql-9.3.4.tar.bz2 postgresql-plperl.patch New: ---- postgresql-9.3.5.tar.bz2 postgresql-tmpfiles.conf postgresql-var-run-socket.patch ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postgresql93-libs.spec ++++++ --- /var/tmp/diff_new_pack.HXJn0k/_old 2014-07-31 21:50:25.000000000 +0200 +++ /var/tmp/diff_new_pack.HXJn0k/_new 2014-07-31 21:50:25.000000000 +0200 @@ -16,6 +16,8 @@ # +%{!?_tmpfilesdir:%global _tmpfilesdir /usr/lib/tmpfiles.d} + %define majorversion 9.3 %define packageversion 93 %define pgname postgresql%packageversion @@ -49,6 +51,11 @@ BuildRequires: timezone BuildRequires: uuid-devel BuildRequires: zlib-devel +# +%if 0%{?suse_version} >= 1210 +BuildRequires: systemd +%endif +%{?systemd_requires} %endif %if 0%{?suse_version} >= 1110 @@ -70,21 +77,22 @@ Summary: Basic Clients and Utilities for PostgreSQL License: PostgreSQL Group: Productivity/Databases/Tools -Version: 9.3.4 +Version: 9.3.5 Release: 0 %define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/') Source0: postgresql-%version.tar.bz2 Source1: baselibs.conf Source3: postgresql-README.SUSE +Source4: postgresql-tmpfiles.conf Source15: postgresql-bashprofile Source17: postgresql-rpmlintrc Patch1: postgresql-conf.patch Patch2: postgresql-regress.patch Patch3: postgresql-sle10-timestamptz.patch -Patch4: postgresql-plperl.patch Patch6: postgresql-testsuite-int8.sql.patch Patch7: postgresql-testsuite-seclabel-location.patch Patch8: postgresql-testsuite-keep-results-file.patch +Patch9: postgresql-var-run-socket.patch Url: http://www.postgresql.org/ BuildRoot: %{_tmppath}/%{name}-%{version}-build Provides: postgresql = %version @@ -190,6 +198,9 @@ Requires(postun): postgresql-init >= %majorversion Requires(post): update-alternatives Requires(postun): update-alternatives +%if 0%{?suse_version} >= 1210 +Requires(post): systemd +%endif %description server PostgreSQL is an advanced object-relational database management system @@ -325,9 +336,10 @@ %patch6 -p1 %patch7 -p1 %patch8 -p1 +%patch9 -p1 touch -r tmp configure rm tmp -find src/test/ -name '*.orig' -print0 | xargs -0 rm -r +find src/test/ -name '*.orig' -print0 | xargs -r0 rm -r %build PACKAGE_TARNAME=%name %configure \ @@ -469,6 +481,8 @@ cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \ README HISTORY doc/bug.template %buildroot%pgdocdir cp -a %SOURCE3 %buildroot%pgdocdir/README.SUSE +install -d -m755 %buildroot/%_tmpfilesdir +install -m644 %SOURCE4 %buildroot%_tmpfilesdir/%pgname.conf %endif # Use versioned names for the man pages: for f in %buildroot%pgmandir/man*/*; do @@ -558,6 +572,9 @@ -c "PostgreSQL Server" -u 26 postgres 2>/dev/null || : %post server -f alternatives +%if 0%{?suse_version} >= 1210 +systemd-tmpfiles --create %pgname.conf +%endif %preun server # Stop only when we are uninstalling the currently running version @@ -661,12 +678,15 @@ %pgextensiondir/plpgsql* %attr(750,postgres,postgres) %dir /var/lib/pgsql %attr(640,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile +%_tmpfilesdir + %files pltcl -f pltcl.lang %defattr(-,root,root) %pgextensiondir/pltcl* %pglibdir/pltcl.so %pgdatadir/*.pltcl %pgbindir/pltcl* + %files plperl -f plperl.lang %defattr(-,root,root) %pgextensiondir/plperl* postgresql93.spec: same change ++++++ postgresql-9.3.4.tar.bz2 -> postgresql-9.3.5.tar.bz2 ++++++ /work/SRC/openSUSE:Factory/postgresql93/postgresql-9.3.4.tar.bz2 /work/SRC/openSUSE:Factory/.postgresql93.new/postgresql-9.3.5.tar.bz2 differ: char 11, line 1 ++++++ postgresql-conf.patch ++++++ --- /var/tmp/diff_new_pack.HXJn0k/_old 2014-07-31 21:50:26.000000000 +0200 +++ /var/tmp/diff_new_pack.HXJn0k/_new 2014-07-31 21:50:26.000000000 +0200 @@ -1,8 +1,8 @@ Index: src/backend/utils/misc/postgresql.conf.sample =================================================================== ---- src/backend/utils/misc/postgresql.conf.sample.orig -+++ src/backend/utils/misc/postgresql.conf.sample -@@ -273,13 +273,13 @@ +--- src/backend/utils/misc/postgresql.conf.sample.orig 2014-07-21 21:10:42.000000000 +0200 ++++ src/backend/utils/misc/postgresql.conf.sample 2014-07-25 12:48:28.623693877 +0200 +@@ -295,13 +295,13 @@ # - Where to Log - @@ -18,7 +18,7 @@ # into log files. Required to be on for # csvlogs. # (change requires restart) -@@ -374,7 +374,8 @@ +@@ -393,7 +393,8 @@ #log_duration = off #log_error_verbosity = default # terse, default, or verbose messages #log_hostname = off ++++++ postgresql-regress.patch ++++++ --- /var/tmp/diff_new_pack.HXJn0k/_old 2014-07-31 21:50:26.000000000 +0200 +++ /var/tmp/diff_new_pack.HXJn0k/_new 2014-07-31 21:50:26.000000000 +0200 @@ -1,8 +1,8 @@ Index: src/test/regress/expected/horology.out =================================================================== ---- src/test/regress/expected/horology.out.orig -+++ src/test/regress/expected/horology.out -@@ -616,26 +616,26 @@ SELECT (timestamp with time zone 'tomorr +--- src/test/regress/expected/horology.out.orig 2014-07-21 21:10:42.000000000 +0200 ++++ src/test/regress/expected/horology.out 2014-07-25 12:48:36.948801528 +0200 +@@ -652,26 +652,26 @@ (1 row) -- timestamp with time zone, interval arithmetic around DST change @@ -36,9 +36,9 @@ Sat Apr 02 11:00:00 2005 CST Index: src/test/regress/pg_regress.c =================================================================== ---- src/test/regress/pg_regress.c.orig -+++ src/test/regress/pg_regress.c -@@ -72,7 +72,7 @@ static char *shellprog = SHELLPROG; +--- src/test/regress/pg_regress.c.orig 2014-07-21 21:10:42.000000000 +0200 ++++ src/test/regress/pg_regress.c 2014-07-25 12:48:36.949801541 +0200 +@@ -73,7 +73,7 @@ */ #ifndef WIN32 const char *basic_diff_opts = ""; @@ -49,9 +49,9 @@ const char *pretty_diff_opts = "-w -C3"; Index: src/test/regress/sql/horology.sql =================================================================== ---- src/test/regress/sql/horology.sql.orig -+++ src/test/regress/sql/horology.sql -@@ -116,11 +116,11 @@ SELECT (timestamp with time zone 'tomorr +--- src/test/regress/sql/horology.sql.orig 2014-07-21 21:10:42.000000000 +0200 ++++ src/test/regress/sql/horology.sql 2014-07-25 12:48:36.949801541 +0200 +@@ -122,11 +122,11 @@ SELECT (timestamp with time zone 'tomorrow' > 'now') as "True"; -- timestamp with time zone, interval arithmetic around DST change ++++++ postgresql-testsuite-keep-results-file.patch ++++++ --- /var/tmp/diff_new_pack.HXJn0k/_old 2014-07-31 21:50:26.000000000 +0200 +++ /var/tmp/diff_new_pack.HXJn0k/_new 2014-07-31 21:50:26.000000000 +0200 @@ -4,11 +4,11 @@ don't unlink the result file -diff --git a/src/test/regress/pg_regress.c b/src/test/regress/pg_regress.c -index c8b45c9..9e9a7c7 100644 ---- a/src/test/regress/pg_regress.c -+++ b/src/test/regress/pg_regress.c -@@ -2411,7 +2411,6 @@ regression_main(int argc, char *argv[], init_function ifunc, test_function tfunc +Index: postgresql-9.3.5/src/test/regress/pg_regress.c +=================================================================== +--- postgresql-9.3.5.orig/src/test/regress/pg_regress.c 2014-07-25 12:48:36.949801541 +0200 ++++ postgresql-9.3.5/src/test/regress/pg_regress.c 2014-07-25 12:48:53.895020651 +0200 +@@ -2515,7 +2515,6 @@ else { unlink(difffilename); @@ -16,4 +16,3 @@ } if (fail_count != 0) - ++++++ postgresql-testsuite-seclabel-location.patch ++++++ --- /var/tmp/diff_new_pack.HXJn0k/_old 2014-07-31 21:50:26.000000000 +0200 +++ /var/tmp/diff_new_pack.HXJn0k/_new 2014-07-31 21:50:26.000000000 +0200 @@ -4,11 +4,11 @@ fix directory macro -diff --git a/src/test/regress/input/security_label.source b/src/test/regress/input/security_label.source -index 9b430b0..bb0af60 100644 ---- a/src/test/regress/input/security_label.source -+++ b/src/test/regress/input/security_label.source -@@ -39,7 +39,7 @@ SECURITY LABEL ON ROLE seclabel_user1 IS '...invalid label...'; -- fail +Index: postgresql-9.3.5/src/test/regress/input/security_label.source +=================================================================== +--- postgresql-9.3.5.orig/src/test/regress/input/security_label.source 2014-07-21 21:10:42.000000000 +0200 ++++ postgresql-9.3.5/src/test/regress/input/security_label.source 2014-07-25 12:48:43.520886510 +0200 +@@ -40,7 +40,7 @@ SECURITY LABEL ON ROLE seclabel_user3 IS 'unclassified'; -- fail -- Load dummy external security provider @@ -17,4 +17,3 @@ -- -- Test of SECURITY LABEL statement with a plugin - ++++++ postgresql-tmpfiles.conf ++++++ # For the PostgreSQL server's unix domain socket d /var/run/postgresql 0755 postgres postgres - ++++++ postgresql-var-run-socket.patch ++++++ Change the built-in default socket directory to be /var/run/postgresql. For backwards compatibility with (probably non-libpq-based) clients that might still expect to find the socket in /tmp, also create a socket in /tmp. This is to resolve communication problems with clients operating under systemd's PrivateTmp environment, which won't be using the same global /tmp directory as the server; see bug #825448. Note that we apply the socket directory change at the level of the hard-wired defaults in the C code, not by just twiddling the setting in postgresql.conf.sample; this is so that the change will take effect on server package update, without requiring any existing postgresql.conf to be updated. (Of course, a user who dislikes this behavior can still override it via postgresql.conf.) Index: postgresql-9.3.5/contrib/pg_upgrade/test.sh =================================================================== --- postgresql-9.3.5.orig/contrib/pg_upgrade/test.sh 2014-07-25 12:48:53.890020586 +0200 +++ postgresql-9.3.5/contrib/pg_upgrade/test.sh 2014-07-25 12:54:10.221108886 +0200 @@ -138,6 +138,12 @@ EXTRA_REGRESS_OPTS="$EXTRA_REGRESS_OPTS --port=$PGPORT" export EXTRA_REGRESS_OPTS +# we want the Unix sockets in $temp_root +PGHOST=$temp_root +export PGHOST + +POSTMASTER_OPTS="$POSTMASTER_OPTS -c unix_socket_directories='$PGHOST'" + # enable echo so the user can see what is being executed set -x Index: postgresql-9.3.5/src/backend/utils/misc/guc.c =================================================================== --- postgresql-9.3.5.orig/src/backend/utils/misc/guc.c 2014-07-25 12:48:53.893020625 +0200 +++ postgresql-9.3.5/src/backend/utils/misc/guc.c 2014-07-25 12:54:10.223108912 +0200 @@ -2971,7 +2971,7 @@ }, &Unix_socket_directories, #ifdef HAVE_UNIX_SOCKETS - DEFAULT_PGSOCKET_DIR, + DEFAULT_PGSOCKET_DIR ", /tmp", #else "", #endif Index: postgresql-9.3.5/src/bin/initdb/initdb.c =================================================================== --- postgresql-9.3.5.orig/src/bin/initdb/initdb.c 2014-07-25 12:48:53.894020638 +0200 +++ postgresql-9.3.5/src/bin/initdb/initdb.c 2014-07-25 12:54:10.223108912 +0200 @@ -1204,7 +1204,7 @@ #ifdef HAVE_UNIX_SOCKETS snprintf(repltok, sizeof(repltok), "#unix_socket_directories = '%s'", - DEFAULT_PGSOCKET_DIR); + DEFAULT_PGSOCKET_DIR ", /tmp"); #else snprintf(repltok, sizeof(repltok), "#unix_socket_directories = ''"); #endif Index: postgresql-9.3.5/src/include/pg_config_manual.h =================================================================== --- postgresql-9.3.5.orig/src/include/pg_config_manual.h 2014-07-25 12:48:53.894020638 +0200 +++ postgresql-9.3.5/src/include/pg_config_manual.h 2014-07-25 12:54:10.224108925 +0200 @@ -144,7 +144,7 @@ * here's where to twiddle it. You can also override this at runtime * with the postmaster's -k switch. */ -#define DEFAULT_PGSOCKET_DIR "/tmp" +#define DEFAULT_PGSOCKET_DIR "/var/run/postgresql" /* * The random() function is expected to yield values between 0 and -- To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-commit+help@opensuse.org