Date: Sunday, February 21, 2016 @ 04:57:30 Author: dan Revision: 260108
archrelease: copy trunk to extra-i686, extra-x86_64 Added: pgbouncer/repos/extra-i686/PKGBUILD (from rev 260107, pgbouncer/trunk/PKGBUILD) pgbouncer/repos/extra-i686/pgbouncer.ini (from rev 260107, pgbouncer/trunk/pgbouncer.ini) pgbouncer/repos/extra-i686/pgbouncer.install (from rev 260107, pgbouncer/trunk/pgbouncer.install) pgbouncer/repos/extra-i686/pgbouncer.logrotate (from rev 260107, pgbouncer/trunk/pgbouncer.logrotate) pgbouncer/repos/extra-i686/pgbouncer.service (from rev 260107, pgbouncer/trunk/pgbouncer.service) pgbouncer/repos/extra-i686/pgbouncer.tmpfiles.conf (from rev 260107, pgbouncer/trunk/pgbouncer.tmpfiles.conf) pgbouncer/repos/extra-x86_64/PKGBUILD (from rev 260107, pgbouncer/trunk/PKGBUILD) pgbouncer/repos/extra-x86_64/pgbouncer.ini (from rev 260107, pgbouncer/trunk/pgbouncer.ini) pgbouncer/repos/extra-x86_64/pgbouncer.install (from rev 260107, pgbouncer/trunk/pgbouncer.install) pgbouncer/repos/extra-x86_64/pgbouncer.logrotate (from rev 260107, pgbouncer/trunk/pgbouncer.logrotate) pgbouncer/repos/extra-x86_64/pgbouncer.service (from rev 260107, pgbouncer/trunk/pgbouncer.service) pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf (from rev 260107, pgbouncer/trunk/pgbouncer.tmpfiles.conf) Deleted: pgbouncer/repos/extra-i686/PKGBUILD pgbouncer/repos/extra-i686/pgbouncer.ini pgbouncer/repos/extra-i686/pgbouncer.install pgbouncer/repos/extra-i686/pgbouncer.logrotate pgbouncer/repos/extra-i686/pgbouncer.service pgbouncer/repos/extra-i686/pgbouncer.tmpfiles.conf pgbouncer/repos/extra-x86_64/PKGBUILD pgbouncer/repos/extra-x86_64/pgbouncer.ini pgbouncer/repos/extra-x86_64/pgbouncer.install pgbouncer/repos/extra-x86_64/pgbouncer.logrotate pgbouncer/repos/extra-x86_64/pgbouncer.service pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf --------------------------------------+ /PKGBUILD | 84 ++++++++++++++++++++++++++ /pgbouncer.ini | 104 +++++++++++++++++++++++++++++++++ /pgbouncer.install | 52 ++++++++++++++++ /pgbouncer.logrotate | 16 +++++ /pgbouncer.service | 22 ++++++ /pgbouncer.tmpfiles.conf | 2 extra-i686/PKGBUILD | 42 ------------- extra-i686/pgbouncer.ini | 52 ---------------- extra-i686/pgbouncer.install | 16 ----- extra-i686/pgbouncer.logrotate | 8 -- extra-i686/pgbouncer.service | 11 --- extra-i686/pgbouncer.tmpfiles.conf | 1 extra-x86_64/PKGBUILD | 42 ------------- extra-x86_64/pgbouncer.ini | 52 ---------------- extra-x86_64/pgbouncer.install | 16 ----- extra-x86_64/pgbouncer.logrotate | 8 -- extra-x86_64/pgbouncer.service | 11 --- extra-x86_64/pgbouncer.tmpfiles.conf | 1 18 files changed, 280 insertions(+), 260 deletions(-) Deleted: extra-i686/PKGBUILD =================================================================== --- extra-i686/PKGBUILD 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/PKGBUILD 2016-02-21 03:57:30 UTC (rev 260108) @@ -1,42 +0,0 @@ -# Maintainer: Dan McGee <d...@archlinux.org> - -pkgname=pgbouncer -pkgver=1.6 -pkgrel=1 -pkgdesc="A lightweight connection pooler for PostgreSQL" -arch=('i686' 'x86_64') -url="https://wiki.postgresql.org/wiki/PgBouncer" -license=('BSD') -depends=('libevent>=2.0' 'c-ares' 'postgresql') -makedepends=('asciidoc' 'xmlto') -backup=('etc/pgbouncer/pgbouncer.ini' 'etc/logrotate.d/pgbouncer') -install=$pkgname.install -source=("https://pgbouncer.github.io/downloads/$pkgname-$pkgver.tar.gz" - pgbouncer.ini - pgbouncer.logrotate - pgbouncer.service - pgbouncer.tmpfiles.conf) -sha256sums=('d0aec755afcdcff0538b513f71ba4de03041f21ed5548171df9de53099efa916' - '4f30e4a3eb76acdd233ebc7dd099dff6976299ba958e40a8429b74112e804b05' - '8da38746d9c9dfc2433a8cfe22fdaf517e14492672d09e3c48cd4745fc03e9bd' - '274a3d447c151323f2d297aae881ec69be1477f16e30b0bba469afe68c2d122a' - '476ea0400ba063e932a58f1f49ae401d65b22add521894872c09ec6985e0960d') - -build() { - cd "$srcdir/$pkgname-$pkgver" - ./configure --prefix=/usr --disable-debug - make -} - -package() { - cd "$srcdir/$pkgname-$pkgver" - make DESTDIR="$pkgdir/" install - install -D -m644 COPYRIGHT "$pkgdir/usr/share/licenses/$pkgname/LICENSE" - install -D -m644 ../pgbouncer.ini "$pkgdir/etc/pgbouncer/pgbouncer.ini" - install -D -m644 ../pgbouncer.logrotate "$pkgdir/etc/logrotate.d/pgbouncer" - install -D -m644 ../pgbouncer.service "$pkgdir/usr/lib/systemd/system/pgbouncer.service" - install -D -m644 ../pgbouncer.tmpfiles.conf "$pkgdir/usr/lib/tmpfiles.d/pgbouncer.conf" - mkdir -p "$pkgdir/var/log/pgbouncer" -} - -# vim:set ts=2 sw=2 et: Copied: pgbouncer/repos/extra-i686/PKGBUILD (from rev 260107, pgbouncer/trunk/PKGBUILD) =================================================================== --- extra-i686/PKGBUILD (rev 0) +++ extra-i686/PKGBUILD 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1,42 @@ +# Maintainer: Dan McGee <d...@archlinux.org> + +pkgname=pgbouncer +pkgver=1.7.1 +pkgrel=1 +pkgdesc="A lightweight connection pooler for PostgreSQL" +arch=('i686' 'x86_64') +url="https://wiki.postgresql.org/wiki/PgBouncer" +license=('BSD') +depends=('libevent>=2.0' 'c-ares') +makedepends=('asciidoc' 'xmlto') +backup=('etc/pgbouncer/pgbouncer.ini' 'etc/logrotate.d/pgbouncer') +install=$pkgname.install +source=("https://pgbouncer.github.io/downloads/files/$pkgver/$pkgname-$pkgver.tar.gz" + pgbouncer.ini + pgbouncer.logrotate + pgbouncer.service + pgbouncer.tmpfiles.conf) +sha256sums=('f72bcdfd8a8d1ee22f509cebc59fb50d394063ce0175f0deea07b5fb2849e8a1' + '4f30e4a3eb76acdd233ebc7dd099dff6976299ba958e40a8429b74112e804b05' + '8da38746d9c9dfc2433a8cfe22fdaf517e14492672d09e3c48cd4745fc03e9bd' + '274a3d447c151323f2d297aae881ec69be1477f16e30b0bba469afe68c2d122a' + '476ea0400ba063e932a58f1f49ae401d65b22add521894872c09ec6985e0960d') + +build() { + cd "$srcdir/$pkgname-$pkgver" + ./configure --prefix=/usr --disable-debug + make +} + +package() { + cd "$srcdir/$pkgname-$pkgver" + make DESTDIR="$pkgdir/" install + install -D -m644 COPYRIGHT "$pkgdir/usr/share/licenses/$pkgname/LICENSE" + install -D -m644 ../pgbouncer.ini "$pkgdir/etc/pgbouncer/pgbouncer.ini" + install -D -m644 ../pgbouncer.logrotate "$pkgdir/etc/logrotate.d/pgbouncer" + install -D -m644 ../pgbouncer.service "$pkgdir/usr/lib/systemd/system/pgbouncer.service" + install -D -m644 ../pgbouncer.tmpfiles.conf "$pkgdir/usr/lib/tmpfiles.d/pgbouncer.conf" + mkdir -p "$pkgdir/var/log/pgbouncer" +} + +# vim:set ts=2 sw=2 et: Deleted: extra-i686/pgbouncer.ini =================================================================== --- extra-i686/pgbouncer.ini 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/pgbouncer.ini 2016-02-21 03:57:30 UTC (rev 260108) @@ -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-i686/pgbouncer.ini (from rev 260107, pgbouncer/trunk/pgbouncer.ini) =================================================================== --- extra-i686/pgbouncer.ini (rev 0) +++ extra-i686/pgbouncer.ini 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-i686/pgbouncer.install =================================================================== --- extra-i686/pgbouncer.install 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/pgbouncer.install 2016-02-21 03:57:30 UTC (rev 260108) @@ -1,16 +0,0 @@ -post_install() { - if ! getent group pgbouncer >/dev/null; then - groupadd -r pgbouncer - fi - if ! getent passwd pgbouncer >/dev/null; then - useradd -c 'PGBouncer user' -r -g pgbouncer -d '/etc/pgbouncer' -s /bin/bash pgbouncer - passwd -l pgbouncer >/dev/null - fi - chown pgbouncer:pgbouncer /var/log/pgbouncer - systemd-tmpfiles --create pgbouncer.conf - post_upgrade -} - -post_upgrade() { - gpasswd -a pgbouncer postgres -} Copied: pgbouncer/repos/extra-i686/pgbouncer.install (from rev 260107, pgbouncer/trunk/pgbouncer.install) =================================================================== --- extra-i686/pgbouncer.install (rev 0) +++ extra-i686/pgbouncer.install 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1,26 @@ +post_install() { + if [ ! -d '/var/lib/postgres' ]; then + mkdir -p '/var/lib/postgres' + fi + if ! getent group postgres >/dev/null; then + groupadd -g 88 postgres + fi + if ! getent passwd postgres >/dev/null; then + useradd -c 'PostgreSQL user' -u 88 -g postgres -d '/var/lib/postgres' -s /bin/bash postgres + passwd -l postgres >/dev/null + fi + if ! getent group pgbouncer >/dev/null; then + groupadd -r pgbouncer + fi + if ! getent passwd pgbouncer >/dev/null; then + useradd -c 'PGBouncer user' -r -g pgbouncer -d '/etc/pgbouncer' -s /bin/bash pgbouncer + passwd -l pgbouncer >/dev/null + fi + chown pgbouncer:pgbouncer /var/log/pgbouncer + systemd-tmpfiles --create pgbouncer.conf + gpasswd -a pgbouncer postgres +} + +post_upgrade() { + post_install $1 +} Deleted: extra-i686/pgbouncer.logrotate =================================================================== --- extra-i686/pgbouncer.logrotate 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/pgbouncer.logrotate 2016-02-21 03:57:30 UTC (rev 260108) @@ -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-i686/pgbouncer.logrotate (from rev 260107, pgbouncer/trunk/pgbouncer.logrotate) =================================================================== --- extra-i686/pgbouncer.logrotate (rev 0) +++ extra-i686/pgbouncer.logrotate 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-i686/pgbouncer.service =================================================================== --- extra-i686/pgbouncer.service 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/pgbouncer.service 2016-02-21 03:57:30 UTC (rev 260108) @@ -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-i686/pgbouncer.service (from rev 260107, pgbouncer/trunk/pgbouncer.service) =================================================================== --- extra-i686/pgbouncer.service (rev 0) +++ extra-i686/pgbouncer.service 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-i686/pgbouncer.tmpfiles.conf =================================================================== --- extra-i686/pgbouncer.tmpfiles.conf 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-i686/pgbouncer.tmpfiles.conf 2016-02-21 03:57:30 UTC (rev 260108) @@ -1 +0,0 @@ -d /run/pgbouncer 0755 pgbouncer pgbouncer - Copied: pgbouncer/repos/extra-i686/pgbouncer.tmpfiles.conf (from rev 260107, pgbouncer/trunk/pgbouncer.tmpfiles.conf) =================================================================== --- extra-i686/pgbouncer.tmpfiles.conf (rev 0) +++ extra-i686/pgbouncer.tmpfiles.conf 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1 @@ +d /run/pgbouncer 0755 pgbouncer pgbouncer - Deleted: extra-x86_64/PKGBUILD =================================================================== --- extra-x86_64/PKGBUILD 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/PKGBUILD 2016-02-21 03:57:30 UTC (rev 260108) @@ -1,42 +0,0 @@ -# Maintainer: Dan McGee <d...@archlinux.org> - -pkgname=pgbouncer -pkgver=1.6 -pkgrel=1 -pkgdesc="A lightweight connection pooler for PostgreSQL" -arch=('i686' 'x86_64') -url="https://wiki.postgresql.org/wiki/PgBouncer" -license=('BSD') -depends=('libevent>=2.0' 'c-ares' 'postgresql') -makedepends=('asciidoc' 'xmlto') -backup=('etc/pgbouncer/pgbouncer.ini' 'etc/logrotate.d/pgbouncer') -install=$pkgname.install -source=("https://pgbouncer.github.io/downloads/$pkgname-$pkgver.tar.gz" - pgbouncer.ini - pgbouncer.logrotate - pgbouncer.service - pgbouncer.tmpfiles.conf) -sha256sums=('d0aec755afcdcff0538b513f71ba4de03041f21ed5548171df9de53099efa916' - '4f30e4a3eb76acdd233ebc7dd099dff6976299ba958e40a8429b74112e804b05' - '8da38746d9c9dfc2433a8cfe22fdaf517e14492672d09e3c48cd4745fc03e9bd' - '274a3d447c151323f2d297aae881ec69be1477f16e30b0bba469afe68c2d122a' - '476ea0400ba063e932a58f1f49ae401d65b22add521894872c09ec6985e0960d') - -build() { - cd "$srcdir/$pkgname-$pkgver" - ./configure --prefix=/usr --disable-debug - make -} - -package() { - cd "$srcdir/$pkgname-$pkgver" - make DESTDIR="$pkgdir/" install - install -D -m644 COPYRIGHT "$pkgdir/usr/share/licenses/$pkgname/LICENSE" - install -D -m644 ../pgbouncer.ini "$pkgdir/etc/pgbouncer/pgbouncer.ini" - install -D -m644 ../pgbouncer.logrotate "$pkgdir/etc/logrotate.d/pgbouncer" - install -D -m644 ../pgbouncer.service "$pkgdir/usr/lib/systemd/system/pgbouncer.service" - install -D -m644 ../pgbouncer.tmpfiles.conf "$pkgdir/usr/lib/tmpfiles.d/pgbouncer.conf" - mkdir -p "$pkgdir/var/log/pgbouncer" -} - -# vim:set ts=2 sw=2 et: Copied: pgbouncer/repos/extra-x86_64/PKGBUILD (from rev 260107, pgbouncer/trunk/PKGBUILD) =================================================================== --- extra-x86_64/PKGBUILD (rev 0) +++ extra-x86_64/PKGBUILD 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1,42 @@ +# Maintainer: Dan McGee <d...@archlinux.org> + +pkgname=pgbouncer +pkgver=1.7.1 +pkgrel=1 +pkgdesc="A lightweight connection pooler for PostgreSQL" +arch=('i686' 'x86_64') +url="https://wiki.postgresql.org/wiki/PgBouncer" +license=('BSD') +depends=('libevent>=2.0' 'c-ares') +makedepends=('asciidoc' 'xmlto') +backup=('etc/pgbouncer/pgbouncer.ini' 'etc/logrotate.d/pgbouncer') +install=$pkgname.install +source=("https://pgbouncer.github.io/downloads/files/$pkgver/$pkgname-$pkgver.tar.gz" + pgbouncer.ini + pgbouncer.logrotate + pgbouncer.service + pgbouncer.tmpfiles.conf) +sha256sums=('f72bcdfd8a8d1ee22f509cebc59fb50d394063ce0175f0deea07b5fb2849e8a1' + '4f30e4a3eb76acdd233ebc7dd099dff6976299ba958e40a8429b74112e804b05' + '8da38746d9c9dfc2433a8cfe22fdaf517e14492672d09e3c48cd4745fc03e9bd' + '274a3d447c151323f2d297aae881ec69be1477f16e30b0bba469afe68c2d122a' + '476ea0400ba063e932a58f1f49ae401d65b22add521894872c09ec6985e0960d') + +build() { + cd "$srcdir/$pkgname-$pkgver" + ./configure --prefix=/usr --disable-debug + make +} + +package() { + cd "$srcdir/$pkgname-$pkgver" + make DESTDIR="$pkgdir/" install + install -D -m644 COPYRIGHT "$pkgdir/usr/share/licenses/$pkgname/LICENSE" + install -D -m644 ../pgbouncer.ini "$pkgdir/etc/pgbouncer/pgbouncer.ini" + install -D -m644 ../pgbouncer.logrotate "$pkgdir/etc/logrotate.d/pgbouncer" + install -D -m644 ../pgbouncer.service "$pkgdir/usr/lib/systemd/system/pgbouncer.service" + install -D -m644 ../pgbouncer.tmpfiles.conf "$pkgdir/usr/lib/tmpfiles.d/pgbouncer.conf" + mkdir -p "$pkgdir/var/log/pgbouncer" +} + +# vim:set ts=2 sw=2 et: Deleted: extra-x86_64/pgbouncer.ini =================================================================== --- extra-x86_64/pgbouncer.ini 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/pgbouncer.ini 2016-02-21 03:57:30 UTC (rev 260108) @@ -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 260107, pgbouncer/trunk/pgbouncer.ini) =================================================================== --- extra-x86_64/pgbouncer.ini (rev 0) +++ extra-x86_64/pgbouncer.ini 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-x86_64/pgbouncer.install =================================================================== --- extra-x86_64/pgbouncer.install 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/pgbouncer.install 2016-02-21 03:57:30 UTC (rev 260108) @@ -1,16 +0,0 @@ -post_install() { - if ! getent group pgbouncer >/dev/null; then - groupadd -r pgbouncer - fi - if ! getent passwd pgbouncer >/dev/null; then - useradd -c 'PGBouncer user' -r -g pgbouncer -d '/etc/pgbouncer' -s /bin/bash pgbouncer - passwd -l pgbouncer >/dev/null - fi - chown pgbouncer:pgbouncer /var/log/pgbouncer - systemd-tmpfiles --create pgbouncer.conf - post_upgrade -} - -post_upgrade() { - gpasswd -a pgbouncer postgres -} Copied: pgbouncer/repos/extra-x86_64/pgbouncer.install (from rev 260107, pgbouncer/trunk/pgbouncer.install) =================================================================== --- extra-x86_64/pgbouncer.install (rev 0) +++ extra-x86_64/pgbouncer.install 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1,26 @@ +post_install() { + if [ ! -d '/var/lib/postgres' ]; then + mkdir -p '/var/lib/postgres' + fi + if ! getent group postgres >/dev/null; then + groupadd -g 88 postgres + fi + if ! getent passwd postgres >/dev/null; then + useradd -c 'PostgreSQL user' -u 88 -g postgres -d '/var/lib/postgres' -s /bin/bash postgres + passwd -l postgres >/dev/null + fi + if ! getent group pgbouncer >/dev/null; then + groupadd -r pgbouncer + fi + if ! getent passwd pgbouncer >/dev/null; then + useradd -c 'PGBouncer user' -r -g pgbouncer -d '/etc/pgbouncer' -s /bin/bash pgbouncer + passwd -l pgbouncer >/dev/null + fi + chown pgbouncer:pgbouncer /var/log/pgbouncer + systemd-tmpfiles --create pgbouncer.conf + gpasswd -a pgbouncer postgres +} + +post_upgrade() { + post_install $1 +} Deleted: extra-x86_64/pgbouncer.logrotate =================================================================== --- extra-x86_64/pgbouncer.logrotate 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/pgbouncer.logrotate 2016-02-21 03:57:30 UTC (rev 260108) @@ -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 260107, pgbouncer/trunk/pgbouncer.logrotate) =================================================================== --- extra-x86_64/pgbouncer.logrotate (rev 0) +++ extra-x86_64/pgbouncer.logrotate 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-x86_64/pgbouncer.service =================================================================== --- extra-x86_64/pgbouncer.service 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/pgbouncer.service 2016-02-21 03:57:30 UTC (rev 260108) @@ -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 260107, pgbouncer/trunk/pgbouncer.service) =================================================================== --- extra-x86_64/pgbouncer.service (rev 0) +++ extra-x86_64/pgbouncer.service 2016-02-21 03:57:30 UTC (rev 260108) @@ -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: extra-x86_64/pgbouncer.tmpfiles.conf =================================================================== --- extra-x86_64/pgbouncer.tmpfiles.conf 2016-02-21 03:57:13 UTC (rev 260107) +++ extra-x86_64/pgbouncer.tmpfiles.conf 2016-02-21 03:57:30 UTC (rev 260108) @@ -1 +0,0 @@ -d /run/pgbouncer 0755 pgbouncer pgbouncer - Copied: pgbouncer/repos/extra-x86_64/pgbouncer.tmpfiles.conf (from rev 260107, pgbouncer/trunk/pgbouncer.tmpfiles.conf) =================================================================== --- extra-x86_64/pgbouncer.tmpfiles.conf (rev 0) +++ extra-x86_64/pgbouncer.tmpfiles.conf 2016-02-21 03:57:30 UTC (rev 260108) @@ -0,0 +1 @@ +d /run/pgbouncer 0755 pgbouncer pgbouncer -