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
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