On Sat, 2002-01-19 at 23:33, Martin Saturka wrote:
> 26894 26735 26716 ttyp1 00:00:00 psql
> 26894 26735 26716 ttyp1 S 0:00 /usr/lib/postgresql/bin/psql -q -t
> -c select count(*) from pg_language where lanname='plpgsql' -d bk
> -----
> -----
>
> bk is from pg_hba.conf:
> local bk password bk
> host bk 127.0.0.1 255.0.0.0 password bk
>
> Thus, I just removed these two lines, but it stops on the same, but
> "bkwww" (well, it is in pg_hba.conf, it was there before bk remove too)
>
> apropos, now (during new install, after bk remove), it writes (it is the
> last message before the hang):
>
> plpgsql is already enabled in bk
It must be waiting for you to type in the postgres user's password.
While the postinst is running, pg_hba.conf is supposed to be temporarily
replaced so as to avoid any such problems:
(
# this is in a sub-shell to limit the effect of the cd
cd /etc/postgresql
cp pg_hba.conf $PG_HBA_TEMP
echo "local all trust" >pg_hba.conf
)
# make sure the file is restored when the script exits
trapcmd=`trap -p 0`
[ -n "$trapcmd" ] && trapcmd="$trapcmd; "
trapcmd="${trapcmd}cp $PG_HBA_TEMP /etc/postgresql/pg_hba.conf; rm
$PG_HBA_TEMP"
trap "$trapcmd" 0
Was there anything in the output that you snipped to indicate that this
failed?
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"The LORD is my strength and song, and he is become my
salvation; he is my God, and I will prepare him an
habitation; my father's God, and I will exalt him."
Exodus 15:2
Attachment:
signature.asc
Description: This is a digitally signed message part