Обсуждение: Postgresql allow connections without password

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.
I don't know what to do.
In my logs the only strange thing i startup package incomplete after i start the server. I google it but nothing seems to explain it, and i don't have any cron.

Now im going to install postgresql 9 to see if the problem disappear.

Any help will be really appreciate.

On Thursday, January 12, 2012 02:16:04 AM debian nick wrote:
> Any help will be really appreciate.

Check your pg_hba.conf file for any entries with "trust" or "ident". Remove
them and restart the server.

Also look for .pgpass files in the home directories of any user seeing this.

On Wednesday, January 11, 2012 9:16:04 pm 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.
> I don't know what to do.
> In my logs the only strange thing i startup package incomplete after i
> start the server. I google it but nothing seems to explain it, and i don't
> have any cron.
>
> Now im going to install postgresql 9 to see if the problem disappear.

Well before you do that, take a look at your pg_hba.conf file. See if you have
any lines where the METHOD is 'trust'.  This allows a client to connect to
Postgres without a password. My guess is you have some connections that are
matching a 'trust' rule.

>
> Any help will be really appreciate.

--
Adrian Klaver
adrian.klaver@gmail.com

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@iol.ie