| 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: | Whole Thread | Raw Message | 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? |