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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
