[Pkg-postgresql-public] Bug#891687: postgresql-common: dsfwew

2018-03-16 Thread Daniel Kahn Gillmor
Hi Christoph-- On Fri 2018-03-02 14:00:52 +0100, Christoph Berg wrote: > this is very interesting, especially Type=notify. thanks for taking a look! > my first question would be if we could integrate the idea more tightly > with the existing postgresql@ services which are already capable of > la

[Pkg-postgresql-public] Bug#891687: postgresql-common: provide easy way to spin up a systemd user service cluster

2018-03-02 Thread Daniel Kahn Gillmor
The previous patch had a small error in it ("psql" in one instance where i'd otherwise settled on "postgres"). I'm attaching a revised patch that doesn't have that problem. --dkg >From d88b1d641066aa9299beba5e84c47d22ded5337e Mon Sep 17 00:00:00 200

[Pkg-postgresql-public] Bug#891687: another alternative approach

2018-02-27 Thread Daniel Kahn Gillmor
the approach in the attached patch offers a different user-owned cluster *per instantiated template*. This keeps the data for each invoked database localized, within that named directory in ~/.config/foo. Another approach would be to have a single /usr/lib/systemd/user/postgresql.service that run

[Pkg-postgresql-public] Bug#891687: postgresql-common: dsfwew

2018-02-27 Thread Daniel Kahn Gillmor
e mode 100755 index 000..f89666e --- /dev/null +++ b/postgres-user-cluster @@ -0,0 +1,59 @@ +#!/bin/bash + +# Author: Daniel Kahn Gillmor +# Date: 2018-02-27 + +# /usr/share/postgresql-common/postgres-user-cluster DBNAME DBPATH SOCKETDIR + +# Launch a private postgresql cluster (setting it up

[Pkg-postgresql-public] Bug#876669: postgresql: cannot make standard postgresql clusters log to stderr or syslog

2017-09-24 Thread Daniel Kahn Gillmor
Package: postgresql Version: 9.6+184 Severity: normal I'm running postgresql 9.6 in a minimal virtual machine (with systemd as pid 1), where nothing else is writing to /var/log (with the exception of systemd-journald, when configured for non-ephemeral logging). however, the postgresql 9.6-main cl

Re: [Pkg-postgresql-public] how to get a local/minimal per-user postgresql server on debian?

2016-11-11 Thread Daniel Kahn Gillmor
Hi Christoph-- On Fri 2016-11-11 17:48:53 +0900, Christoph Berg wrote: > PG is not going to be an embedded database, so there will never be > something like a libpostgresql that you could link to and have the DB > "inside" your program. It will always be a (set of) separate > processes. Which mean

[Pkg-postgresql-public] how to get a local/minimal per-user postgresql server on debian?

2016-11-10 Thread Daniel Kahn Gillmor
Hi Debian PostgreSQL folks-- Thre are some circumstances where i'd like to have the postgresql binaries available without necessarily needing the system services installed and started. For example, i have a set of intermittent short-lived processes that need to share long-lived state. The state

Re: [Pkg-postgresql-public] problems with postgresql and systemd after upgrade.

2016-06-13 Thread Daniel Kahn Gillmor
On Fri 2016-06-10 20:29:55 -0400, peter green wrote: > About a week ago I upgraded a server from wheezy to jessie. After the OS > upgrade I upgraded from postgresql 9.1 to 9.4 using pg_updatecluster. It > took a couple of attempts with pg_updatecluster to get things right > (mainly because I was

Re: [Pkg-postgresql-public] systemd support

2014-03-05 Thread Daniel Kahn Gillmor
On 03/05/2014 09:50 AM, Christoph Berg wrote: > Re: Daniel Kahn Gillmor 2014-03-04 <531641aa.7040...@fifthhorseman.net> >> have you looked at all into the idea of a socket-activated postgresql >> for those initsystems that can handle socket activation? > > I think i

Re: [Pkg-postgresql-public] systemd support

2014-03-04 Thread Daniel Kahn Gillmor
On 03/04/2014 06:49 PM, Stephen Frost wrote: > * Christoph Berg (m...@debian.org) wrote: >> I've written systemd unit files for managing PostgreSQL clusters. > > Neat stuff! seconded! >> To work, you also need the pg_ctlcluster version from HEAD. >> pg_ctlcluster now invokes postgres directly s