Re: restore postgres system database 8.1.11

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