From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Subject: | Re: ERROR: Could not access status of transaction #### |
Date: | 2007-10-19 22:25:04 |
Message-ID: | C58DE570-BA4B-447F-9D3F-40B939CB5649@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 10/19/07, Ralph Smith <smithrn(at)u(dot)washington(dot)edu> wrote:
>> Thank you Scott!
>>
>> I'm away from my desk and will dive back into it.
>> Fortunately I have two machines, each w/ 7.4 & 8.2 on them. New
>> installs on Ubuntu 7.4.
>>
>> As to why I had 'no role or database' errors yesterday, am I right
>> that it was either:
>> A) I accidentally did a pg_dump when I thought I'd done a
>> pg_dumpall, or
>> B) Using the text file output of pg_dumpall behaves differently on
>> import than the -Fc format?
>> I'd imported it w/ psql, since it was a text file.
==========================================
> On Oct 19, 2007, at 2:06 PM, Scott Marlowe wrote:
> Most likely the first. Without a pg_dumpall you don't get the
> accounts. Note that you can do just a pg_dumpalll -g to get the
> "global" data, which includes the accounts.
----------------------------------------------------------
I'm making progess, but SLOOOOOWLY...
I now have a new db postgres, and now my targed db airburst
I have both 7.4 & 8.2 on this box.
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?
User postgres connects fine.
One more thanks!
Ralph Smith
smithrn(at)u(dot)washington(dot)edu
=====================
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-10-19 22:43:26 | PostgreSQL Conference Fall 07 -- Registration Closed |
Previous Message | Valerie Cole | 2007-10-19 22:03:35 | Question regarding Hibernate ORDER BY issue |