Trouble restoring 7.2.1 database into 7.4.2 database

From: "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Trouble restoring 7.2.1 database into 7.4.2 database
Date: 2004-04-09 07:26:11
Message-ID: 004601c41e03$eeef4590$77976b80@amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have table defined as follows:

create table vm_emailjob
(
JobId serial not null,
MessageId varchar(128) not null,
Recipients bytea not null,
SendTime bigint not null,
QueuedTime bigint not null,
RetryCount integer not null,

primary key (JobId)
);

When I restore a backup into a 7.4.2 database from a backup made on
7.2.1 database, using the clean option, I get the following error.

pg_restore: [archiver (db)] could not execute query: ERROR: sequence
"vm_emailjob_jobid_seq" does not exist

and the restore fails. If I edit the pg_backup_db.c to display what's
statements are being executed I see the following:

sending: 'DROP TABLE "vm_emailjob";'

sending: 'DROP SEQUENCE "vm_emailjob_jobid_seq";'

pg_restore: [archiver (db)] could not execute query: ERROR: sequence
"vm_emailjob_jobid_seq" does not exist

Looks like the Drop table is also deleting the sequence.

If I do the restore on a 7.2.1 database I have no problem.

How can I get around this?

Chris White

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-04-09 12:44:26 Re: parameter to control cycle detection
Previous Message Coby Beck 2004-04-09 06:14:04 Re: parameter to control cycle detection