Have you tried:
zcat /usr/local/pgsql/backups/pgdump_2003-6-5-csp.gz | psql -d csp
and looked in
http://www.us.postgresql.org/postgresql-7.3.3/backup.html#BACKUP-DUMP-RESTOR
E
Cheers,
Murthy
>-----Original Message-----
>From: Brian Avis [mailto:brian.avis@searhc.org]
>Sent: Friday, June 06, 2003 20:09
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] 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!
>
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>