Tena Sakai <tsa...@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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
