Date: Tuesday, March 8, 2022 @ 22:31:30 Author: anthraxx Revision: 439362
archrelease: copy trunk to extra-x86_64 Added: pgbouncer/repos/extra-x86_64/PKGBUILD (from rev 439361, pgbouncer/trunk/PKGBUILD) pgbouncer/repos/extra-x86_64/pgbouncer.ini (from rev 439361, pgbouncer/trunk/pgbouncer.ini) pgbouncer/repos/extra-x86_64/pgbouncer.logrotate (from rev 439361, pgbouncer/trunk/pgbouncer.logrotate) pgbouncer/repos/extra-x86_64/pgbouncer.service (from rev 439361, pgbouncer/trunk/pgbouncer.service) pgbouncer/repos/extra-x86_64/pgbouncer.sysusers (from rev 439361, pgbouncer/trunk/pgbouncer.sysusers) pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf (from rev 439361, pgbouncer/trunk/pgbouncer.tmpfiles.conf) Deleted: pgbouncer/repos/extra-x86_64/PKGBUILD pgbouncer/repos/extra-x86_64/pgbouncer.ini pgbouncer/repos/extra-x86_64/pgbouncer.logrotate pgbouncer/repos/extra-x86_64/pgbouncer.service pgbouncer/repos/extra-x86_64/pgbouncer.sysusers pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf -------------------------+ PKGBUILD | 110 +++++++++++++++++++++++----------------------- pgbouncer.ini | 104 +++++++++++++++++++++---------------------- pgbouncer.logrotate | 16 +++--- pgbouncer.service | 22 ++++----- pgbouncer.sysusers | 6 +- pgbouncer.tmpfiles.conf | 8 +-- 6 files changed, 133 insertions(+), 133 deletions(-) Deleted: PKGBUILD =================================================================== --- PKGBUILD 2022-03-08 22:31:23 UTC (rev 439361) +++ PKGBUILD 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,55 +0,0 @@ -# Maintainer: Levente Polyak <anthraxx[at]archlinux[dot]org> -# Contributor: Dan McGee <d...@archlinux.org> - -pkgname=pgbouncer -pkgver=1.16.0 -pkgrel=1 -pkgdesc='Lightweight connection pooler for PostgreSQL' -url='https://pgbouncer.github.io/' -arch=('x86_64') -license=('BSD') -depends=('glibc' 'libevent' 'c-ares' 'libcares.so' 'systemd' 'pam' 'libpam.so' 'openssl') -makedepends=('asciidoc' 'xmlto') -checkdepends=('postgresql-libs' 'postgresql') -backup=('etc/pgbouncer/pgbouncer.ini' - 'etc/logrotate.d/pgbouncer') -source=(https://pgbouncer.github.io/downloads/files/${pkgver}/pgbouncer-${pkgver}.tar.gz - pgbouncer.ini - pgbouncer.logrotate - pgbouncer.service - pgbouncer.tmpfiles.conf - pgbouncer.sysusers) -sha512sums=('3b6f23052ca3b8af40a618da6bed2577b92ffe27b627f8980cda2d645991434bf298f720c1d423a272961c9f3f52a9d1b28154ed7f355d539f71dc68c028b617' - '39abc7b11c9d7a2593941b4d2a82db998ac1b1e3da131ae276da73c7afc4eda7b69bbfd0acd39f7bce20ecb911baf0adba341ff58dcab1a57e419708e7c8d26f' - '1dc86704fce211b23afe7962c947c7de80a15bef219928acbf486b915d80d44a6590fbc509fe650c97b694a508bcf95d2152663863f0c372323286e644c6d60a' - '2b4baaaa7129eda54b34405aa4e15a4d37b2173b529ecae070e766f1dcebd0af8f6898ee1b665a60d5f633036a52662e89967f33caacf2841dad441960230ef7' - '0757205e5cb5f679bab00bdbed2c828a536239f380d537498bc893c77162e0978308a5f38fae4cb6470f18d6ed0fe4a3ce8f00e85aef89b14bcf6e2eab05a696' - '05551189022bd160ca0d64831d2559480ae2dcfe8a489aa4c22cc375c3def31d1169e48e17e6502ccd18237d79afef5bc4587f3cf14274c125eb71311d00503b') - -build() { - cd ${pkgname}-${pkgver} - ./configure \ - --prefix=/usr \ - --disable-debug \ - --with-pam - make -} - -check() { - cd ${pkgname}-${pkgver} - make -C test check -} - -package() { - cd ${pkgname}-${pkgver} - make DESTDIR="${pkgdir}" install - install -Dm 644 NEWS.md -t "${pkgdir}/usr/share/doc/${pkgname}" - install -Dm 644 COPYRIGHT -t "${pkgdir}/usr/share/licenses/${pkgname}" - install -Dm 644 ../pgbouncer.ini "${pkgdir}/etc/pgbouncer/pgbouncer.ini" - install -Dm 644 ../pgbouncer.logrotate "${pkgdir}/etc/logrotate.d/pgbouncer" - install -Dm 644 ../pgbouncer.service "${pkgdir}/usr/lib/systemd/system/pgbouncer.service" - install -Dm 644 ../pgbouncer.tmpfiles.conf "${pkgdir}/usr/lib/tmpfiles.d/pgbouncer.conf" - install -Dm 644 ../pgbouncer.sysusers "${pkgdir}/usr/lib/sysusers.d/pgbouncer.conf" -} - -# vim: ts=2 sw=2 et: Copied: pgbouncer/repos/extra-x86_64/PKGBUILD (from rev 439361, pgbouncer/trunk/PKGBUILD) =================================================================== --- PKGBUILD (rev 0) +++ PKGBUILD 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,55 @@ +# Maintainer: Levente Polyak <anthraxx[at]archlinux[dot]org> +# Contributor: Dan McGee <d...@archlinux.org> + +pkgname=pgbouncer +pkgver=1.16.1 +pkgrel=1 +pkgdesc='Lightweight connection pooler for PostgreSQL' +url='https://pgbouncer.github.io/' +arch=('x86_64') +license=('BSD') +depends=('glibc' 'libevent' 'c-ares' 'libcares.so' 'systemd' 'pam' 'libpam.so' 'openssl') +makedepends=('asciidoc' 'xmlto') +checkdepends=('postgresql-libs' 'postgresql') +backup=('etc/pgbouncer/pgbouncer.ini' + 'etc/logrotate.d/pgbouncer') +source=(https://pgbouncer.github.io/downloads/files/${pkgver}/pgbouncer-${pkgver}.tar.gz + pgbouncer.ini + pgbouncer.logrotate + pgbouncer.service + pgbouncer.tmpfiles.conf + pgbouncer.sysusers) +sha512sums=('9ecb7c7ae136d85e3da434094909df3a6ff06ce8586a1848c0c00914d87a877aecbb26ea30ad8230062160f3177621cc16deb4a490e9a2a649c8032dacb86341' + '39abc7b11c9d7a2593941b4d2a82db998ac1b1e3da131ae276da73c7afc4eda7b69bbfd0acd39f7bce20ecb911baf0adba341ff58dcab1a57e419708e7c8d26f' + '1dc86704fce211b23afe7962c947c7de80a15bef219928acbf486b915d80d44a6590fbc509fe650c97b694a508bcf95d2152663863f0c372323286e644c6d60a' + '2b4baaaa7129eda54b34405aa4e15a4d37b2173b529ecae070e766f1dcebd0af8f6898ee1b665a60d5f633036a52662e89967f33caacf2841dad441960230ef7' + '0757205e5cb5f679bab00bdbed2c828a536239f380d537498bc893c77162e0978308a5f38fae4cb6470f18d6ed0fe4a3ce8f00e85aef89b14bcf6e2eab05a696' + '05551189022bd160ca0d64831d2559480ae2dcfe8a489aa4c22cc375c3def31d1169e48e17e6502ccd18237d79afef5bc4587f3cf14274c125eb71311d00503b') + +build() { + cd ${pkgname}-${pkgver} + ./configure \ + --prefix=/usr \ + --disable-debug \ + --with-pam + make +} + +check() { + cd ${pkgname}-${pkgver} + make -C test check +} + +package() { + cd ${pkgname}-${pkgver} + make DESTDIR="${pkgdir}" install + install -Dm 644 NEWS.md -t "${pkgdir}/usr/share/doc/${pkgname}" + install -Dm 644 COPYRIGHT -t "${pkgdir}/usr/share/licenses/${pkgname}" + install -Dm 644 ../pgbouncer.ini "${pkgdir}/etc/pgbouncer/pgbouncer.ini" + install -Dm 644 ../pgbouncer.logrotate "${pkgdir}/etc/logrotate.d/pgbouncer" + install -Dm 644 ../pgbouncer.service "${pkgdir}/usr/lib/systemd/system/pgbouncer.service" + install -Dm 644 ../pgbouncer.tmpfiles.conf "${pkgdir}/usr/lib/tmpfiles.d/pgbouncer.conf" + install -Dm 644 ../pgbouncer.sysusers "${pkgdir}/usr/lib/sysusers.d/pgbouncer.conf" +} + +# vim: ts=2 sw=2 et: Deleted: pgbouncer.ini =================================================================== --- pgbouncer.ini 2022-03-08 22:31:23 UTC (rev 439361) +++ pgbouncer.ini 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,52 +0,0 @@ -[pgbouncer] -logfile = /var/log/pgbouncer/pgbouncer.log -pidfile = /run/pgbouncer/pgbouncer.pid - -;; ip address or * which means all ip-s -;listen_addr = 127.0.0.1 -;listen_port = 6432 - -unix_socket_dir = /run/postgresql -unix_socket_mode = 0777 - -; any, trust, plain, crypt, md5 -auth_type = trust -auth_file = /etc/pgbouncer/userlist.txt - -; comma-separated list of users, who are allowed to change settings -admin_users = postgres - -; comma-separated list of users who are just allowed to use SHOW command -stats_users = stats, postgres - -; total number of clients that can connect -max_client_conn = 100 - -; default pool size. 20 is good number when transaction pooling -; is in use, in session pooling it needs to be the number of -; max clients you want to handle at any moment -default_pool_size = 20 - - -;; database name = connect string -;; -;; connect string params: -;; dbname= host= port= user= password= -;; client_encoding= datestyle= timezone= -;; pool_size= connect_query= -[databases] - -; foodb over unix socket -;foodb = - -; redirect bardb to bazdb on localhost -;bardb = host=localhost dbname=bazdb - -; acceess to dest database will go with single user -;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1' - -; use custom pool sizes -;nondefaultdb = pool_size=50 reserve_pool=10 - -; fallback connect string -;* = host=testserver Copied: pgbouncer/repos/extra-x86_64/pgbouncer.ini (from rev 439361, pgbouncer/trunk/pgbouncer.ini) =================================================================== --- pgbouncer.ini (rev 0) +++ pgbouncer.ini 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,52 @@ +[pgbouncer] +logfile = /var/log/pgbouncer/pgbouncer.log +pidfile = /run/pgbouncer/pgbouncer.pid + +;; ip address or * which means all ip-s +;listen_addr = 127.0.0.1 +;listen_port = 6432 + +unix_socket_dir = /run/postgresql +unix_socket_mode = 0777 + +; any, trust, plain, crypt, md5 +auth_type = trust +auth_file = /etc/pgbouncer/userlist.txt + +; comma-separated list of users, who are allowed to change settings +admin_users = postgres + +; comma-separated list of users who are just allowed to use SHOW command +stats_users = stats, postgres + +; total number of clients that can connect +max_client_conn = 100 + +; default pool size. 20 is good number when transaction pooling +; is in use, in session pooling it needs to be the number of +; max clients you want to handle at any moment +default_pool_size = 20 + + +;; database name = connect string +;; +;; connect string params: +;; dbname= host= port= user= password= +;; client_encoding= datestyle= timezone= +;; pool_size= connect_query= +[databases] + +; foodb over unix socket +;foodb = + +; redirect bardb to bazdb on localhost +;bardb = host=localhost dbname=bazdb + +; acceess to dest database will go with single user +;forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1' + +; use custom pool sizes +;nondefaultdb = pool_size=50 reserve_pool=10 + +; fallback connect string +;* = host=testserver Deleted: pgbouncer.logrotate =================================================================== --- pgbouncer.logrotate 2022-03-08 22:31:23 UTC (rev 439361) +++ pgbouncer.logrotate 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,8 +0,0 @@ -/var/log/pgbouncer/pgbouncer.log { - copytruncate - missingok - notifempty - postrotate - /bin/kill -HUP $(cat /run/pgbouncer/pgbouncer.pid 2>/dev/null) 2> /dev/null || true - endscript -} Copied: pgbouncer/repos/extra-x86_64/pgbouncer.logrotate (from rev 439361, pgbouncer/trunk/pgbouncer.logrotate) =================================================================== --- pgbouncer.logrotate (rev 0) +++ pgbouncer.logrotate 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,8 @@ +/var/log/pgbouncer/pgbouncer.log { + copytruncate + missingok + notifempty + postrotate + /bin/kill -HUP $(cat /run/pgbouncer/pgbouncer.pid 2>/dev/null) 2> /dev/null || true + endscript +} Deleted: pgbouncer.service =================================================================== --- pgbouncer.service 2022-03-08 22:31:23 UTC (rev 439361) +++ pgbouncer.service 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,11 +0,0 @@ -[Unit] -Description=A lightweight connection pooler for PostgreSQL -After=network.target - -[Service] -User=pgbouncer -ExecStart=/usr/bin/pgbouncer /etc/pgbouncer/pgbouncer.ini -ExecReload=/bin/kill -HUP $MAINPID - -[Install] -WantedBy=multi-user.target Copied: pgbouncer/repos/extra-x86_64/pgbouncer.service (from rev 439361, pgbouncer/trunk/pgbouncer.service) =================================================================== --- pgbouncer.service (rev 0) +++ pgbouncer.service 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,11 @@ +[Unit] +Description=A lightweight connection pooler for PostgreSQL +After=network.target + +[Service] +User=pgbouncer +ExecStart=/usr/bin/pgbouncer /etc/pgbouncer/pgbouncer.ini +ExecReload=/bin/kill -HUP $MAINPID + +[Install] +WantedBy=multi-user.target Deleted: pgbouncer.sysusers =================================================================== --- pgbouncer.sysusers 2022-03-08 22:31:23 UTC (rev 439361) +++ pgbouncer.sysusers 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,3 +0,0 @@ -u pgbouncer - "PGBouncer user" /etc/pgbouncer /bin/bash -u postgres - "PostgreSQL user" /var/lib/postgres /bin/bash -m pgbouncer postgres Copied: pgbouncer/repos/extra-x86_64/pgbouncer.sysusers (from rev 439361, pgbouncer/trunk/pgbouncer.sysusers) =================================================================== --- pgbouncer.sysusers (rev 0) +++ pgbouncer.sysusers 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,3 @@ +u pgbouncer - "PGBouncer user" /etc/pgbouncer /bin/bash +u postgres - "PostgreSQL user" /var/lib/postgres /bin/bash +m pgbouncer postgres Deleted: pgbouncer.tmpfiles.conf =================================================================== --- pgbouncer.tmpfiles.conf 2022-03-08 22:31:23 UTC (rev 439361) +++ pgbouncer.tmpfiles.conf 2022-03-08 22:31:30 UTC (rev 439362) @@ -1,4 +0,0 @@ -d /run/pgbouncer 755 pgbouncer pgbouncer -d /var/lib/postgres/data 700 postgres postgres -h /var/lib/postgres/data - - - - +C -z /var/log/pgbouncer 750 pgbouncer pgbouncer Copied: pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf (from rev 439361, pgbouncer/trunk/pgbouncer.tmpfiles.conf) =================================================================== --- pgbouncer.tmpfiles.conf (rev 0) +++ pgbouncer.tmpfiles.conf 2022-03-08 22:31:30 UTC (rev 439362) @@ -0,0 +1,4 @@ +d /run/pgbouncer 755 pgbouncer pgbouncer +d /var/lib/postgres/data 700 postgres postgres +h /var/lib/postgres/data - - - - +C +z /var/log/pgbouncer 750 pgbouncer pgbouncer