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!