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