[ADMIN] Trouble restoring 7.2.1 database into 7.4.2 database

[Chris White (cjwhite)]

Title: Message

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