Backups and restores.

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!

Responses

Browse pgsql-general by date

  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