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