Re: ERROR: Could not access status of transaction ####

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.

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.