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
