From: | Vladimir Rusinov <vladimir(at)greenmice(dot)info> |
---|---|
To: | Anal Dey <anal(dot)dey(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Restore Backup from Linux to Windows 2003 |
Date: | 2011-04-01 10:02:11 |
Message-ID: | AANLkTikORbc_xGiYYftiii7UcRYAikx2D02JbeKR+Q-k@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Mar 31, 2011 at 3:37 PM, Anal Dey <anal(dot)dey(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | scorpdaddy | 2011-04-01 10:06:39 | Re: [ADMIN] Index size growing |
Previous Message | Selva manickaraja | 2011-04-01 07:33:56 | Re: What directories to include in base backup |