Re: Restore Backup from Linux to Windows 2003

[Vladimir Rusinov <vladimir@xxxxxxxxxxxxxx>]

On Thu, Mar 31, 2011 at 3:37 PM, Anal Dey <anal.dey@xxxxxxxxx> wrote:

I need a help on restoring backup which was taken under a linux machine with

Âthe below command

Â

pg_dump mydb > /myhome/backup/mydb_backup.pgdump

now I want to restore the backup (my_db_backup.pgdume) file under my windows

machine can any oneÂkindly explain me the process to restore this.

Mostly the same as under *nix:

pg_restore.exe C:\path\to\mydb_backup.pgdumpÂ-U <user> -d <database>

Â

I thank you in advance for providing your valuable time for describing me the method.

-- 
Vladimir Rusinov
http://greenmice.info/