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
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.