Re: Restore Backup from Linux to Windows 2003

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/

In response to

Browse pgsql-admin by date

  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