diff options
author | Thomas Jost | 2017-06-01 10:26:08 +0200 |
---|---|---|
committer | Thomas Jost | 2017-06-01 10:26:08 +0200 |
commit | 518dc18df8eab5e0bc8d298831d77c8b1f28e77e (patch) | |
tree | 8db7e900726980fccf052db91cac63498f27d0be | |
parent | e6c37758072fc61d31e25e0229b722f814136b51 (diff) | |
download | aur-518dc18df8eab5e0bc8d298831d77c8b1f28e77e.tar.gz |
Version bump: 0.9.7, + other nice things
- Add systemd service + env file based on the pgweb-git package
- Add a sample bookmarks file (based on the wiki page:
https://github.com/sosedoff/pgweb/wiki/Server-Connection-Bookmarks)
-rw-r--r-- | .SRCINFO | 32 | ||||
-rw-r--r-- | PKGBUILD | 27 | ||||
-rw-r--r-- | bookmark.toml.sample | 12 | ||||
-rw-r--r-- | pgweb.env | 1 | ||||
-rw-r--r-- | pgweb.install | 3 | ||||
-rw-r--r-- | pgweb.service | 17 |
6 files changed, 78 insertions, 14 deletions
@@ -1,21 +1,35 @@ # Generated by mksrcinfo v8 -# Sun Dec 4 20:12:51 UTC 2016 +# Thu Jun 1 08:25:47 UTC 2017 pkgbase = pgweb-bin pkgdesc = Web-based PostgreSQL database browser written in Go - pkgver = 0.9.6 + pkgver = 0.9.7 pkgrel = 1 url = https://github.com/sosedoff/pgweb + install = pgweb.install arch = i686 arch = x86_64 license = MIT - provides = pgweb=0.9.6 + provides = pgweb=0.9.7 conflicts = pgweb - source_i686 = bin_0.9.6_386.zip::https://github.com/sosedoff/pgweb/releases/download/v0.9.6/pgweb_linux_386.zip - md5sums_i686 = fa7769fecf3d6bfead547d37a14d2031 - sha256sums_i686 = a5353a1af12f32509184a471cedbdbe872dd6f1ce9ca617df5a9623f268ea1f2 - source_x86_64 = bin_0.9.6_amd64.zip::https://github.com/sosedoff/pgweb/releases/download/v0.9.6/pgweb_linux_amd64.zip - md5sums_x86_64 = 27da15513fd288f313fd56ffba8df2e9 - sha256sums_x86_64 = 550fb4bc628b51891a5fd5cfd48221999154343d0c2a9a4182b4151ff8464fe6 + backup = etc/conf.d/pgweb + source = pgweb.install + source = pgweb.env + source = pgweb.service + source = bookmark.toml.sample + md5sums = d45bd1fdcac2311fffa9534b430a3ee8 + md5sums = d89944e4c4d325569f94eb56dfbe6411 + md5sums = 1362f2c1ba241a56b4c2c98bdfa2eca7 + md5sums = 2146194a1a81d4d9f1172d1ea64e0fd0 + sha256sums = cc041317281beafc22ad7dd47f3f3ae3ca5006a3f873996bc611124fc3d439d0 + sha256sums = aa58ad72a5ea730b4c2ae292e02608d3df2b882c173520737fa4afb0faa89f29 + sha256sums = b0f6b6099c2936e0dc11918799c2043831c0e4249d4dd15e77adc2d418e971a6 + sha256sums = 5eae680e816a8124f0b227da33bf90637730a5ef2b32267b89344369f866c609 + source_i686 = bin_0.9.7_386.zip::https://github.com/sosedoff/pgweb/releases/download/v0.9.7/pgweb_linux_386.zip + md5sums_i686 = 75caa2819c88792283d730d8f09ae52e + sha256sums_i686 = 3fac0c6ee09a39d9ffdbbd85fc435e108c89eef3246b0bb578431c8b6f47e7c2 + source_x86_64 = bin_0.9.7_amd64.zip::https://github.com/sosedoff/pgweb/releases/download/v0.9.7/pgweb_linux_amd64.zip + md5sums_x86_64 = 06ed50196b0f4fdcadaeda9ec91348ed + sha256sums_x86_64 = 45b2a7df601c016ba5b0b5fce4e807b939c876899bb475bbb2e14cc8cc1bdb1b pkgname = pgweb-bin @@ -1,6 +1,6 @@ # Maintainer: Thomas Jost <schnouki@schnouki.net> pkgname=pgweb-bin -pkgver=0.9.6 +pkgver=0.9.7 pkgrel=1 pkgdesc="Web-based PostgreSQL database browser written in Go" arch=('i686' 'x86_64') @@ -8,14 +8,31 @@ url="https://github.com/sosedoff/pgweb" license=('MIT') provides=("pgweb=${pkgver}") conflicts=("pgweb") +source=('pgweb.install' 'pgweb.env' 'pgweb.service' 'bookmark.toml.sample') source_i686=("bin_${pkgver}_386.zip::https://github.com/sosedoff/pgweb/releases/download/v${pkgver}/pgweb_linux_386.zip") source_x86_64=("bin_${pkgver}_amd64.zip::https://github.com/sosedoff/pgweb/releases/download/v${pkgver}/pgweb_linux_amd64.zip") -md5sums_i686=('fa7769fecf3d6bfead547d37a14d2031') -md5sums_x86_64=('27da15513fd288f313fd56ffba8df2e9') -sha256sums_i686=('a5353a1af12f32509184a471cedbdbe872dd6f1ce9ca617df5a9623f268ea1f2') -sha256sums_x86_64=('550fb4bc628b51891a5fd5cfd48221999154343d0c2a9a4182b4151ff8464fe6') +md5sums=('d45bd1fdcac2311fffa9534b430a3ee8' + 'd89944e4c4d325569f94eb56dfbe6411' + '1362f2c1ba241a56b4c2c98bdfa2eca7' + '2146194a1a81d4d9f1172d1ea64e0fd0') +md5sums_i686=('75caa2819c88792283d730d8f09ae52e') +md5sums_x86_64=('06ed50196b0f4fdcadaeda9ec91348ed') +sha256sums=('cc041317281beafc22ad7dd47f3f3ae3ca5006a3f873996bc611124fc3d439d0' + 'aa58ad72a5ea730b4c2ae292e02608d3df2b882c173520737fa4afb0faa89f29' + 'b0f6b6099c2936e0dc11918799c2043831c0e4249d4dd15e77adc2d418e971a6' + '5eae680e816a8124f0b227da33bf90637730a5ef2b32267b89344369f866c609') +sha256sums_i686=('3fac0c6ee09a39d9ffdbbd85fc435e108c89eef3246b0bb578431c8b6f47e7c2') +sha256sums_x86_64=('45b2a7df601c016ba5b0b5fce4e807b939c876899bb475bbb2e14cc8cc1bdb1b') +backup=('etc/conf.d/pgweb') +install='pgweb.install' package() { cd "$srcdir" + install -Dm644 pgweb.env "$pkgdir"/etc/conf.d/pgweb + install -Dm644 pgweb.service "$pkgdir"/usr/lib/systemd/system/pgweb.service + + install -dm700 "$pkgdir"/etc/pgweb + install -Dm644 bookmark.toml.sample "$pkgdir"/etc/pgweb/bookmark.toml.sample + install -Dm755 pgweb_linux_* "$pkgdir"/usr/bin/pgweb } diff --git a/bookmark.toml.sample b/bookmark.toml.sample new file mode 100644 index 000000000000..8e4bea452cd3 --- /dev/null +++ b/bookmark.toml.sample @@ -0,0 +1,12 @@ +# Bookmarks allow you to keep connection settings to your most frequent servers +# with credentials stored in a file on your local filesystem, encoded as TOML. + +# Here's an example of a bookmark file (/etc/pgweb/server.toml): +host = "localhost" +port = 5432 +user = "postgres" +database = "mydatabase" +ssl = "disable" + +# To keep things short, you can just define an url: +url = "postgres://user:password@host:port/database?sslmode=mode" diff --git a/pgweb.env b/pgweb.env new file mode 100644 index 000000000000..846515969c63 --- /dev/null +++ b/pgweb.env @@ -0,0 +1 @@ +PGWEB_OPTIONS='--skip-open --bookmarks-dir=/etc/pgweb' diff --git a/pgweb.install b/pgweb.install new file mode 100644 index 000000000000..8a6b276c792e --- /dev/null +++ b/pgweb.install @@ -0,0 +1,3 @@ +post_install() { + echo '>>' Edit required options in /etc/conf.d/pgweb and start service with "systemctl enable --now pgweb" +} diff --git a/pgweb.service b/pgweb.service new file mode 100644 index 000000000000..19fb240398fc --- /dev/null +++ b/pgweb.service @@ -0,0 +1,17 @@ +[Unit] +Description=Web client (GUI) for PostgreSQL databases +After=syslog.target network.target + +[Service] +Type=simple +EnvironmentFile=/etc/conf.d/pgweb +ExecStart=/usr/bin/pgweb $PGWEB_OPTIONS +CapabilityBoundingSet=CAP_NET_BIND_SERVICE +NoNewPrivilegies=true +PrivateTmp=true +PrivateDevices=true +ProtectHome=true +ReadOnlyPaths=/ + +[Install] +WantedBy=multi-user.target |