Backups and restores.

I am upgrading my workstation to 7.3.3.   I have some database backups
that were created with this command.

/usr/local/pgsql/bin/pg_dump $db | gzip > /usr/local/pgsql/backups/$filename

Which generates this sort of file.

pgdump_2003-6-5-csp.gz

Formatted like so.

\connect - postgres
CREATE SEQUENCE "time_periods_id_seq" start 3 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"time_periods_id_seq"');
CREATE SEQUENCE "length_of_time_id_seq" start 5 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"length_of_time_id_seq"');
CREATE SEQUENCE "depts_id_seq" start 61 increment 1 maxvalue 2147483647
minvalue 1  cache 1 ;
SELECT nextval ('"depts_id_seq"');
CREATE SEQUENCE "divisions_id_seq" start 4 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;


And so on and so forth.

When I try to use pg_restore from 7.3.3 to restore that file with this
command.
./bin/pg_restore -d csp pgdump_2003-6-5-csp
Or even this one.
./bin/pg_restore -d csp pgdump_2003-6-5-csp.gz

I get this error.

pg_restore: [archiver] input file does not appear to be a valid archive

So what sort of terribly obvious thing am I doing wrong?

I tried to do a search for this in the mailing list archives but the
database is apparently temporarily down.  :)  Go figure.  Just when I
need it.

Thanks for the help all.



--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!