From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | debian nick <debianick(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql allow connections without password |
Date: | 2012-01-13 10:52:04 |
Message-ID: | 4F100CD4.5080608@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/01/2012 05:16, debian nick wrote:
> I have postgresql 8.4.9 installed now, my problem is that from time to
> time my postgresql let psql version 8.4.9 access the database without
> asking for password (psql -d mydatabase -h myhost -U myuser), and the
> connection attempts from psql 8.3 are not allowed no matter what i got
> time out exceptions from psql 8.3.
> The first time that happen to my i have installed postgresql 8.3, so i
> think that because i upgrade my system and not postgres (i upgrade from
> debian lenny (5) to squeeze (6)) that was the problem, so i installed
> 8.4.9 and with pg_dumpall i restore all my databases. And the problem
> was solved. Postgresql ask for passwords no matter from where i try to
> connect.
> And now a month later i have the same problem with 8.4.9. After various
> restart, stop and start the problem disappear, and 3 hours later it came
> back.
Do you have pgAdmin on the same (client) machine? pgAdmin stores
passwords in the .pgpass file (though it asks you first, and also warns
about clear-text password) which could possibly explain this
intermittent behaviour.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | bj77 | 2012-01-13 12:00:46 | ORAFCE -> UTL_FILE -> pul_line |
Previous Message | Yan Chunlu | 2012-01-13 08:33:08 | Re: select statment going slow and slow while using IN (xx,xx) |