On 10/19/07, Ralph Smith <smithrn@xxxxxxxxxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
