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
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.
Da: Harald Armin Massa [mailto:haraldarminmassa(at)gmail(dot)com]
Inviato: giovedì 23 giugno 2005 12.14
A: Federico Simonetti (Etheye)
Oggetto: Re: R: [pgsql-hackers-win32] How to move a DB from one server to
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?
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
In response to
pgsql-hackers-win32 by date
|Next:||From: Jochem van Dieten||Date: 2005-06-23 12:24:59|
|Subject: Re: R: R: How to move a DB from one server|
|Previous:||From: Andrew Dunstan||Date: 2005-06-23 11:47:18|
|Subject: Re: How to move a DB from one server to another...|