pg_dump out of range error (7.1.3) 
Author Message
 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)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/



Sun, 25 Jul 2004 17:10:32 GMT
 pg_dump out of range error (7.1.3)

Quote:

> 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 :-(

Quote:
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 25 Jul 2004 23:41:52 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. pgsql/src/bin/pg_dump common.c pg_dump.c pg_dump.h

2. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump.h

3. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

4. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

5. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

6. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

7. pgsql/src/bin/pg_dump (common.c pg_backup_archiver.h pg_dump.c pg_dump.h)

8. pgsql/src/bin/pg_dump (pg_dump.c pg_dump.h)

9. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

10. pgsql/src/bin/pg_dump (pg_dump.c pg_dump.h pg_dumpall.sh)

11. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

12. pgsql/src/bin/pg_dump common.c pg_dump.c pg_dump.h


 
Powered by phpBB® Forum Software