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

From: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Failed to restore/recreate database (one more piece of info)
Date: 2009-11-16 17:26:32
Message-ID: C726CB48.8BA3%tsakai@gallo.ucsf.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I mentioned in the previous posting that the file 20091114.6.gz
was made by:
pg_dumpall | gzip > 20091114.6.gz

At which point, there was only one databasae (named canon) and
no database named musket existed.

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?

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

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-11-16 18:42:21 Re: Failed to restore/recreate database (one more piece of info)
Previous Message Tena Sakai 2009-11-16 17:10:40 Failed to restore/recreate database