Accepting request 678945 from server:database:postgresql

- Drop use of $FIRST_ARG in .spec
  The use of $FIRST_ARG was probably required because of the
  %service_* rpm macros were playing tricks with the shell positional
  parameters. This is bad practice and error prones so let's assume
  that no macros should do that anymore and hence it's safe to assume
  that positional parameters remains unchanged after any rpm macro
  call.

- Change the persmissions for /var/run/postgresql to 1775, so that
  the directory can only be used by users in the postgres group
  (bsc#1123886).

OBS-URL: https://build.opensuse.org/request/show/678945
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql?expand=0&rev=54
This commit is contained in:
Dominique Leuenberger 2019-03-12 08:49:03 +00:00 committed by Git OBS Bridge
commit 3f3a3fbaad
3 changed files with 113 additions and 6 deletions

View File

@ -1,2 +1,3 @@
# For the PostgreSQL server's unix domain socket
d /var/run/postgresql 1777 root root -
d /run/postgresql 1775 postgres postgres - -
f /var/lib/pgsql/.bash_profile 0640 postgres postgres - /usr/share/postgresql/bash_profile

View File

@ -1,3 +1,62 @@
-------------------------------------------------------------------
Fri Feb 22 07:46:53 UTC 2019 - Franck Bui <fbui@suse.com>
- Drop use of $FIRST_ARG in .spec
The use of $FIRST_ARG was probably required because of the
%service_* rpm macros were playing tricks with the shell positional
parameters. This is bad practice and error prones so let's assume
that no macros should do that anymore and hence it's safe to assume
that positional parameters remains unchanged after any rpm macro
call.
-------------------------------------------------------------------
Tue Feb 19 16:05:22 UTC 2019 - Reinhard Max <max@suse.com>
- Change the persmissions for /var/run/postgresql to 1775, so that
the directory can only be used by users in the postgres group
(bsc#1123886).
-------------------------------------------------------------------
Thu Jan 31 13:23:56 UTC 2019 - Reinhard Max <max@suse.com>
- Move bash profile out of /var/lib to allow transactional updates
(bsc#1100397).
- Use /run/postgresql instead of /var/run/postgresql in %ghost and
postgresql-tmpfiles.conf to avoid rpmlint warnings and errors.
-------------------------------------------------------------------
Fri Nov 30 13:14:40 UTC 2018 - Marcus Rueckert <mrueckert@suse.de>
- add /var/run/postgresql to the filelist. as %ghost for systemd
systems and directly for non systemd systems
-------------------------------------------------------------------
Fri Nov 30 11:05:00 UTC 2018 - Marcus Rueckert <mrueckert@suse.de>
- fix the unexpanded macro in the description of server-devel
-------------------------------------------------------------------
Thu Nov 15 14:34:28 UTC 2018 - Reinhard Max <max@suse.com>
- Also bump the default package to 11.
-------------------------------------------------------------------
Wed Nov 7 16:57:50 UTC 2018 - Marcus Rueckert <mrueckert@suse.de>
- add server-devel and llvmjit package file sections
-------------------------------------------------------------------
Thu Oct 25 13:14:25 UTC 2018 - Reinhard Max <max@suse.com>
- Add the new subpackages server-devel and llvmjit that were
introduced with postgresql11.
-------------------------------------------------------------------
Mon Jul 2 17:08:32 UTC 2018 - mrueckert@suse.de
- bump to 11
-------------------------------------------------------------------
Mon Apr 30 13:26:49 UTC 2018 - dimstar@opensuse.org

View File

@ -15,7 +15,7 @@
# Please submit bugfixes or comments via http://bugs.opensuse.org/
#
%define defaultpackage postgresql10
%define defaultpackage postgresql%version
#Compat macro for new _fillupdir macro introduced in Nov 2017
%if ! %{defined _fillupdir}
@ -32,7 +32,7 @@ Name: postgresql
Summary: Basic Clients and Utilities for PostgreSQL
License: PostgreSQL
Group: Productivity/Databases/Tools
Version: 10
Version: 11
Release: 0
Url: https://www.postgresql.org/
BuildRoot: %{_tmppath}/%{name}-%{version}-build
@ -102,6 +102,41 @@ This package includes the programs needed to create and run a
PostgreSQL server, which will in turn allow you to create and maintain
PostgreSQL databases.
%package server-devel
Summary: PostgreSQL server development header files and utilities
Group: Development/Libraries/C and C++
Provides: postgresql-server-devel-noarch = %version-%release
Requires: postgresql-server-devel-implementation
Recommends: %defaultpackage-server-devel
%description server-devel
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, and user-defined
types and functions.
This package contains the header files and libraries needed to compile
C extensions that link into the PostgreSQL server. For building client
applications, see the %defaultpackage-devel package.
%package llvmjit
Summary: Just-in-time compilation support for PostgreSQL
Group: Productivity/Databases/Servers
Provides: postgresql-llvmjit-noarch = %version-%release
Requires: postgresql-llvmjit-implementation
Recommends: %defaultpackage-llvmjit
%description llvmjit
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, sub-queries, triggers, and user-defined
types and functions.
This package contains support for just-in-time compiling parts of
PostgreSQL queries. Using LLVM it compiles e.g. expressions and tuple
deforming into native code, with the goal of accelerating analytics
queries.
%package test
Summary: The test suite for PostgreSQL
Group: Productivity/Databases/Servers
@ -233,7 +268,7 @@ echo "This is a dummy package to provide a dependency on the default PostgreSQL
%install
mkdir -p %buildroot/var/lib/pgsql/
install -m640 %{SOURCE5} %buildroot/var/lib/pgsql/.bash_profile
mkdir -p %buildroot/var/run/postgresql
install -m755 -d %buildroot%{_fillupdir}
install -m644 %{S:1} %buildroot%{_fillupdir}/sysconfig.postgresql
@ -244,6 +279,7 @@ install -m644 %{S:2} %buildroot%fwdir/%fwname
install -m755 -d %buildroot/usr/sbin
install -m755 -d %buildroot/usr/share/postgresql
install -m640 %{S:7} %buildroot/usr/share/postgresql/bash_profile
install -m755 %{S:7} %buildroot/usr/share/postgresql/install-alternatives
%if %{with systemd}
@ -276,7 +312,7 @@ getent passwd postgres > /dev/null ||
# Save the "enabled" and "active" state across the transition of
# ownership of postgresql.service from postgresql-init to
# postgresql-server.
if [ "$FIRST_ARG" -ge 1 ]; then \
if [ $1 -ge 1 ]; then \
if [ x$(systemctl is-enabled postgresql.service 2>/dev/null ||:) = "xenabled" ]; then
touch %eflag
fi
@ -334,7 +370,8 @@ fi
%defattr(-,root,root,-)
%doc README
%attr(750,postgres,postgres) %dir /var/lib/pgsql
%attr(640,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile
%attr(644,root,root) /usr/share/postgresql/bash_profile
%ghost %config %attr(640,postgres,postgres) /var/lib/pgsql/.bash_profile
%if 0%{?suse_version} > 1110
%dir %fwdir
@ -347,8 +384,10 @@ fi
%_tmpfilesdir/postgresql.conf
%_unitdir/
/usr/share/postgresql/postgresql-script
%ghost %dir %attr(1775,root,root) /run/postgresql
%else
%config /etc/init.d/postgresql
%dir %attr(1775,root,root) /var/run/postgresql
%endif
%files test
@ -367,6 +406,14 @@ fi
%defattr(-,root,root,-)
%doc README
%files server-devel
%defattr(-,root,root,-)
%doc README
%files llvmjit
%defattr(-,root,root,-)
%doc README
%files plperl
%defattr(-,root,root,-)
%doc README