Brian Avis <brian(dot)avis(at)searhc(dot)org> writes:
> /usr/local/pgsql/bin/pg_dump $db | gzip > /usr/local/pgsql/backups/$filename
> ./bin/pg_restore -d csp pgdump_2003-6-5-csp.gz
> pg_restore: [archiver] input file does not appear to be a valid archive
> So what sort of terribly obvious thing am I doing wrong?
You want something like
gzcat pgdump_2003-6-5-csp.gz | psql csp
pg_restore is for working with -Fc or -Ft output from pg_dump, not the
plain-text script output.
regards, tom lane