Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to restore "postgres" database?

How to restore "postgres" database?

From
Alexander Farber
Date:
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? I currently have:

postgres=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 phpbb      | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(4 rows)

It is difficult to find the solution on the web (bad keywords)

Regards
Alex

Re: How to restore "postgres" database?

From
Craig Ringer
Date:
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