Important stuff: Fedora Core 2, postgresql-7.4.7-3.FC2.1 Also, I know *nothing* about PostGreSQL, SQL, or databases in general :-) I installed the RPMs and the service starts and runs. I added a user and gave it a password, and gave the psql user "postgres" a different password. But I can log on with neither. No, I didn't forget the passwords :-) Searching for this sort of problem leads to a lot of the same thing, and a lot of different responses about how the pg_hba.conf should read. I've tried a huge number of variations, restarting the service between each iteration. Normally, stuff like this is less painful with logs. But I can find no working log file for psql. In /etc/init.d/postgresql, I found a line PGLOG=/dev/null amd replaced it with PGLOG=/var/log/psqllog /var/log/psqllog was created but is 0 length after restarting the service and a few failed login attempts. Assuming there's no "This is the exact reason why your logins don't work" answer, how do I get logging working so as to at least have another clue? -- *********************************************************************** * John Oliver http://www.john-oliver.net/ * * * ***********************************************************************
