Re: [GENERAL] Problems backing up

2010-04-07 Thread Tom Lane
Sebastien Boisvert writes: > - Original Message >> From: Tom Lane >>> [ COPY fails to dump a 138MB bytea column ] >> I wonder whether you are doing anything that exacerbates >> the memory requirement, for instance by forcing an encoding conversion to >> something other than the databa

Re: [GENERAL] Problems backing up

2010-04-07 Thread Sebastien Boisvert
- Original Message > From: Tom Lane >> [ COPY fails to dump a 138MB bytea column ] > I wonder whether you are doing anything that exacerbates > the memory requirement, for instance by forcing an encoding conversion to > something other than the database's server_encoding. Our backups

Re: [GENERAL] Problems backing up

2010-01-31 Thread Tom Lane
Sebastien Boisvert writes: > [ COPY fails to dump a 138MB bytea column ] If you can't switch to a 64-bit build of Postgres, you might need to think about converting those byteas to large objects. It's expected for COPY to require memory space equal to several times the width of the row it's tryi