summarylogtreecommitdiffstats
diff options
context:
space:
mode:
authorThomas Jost2017-06-01 10:26:08 +0200
committerThomas Jost2017-06-01 10:26:08 +0200
commit518dc18df8eab5e0bc8d298831d77c8b1f28e77e (patch)
tree8db7e900726980fccf052db91cac63498f27d0be
parente6c37758072fc61d31e25e0229b722f814136b51 (diff)
downloadaur-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--.SRCINFO32
-rw-r--r--PKGBUILD27
-rw-r--r--bookmark.toml.sample12
-rw-r--r--pgweb.env1
-rw-r--r--pgweb.install3
-rw-r--r--pgweb.service17
6 files changed, 78 insertions, 14 deletions
diff --git a/.SRCINFO b/.SRCINFO
index 53c1c1522f2d..3615a6f1dbfe 100644
--- a/.SRCINFO
+++ b/.SRCINFO
@@ -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
diff --git a/PKGBUILD b/PKGBUILD
index 287d38611776..2720ad8b9b9d 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -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