Re: How to restore "postgres" database? - Mailing list pgsql-general

From Craig Ringer
Subject Re: How to restore "postgres" database?
Date
Msg-id 4CA5F9A3.8050100@postnewspapers.com.au
Whole thread Raw
In response to How to restore "postgres" database?  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Copying a column into a temp. table
Next
From: Alexander Farber
Date:
Subject: Re: Copying a column into a temp. table