Skip site navigation (1) Skip section navigation (2)

Re: How to move a DB from one server to another...

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <flame(at)etheye(dot)com>
Cc: <haraldarminmassa(at)gmail(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: How to move a DB from one server to another...
Date: 2005-06-23 11:47:18
Message-ID: 1506.24.211.165.134.1119527238.squirrel@www.dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
First, your mailer's habit of putting "R:" instead of the standard "Re:" at
the front of replies is annoying. You need to fix it.

Second, of course pg_restore works on Windows. The most common mistakes in
using pg_dump/pg_restore (on all platforms) are:
. not using pg_dump from the target version, and
. trying to use pg_restore rather than psql to restore a text format dump.

I suggest you try using pg_dump -F c on your Windows machine to dump the
remote db and then try pg_restore on the result to load your copy. If that
gives you trouble then tell us *precisely* what the trouble is.

cheers

andrew




Etheye said:
> Hello Harald,
>
> uhm, you may have lost my first message... I said that I am unable to
> run pg_restore on a different computer other than the one pg_dump was
> used on. I always get a return code of 1 (error). I can easily and
> quickly dump a database with pg_dump but I can't restore it on a PC
> different from the one used to back it up. And I really can't
> understand why, I have tried all possible options...
>
> I'm running PostgreSQL 8.0.3 on Win32. I've found some solutions for
> Linux but nobody was able to help me regarding the Windows platform.
>
> Thanks,
>
> Federico
>
>
>
>  _____
>
> Da: Harald Armin Massa [mailto:haraldarminmassa(at)gmail(dot)com]
> Inviato: gioved├Č 23 giugno 2005 12.14
> A: Federico Simonetti (Etheye)
> Cc: pgsql-hackers-win32(at)postgresql(dot)org
> Oggetto: Re: R: [pgsql-hackers-win32] How to move a DB from one server
> to another...
>
>
> Federico,
>
>
> Of course we could use SQL (CREATE DATABASE, CREATE TABLE, INSERT
> INTO....) but this would take years on large databases, while a rough
> "copy this  folder to the new server" would take just a few seconds.
>
>
>
> I do copys of databases every other day. pg_dump and pg_restore work
> like a breeze on databases with around 1 gig of stuff, and I do not
> even use the binary format and use intermediate files.
>
> Where ist the performance bottleneck you are speaking of?
>
> Harald
>
> --
> GHUM Harald Massa
> persuasion python postgresql
> Harald Armin Massa
> Reinsburgstra├če 202b
> 70197 Stuttgart
> 0173/9409607




In response to

pgsql-hackers-win32 by date

Next:From: Federico Simonetti (Etheye)Date: 2005-06-23 11:53:39
Subject: R: R: How to move a DB from one server to another...
Previous:From: Harald Armin MassaDate: 2005-06-23 10:13:41
Subject: Re: R: How to move a DB from one server to another...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group