Thread: pg_dump out of range error (7.1.3)

When trying to dump data from a database with ~43GB of data, this is the
error I get. The domains table has ~30 million rows.

command line = pg_dump test2
db version = 7.1.3
error string = getTables(): SELECT (for PRIMARY KEY) failed on table
domains.  Explanation from backend: ERROR:  dtoi4: integer out of range

So is upgrading to 7.2 the cure? :-)

--Arsalan.

-------------------------------------------------------------------
People often hate those things which they do not know, or cannot understand.
--Ali Ibn Abi Talib (AS)

"Arsalan Zaidi" <azaidi@directi.com> writes:
> When trying to dump data from a database with ~43GB of data, this is the
> error I get. The domains table has ~30 million rows.

> command line = pg_dump test2
> db version = 7.1.3
> error string = getTables(): SELECT (for PRIMARY KEY) failed on table
> domains.  Explanation from backend: ERROR:  dtoi4: integer out of range

Looks like you've got OIDs above 2 billion in your database.  7.1's
pg_dump is a bit careless about sometimes trying to stuff such values
into signed integers :-(

> So is upgrading to 7.2 the cure? :-)

You should be able to run 7.2's pg_dump against the 7.1 server to dump
this database.

            regards, tom lane