Re: [GENERAL] I dont get it,

Tom Lane wrote: Michael Ben-Nes <[EMAIL PROTECTED]> writes: pg_dump -Fc sourcedb > sourcedb-Fc.dump pg_dump -a sourcedb > sourcedb.dump createdb test pg_restore -c -s -d test sourcedb-Fc.dump psql test < sourcedb.dump Is there a particularly good reason for doing it that way? Yep,

Re: [GENERAL] I dont get it, dump / restore failures to the same cluster.

Michael Ben-Nes <[EMAIL PROTECTED]> writes: > pg_dump -Fc sourcedb > sourcedb-Fc.dump > pg_dump -a sourcedb > sourcedb.dump > createdb test > pg_restore -c -s -d test sourcedb-Fc.dump > psql test < sourcedb.dump Is there a particularly good reason for doing it that way? > I got few errors ( here

[GENERAL] I dont get it, dump / restore failures to the same cluster.

Hello I did on the same server / cluster ( 8.0.1 / ISO-8859-8 ) pg_dump -Fc sourcedb > sourcedb-Fc.dump pg_dump -a sourcedb > sourcedb.dump createdb test pg_restore -c -s -d test sourcedb-Fc.dump psql test < sourcedb.dump I got few errors ( here are some of them ): ERROR: insert or