| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Malm Paul <paul(dot)malm(at)saabgroup(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: restore a server backup |
| Date: | 2011-03-01 10:51:07 |
| Message-ID: | 4D6CCF9B.3080800@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 01/03/2011 06:37, Malm Paul wrote:
> Hi, I've used PgAdmin III to store a server backup. But I'm not able to
> restore it.
> Please, could any one tell me how to do it? Im using version 1.10
Hi there,
Did you create a text or binary backup?
If binary, you either (i) use pg_restore on the command line, or (ii)
use pgAdmin's "restore" option from the menu you get when right-clicking
on the tree view (which just uses pg_restore anyway).
If you created a text backup, you'll need to feed it to psql on the
command line:
psql -f <backup-file.sql> <database-name>
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mahdi Mankai | 2011-03-01 11:08:17 | Re: Issues with imported blobs from Postgres 8 to 9 |
| Previous Message | Adarsh Sharma | 2011-03-01 10:27:27 | Tool for shifting tables from Mysql to Postgresql |