Tena Sakai <tsakai@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
