ghe Posted April 25, 2008 Share Posted April 25, 2008 Good Day to All, Hi, does anyone here know about why this pg_dump error occurs everytime I try to backup my DB? > pg_dump: [tar archiver] actual file length (256661) does not match expected (253952) > pg_dump: *** aborted because of error > > Process returned exit code 1. I already have tried to VACUUM my DB but the error still occurs. Hope to have some help. Thank you in advance. Quote Link to comment Share on other sites More sharing options...
btherl Posted April 25, 2008 Share Posted April 25, 2008 Which version of postgres do you have? Google search shows that older versions of postgres could fail when making a tar pg_dump, because they needed to store the uncompressed table dump in /tmp. Quote Link to comment Share on other sites More sharing options...
ghe Posted April 25, 2008 Author Share Posted April 25, 2008 Im using Postgres 8.2.5. Quote Link to comment Share on other sites More sharing options...
ghe Posted April 25, 2008 Author Share Posted April 25, 2008 For those who still experience this error in pg_dump. I've fixed this problem through upgrading the version of my pgAdmin III, from v1.6.3 to v1.8. Regards, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.