Re: Failed to restore/recreate database (one more piece of info)

Tena Sakai <tsakai@gallo.ucsf.edu> writes:
> Now that I am thinking, maybe the file made by pg_dumpall has
> "canon" encoded and therefore what I did logically did not copy
> any canon tables into musket?  Could this be the case?

Yup, exactly.  It would have created canon and restored into that.

> If so, how would I duplicate an existing database and call it
> with a different name?

Use pg_dump not pg_dumpall.

            regards, tom lane