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