PostgreSQL Administration

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

pg_dump error

Jerry Cadet

2005-09-28, 11:24 am

Hello,

I am running Postgresql 8.0 on a win3K machine. I launched a backup using
the pgAdmin III utility. I chose the TAR option with BLOBs. I received the
following messages:

pg_dump: dumping content of table face
pg_dump: (tar archiver) actual file length (-760496003) does not match
expected (-760496003)
pg_dump: *** aborted because of error

Process returned exit code 1

My question would be: what is happenning with the face table which I just
vaccuumed and reindexed before I launched the backup? I have to say that
this table contain a blob field and is quite huge (5 million rows)

Thanks

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links