| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, bricklen <bricklen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore |
| Date: | 2010-12-25 04:52:56 |
| Message-ID: | AANLkTimZ7dNaXsd3SntxFo2zf45q-MyP6ZUST62FV9jd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 24, 2010 at 9:38 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> I attempted loading earlier version of my backup database, using PDW# \I
> PDW_May_2010 and it worked.
>
> Looks as tho the June version may have been corrupt.
If it's a plain sql text file you can read it with a simple app like
the notepad or whatever editor comes with windows. If it's not plain
sql, but was created with pg_dump with switches to make it a custom
compressed format then you'll need to use pg_restore to restore the
file. I generally store plain text sql files as .sql and compressed
dumps as .dmp so I can tell them apart by their names.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2010-12-25 12:03:45 | Re: Restore |
| Previous Message | Bob Pawley | 2010-12-25 04:38:45 | Re: Restore |