From: | Brian Avis <brian(dot)avis(at)searhc(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Backups and restores. |
Date: | 2003-06-07 00:09:03 |
Message-ID: | 3EE12D1F.1010908@searhc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Roberto Andrade Fonseca | 2003-06-07 00:49:06 | Re: Create Foriegn Key |
Previous Message | Erik Ronström | 2003-06-06 23:14:02 | Re: Nulls get converted to 0 problem |