Re: starting postgresql with pgsql password - workarounds?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Duane Winner <dwinner-lists(at)att(dot)net>, duanewinner(at)att(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: starting postgresql with pgsql password - workarounds?
Date: 2005-05-20 19:46:51
Message-ID: 27947.1116618411@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> # set defaults
>> postgresql_enable=${postgresql_enable:-"NO"}
>> postgresql_flags=${postgresql_flags:-"-w -s -m fast"}

Try it without the "-w" ... that's probably causing it to try to connect
with psql.

Alternatively, set up a ~/.pgpass file for the postgres user (which
might be a reasonable thing anyway).

BTW, this script seems fairly brain-dead in assuming that the same
option flags should apply to all pg_ctl commands.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mario Soto Cordones 2005-05-20 20:18:23 Re: materialized view
Previous Message Franco Bruno Borghesi 2005-05-20 19:24:03 Re: starting postgresql with pgsql password - workarounds?