Re: restore a server backup

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