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.
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? |