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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin