Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore Backup from Linux to Windows 2003 - Mailing list pgsql-admin

From Vladimir Rusinov
Subject Re: Restore Backup from Linux to Windows 2003
Date
Msg-id AANLkTikORbc_xGiYYftiii7UcRYAikx2D02JbeKR+Q-k@mail.gmail.com
Whole thread Raw
In response to Restore Backup from Linux to Windows 2003  (Anal Dey <anal.dey@gmail.com>)
List pgsql-admin
Tree view


On Thu, Mar 31, 2011 at 3:37 PM, Anal Dey <anal.dey@gmail.com> 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/

pgsql-admin by date:

Previous
From: scorpdaddy@hotmail.com
Date:
Subject: Re: [ADMIN] Index size growing
Next
From: Jerry Sievers
Date:
Subject: Re: Index size growing