Postgresql allow connections without password

From: debian nick <debianick(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql allow connections without password
Date: 2012-01-12 05:16:04
Message-ID: CAGy1pdEEoUq3DXg0NWRN77-fYLOq0zKQfktKpmbu5k_H5Liy+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-01-12 05:45:06 Re: Compiling C function with VC++ for Windows version
Previous Message Andy Colson 2012-01-12 03:20:04 Re: How to return latest results without a polygon intersect?