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@iol.ie