Problems dumping a DB

From: jscott(at)webmail(dot)bmi(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Problems dumping a DB
Date: 2000-11-09 00:02:49
Message-ID: 200011082312.PAA12240@smtp.bmi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)titan jesse]$ pg_dump rat > rat.db
dumpSequence(reporters_idnum_seq): 0 (!= 1) tuples returned by SELECT
[jesse(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-09 00:13:30 Re: Relation 'pg_user' does not exist
Previous Message Stephan Szabo 2000-11-09 00:01:32 Re: Re: permissions on databases vs. permissions on tables