On 10/01/2010 10:40 PM, Alexander Farber wrote:
Ouch! I've loaded my backup while being connected to the wrong database - to the dafeult "postgres" database. Is there a way to restore it?
Sure. Just drop it and re-create it. The "postgres" database is just a convenience, and is typically empty.
You'll need to connect to the template1 database; you can't drop the postgres database while you're connected to it.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
