Problems logging in

From: John Oliver <joliver(at)john-oliver(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems logging in
Date: 2006-04-22 23:57:16
Message-ID: 20060422235716.GA16673@ns.sdsitehosting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/ *
* *
***********************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-04-23 00:53:52 Re: Performance
Previous Message Bert 2006-04-22 23:18:32 Performance