Thread: Problems dumping a DB

Hello everyone,

I'm trying to dump a database from a 6.5 PGSQL server so that I can put it
on a new server that is running the latest version.  The problem is that
when I try to dump it gives me this error:

[jesse@titan jesse]$ pg_dump rat > rat.db
dumpSequence(reporters_idnum_seq): 0 (!= 1) tuples returned by SELECT
[jesse@titan jesse]$

I'm not sure what's going on with that that sequence.  It seems to be
working properly (I just inserted another row into that table and it
assigned it the next number in the sequence.) but I can't drop the
sequence:

rat=> drop sequence reporters_idnum_seq;
ERROR:    DeletePgTypeTuple: reporters_idnum_seq type nonexistent
rat=>

I've looked around at the documentation a bit and tried to search the
mailing list archives (wasn't sure if that was working right or not) but
couldn't come up with anything.

The data is not critical, I really don't even need to import it into the
new system since we are planning a DB wipe but we want to have the old info
backed up in case we discover we need something out of it.  I may just have
to put the hard drive on the shelf and leave everything as it is.  Even if
I could just get a pg_dump -s to work that would be helpful, but that fails
precisely the same as above.

Thanks in advance to whoever it is that is going to point out the stupid
mistake I am making... :)

-Jesse


This message has been BMI Webmailed. -- http://www.bmi.net

jscott@webmail.bmi.net writes:
> I'm trying to dump a database from a 6.5 PGSQL server so that I can put it
> on a new server that is running the latest version.  The problem is that
> when I try to dump it gives me this error:

> [jesse@titan jesse]$ pg_dump rat > rat.db
> dumpSequence(reporters_idnum_seq): 0 (!= 1) tuples returned by SELECT
> [jesse@titan jesse]$

> I'm not sure what's going on with that that sequence.  It seems to be
> working properly (I just inserted another row into that table and it
> assigned it the next number in the sequence.) but I can't drop the
> sequence:

> rat=> drop sequence reporters_idnum_seq;
> ERROR:    DeletePgTypeTuple: reporters_idnum_seq type nonexistent

Wow, that's pretty bizarre.  I'm not too concerned about trying to
work out how 6.5 could get into a state like that --- but if you can
reproduce it on a newer release, let us know ;-)

Meanwhile, your best bet is to try to drop the sequence so pg_dump
won't spit up.  Evidently you are missing the tuple data type that
normally goes with a relation (including sequence relations).
Fortunately, delete isn't real picky about *what* type it drops,
it just wants to find one with the right name.  So try

create type reporters_idnum_seq(input = int4in, output = int4out);

and then see if you can drop the sequence.

            regards, tom lane