From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Connection & logging Problems |
Date: | 2007-10-19 23:38:28 |
Message-ID: | E66B1CFE-4DC8-4B62-9529-0DA394C2D6E8@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have both 7.4 & 8.2 on this box.
Everything below is WRT v7.4
User postgres connects fine.
When I:
postgres(at)smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ psql -U
airburst airburst -p 5433
I get:
psql: FATAL: IDENT authentication failed for user "airburst"
REFERRING TO /etc/postgresql/7.4/main
My pg_hba.conf has:
# IPv4-style local connections:
host all all 127.0.0.1
255.255.255.255 trust # RNS added
My postgresql.conf has:
syslog = 2 # 0 # range 0-2; 0=stdout; 1=both;
2=syslog
client_min_messages = debug1
log_min_messages = debug1
log_min_error_statement = error
YET I'm getting NO logging in either /var/log/syslog nor in /var/log/
postgresql/postgresql-7.4-main.log
WHY?
Why no logging
and Why unable to connect?
Ralph Smith
smithrn(at)u(dot)washington(dot)edu
=====================
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Trutwin | 2007-10-20 00:11:31 | Re: Questions about LIMIT/OFFSET |
Previous Message | Michael Glaesemann | 2007-10-19 23:19:55 | Re: Questions about LIMIT/OFFSET |