Re: restore postgres system database 8.1.11 - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: restore postgres system database 8.1.11
Date
Msg-id 481FCE92.7090309@commandprompt.com
Whole thread Raw
In response to restore postgres system database 8.1.11  ("Patrick Roberts" <Patrick.Roberts@lonelyplanet.com.au>)
List pgsql-admin
Patrick Roberts wrote:
> Hi All,
>
>    On a newly created server I stupidly restored over the top of the
> postgres system database using the GUI...(postgresql n00b) and am
> wondering a couple of things.
>
>    Firstly, if this database is overwritten, is it detrimental to the
> running of PostgreSQL?

The "postgres" database is basically an empty holder so that when you do
this:

psql

as the user postgres, you actually get into the system.
>
>    Secondly is it just a simple matter of restoring it using a backup
> from a different PostgreSQL instance installed elsewhere.

If you are indeed speaking about the "postgres" database yes.

Sincerely,

Joshua D. Drake

pgsql-admin by date:

Previous
From: "Patrick Roberts"
Date:
Subject: Re: restore postgres system database 8.1.11
Next
From: "arpit jain"
Date:
Subject: Postgresql Service Failed Error