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