Re: [Gnumed-devel] Problems calling or obtaining passwords from .pgpass

[Karsten Hilbert]

On Fri, Nov 22, 2013 at 09:09:37AM +0100, Hilbert, Sebastian wrote:

> Karsten seems to have a setup with very little user interaction. He might 
> want 
> to spell out details (for Debian) with regards to pgpass, sudo or su root, 
> conf files edited or not (uncommented lines).

My regular user .pgpass contains

        *:5432:*:gm-dbo:<password>

I run the bootstrapper from an unmodified copy of the git tree like this:

        sudo ./upgrade-db.sh 18 19

which prompts me for my regular user pasword once.

My root .pgpass reads

        localhost:5432:*:gm-dbo:<password>

My postgres regular system account does not have a .pgpass
but postgres can connect via IDENT (in pg_hba.conf).

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346