Re: .pgpass

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: .pgpass
Date: 2004-07-01 17:38:06
Message-ID: 28870.1088703486@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca> writes:
> the message from cron indicates that home is /var/lib/postgres
> and the user is postgres when the script runs.

> X-Cron-Env: <SHELL=/bin/sh>
> X-Cron-Env: <HOME=/var/lib/postgres>
> X-Cron-Env: <PATH=/usr/bin:/bin>
> X-Cron-Env: <LOGNAME=postgres>

Hm. Given that you seem to have eliminated other possibilities,
I guess I'd question that message. Have you tried putting something
like "env > logfile" into the cron script to directly verify what
environment it gets?

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2004-07-01 17:47:44 fronted-backend protocol request, + "select for edit" request
Previous Message Tom Lane 2004-07-01 17:34:41 Re: concurrent cursors possible with portals?