| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Patrick Roberts <Patrick(dot)Roberts(at)lonelyplanet(dot)com(dot)au> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: restore postgres system database 8.1.11 |
| Date: | 2008-05-06 03:20:50 |
| Message-ID: | 481FCE92.7090309@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | arpit jain | 2008-05-06 07:26:11 | Postgresql Service Failed Error |
| Previous Message | Patrick Roberts | 2008-05-06 03:15:58 | Re: restore postgres system database 8.1.11 |