[Pkg-postgresql-public] help with postgresql authentication for gnukhata

[Markus Frosch]

Hi Praveen,
> We are packaging gnukhata (http://gnukhata.org) for debian and would
> like your advice for authentication. The default installation of
> postgres uses trust authentication for local postgres user. Debian
> package is configured to use peer authentication for local postgres user.
> 
> I'm thinking of creating a gnukhata system user, which can connect to
> postgres using peer authentication.
> 
> I can use 'adduser --system' command to create a system user and then
> use 'createuser' command to create database user.
> 
> gnukhata service will be run as gnukhata user and it should use peer
> authentication method to connect. Is there a command line way of adding
> and removing from pg_hba.conf?
> 
> Also is there a better way of doing this setup?

There is a tool called dbconfig-common in Debian that allows you to
configure a database and its owner in post installation of a Debian
package. And also can install and update the database schema.

It is not the best tool imaginable, but works quite good.

Some Debian tools rely on it, just look for the packages that depend on
dbconfig-common.

Cheers
Markus

-- 
Markus Frosch
markus at lazyfrosch.de
http://www.lazyfrosch.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20140604/e46a86d2/attachment.sig>