From: Joshua D. Drake <jd@commandprompt.com>
To: Patrick Roberts <Patrick.Roberts@lonelyplanet.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: restore postgres system database 8.1.11
Date: Mon, 05 May 2008 20:20:50 -0700
Message-ID: <481FCE92.7090309@commandprompt.com> (raw)
In-Reply-To: <317D66738A25D74A88E3E9B7C1814A3603978A0F@Garuda.lpint.net>
References: <4544e0330804282205odfcac5al6bca78bd27c8751b@mail.gmail.com>
<25410.1209448864@sss.pgh.pa.us>
<a44f084b0805010122i34de356aneebc3698917b74f0@mail.gmail.com>
<481AD7F1.3030708@fastmail.net>
<317D66738A25D74A88E3E9B7C1814A3603978A0F@Garuda.lpint.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, Patrick.Roberts@lonelyplanet.com.au
Subject: Re: restore postgres system database 8.1.11
In-Reply-To: <481FCE92.7090309@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox