Re: ERROR: Could not access status of transaction #### - Mailing list pgsql-general

From Scott Marlowe
Subject Re: ERROR: Could not access status of transaction ####
Date
Msg-id dcc563d10710191406y5872706co814c2a1143868310@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: Could not access status of transaction ####  (Ralph Smith <smithrn@u.washington.edu>)
Responses Re: ERROR: Could not access status of transaction ####  (Ralph Smith <smithrn@u.washington.edu>)
List pgsql-general
On 10/19/07, Ralph Smith <smithrn@u.washington.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.

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.

pgsql-general by date:

Previous
From: Josh Trutwin
Date:
Subject: Questions about LIMIT/OFFSET
Next
From: Gregory Stark
Date:
Subject: Re: Order-independent multi-field uniqueness constraint?