<ogjunk-pgjedan(at)yahoo(dot)com> writes:
> This is how I'm dumping my DB:
> # pg_dump -d mydb --clean --inserts --column-inserts --format=P -v -h
> localhost -p 5432 -U otis > dbdump
> # pg_restore -a -d myOtherDbName dbdump
> pg_restore: [archiver] input file does not appear to be a valid archive
Plain dump format is a script to feed to psql. pg_restore is only for
the other two formats.
regards, tom lane