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