How to restore "postgres" database?

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to restore "postgres" database?
Date: 2010-10-01 14:40:09
Message-ID: AANLkTim6fZgcgzUnPVW9zsV8j87NJwW2UBWDcczA97CS@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2010-10-01 14:46:08 Re: Analyze tool?
Previous Message Adrian Klaver 2010-10-01 14:26:36 Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition