Re: [GENERAL] Backup strategies with significant bytea data

Ivan Voras wrote: > Leigh Dyer wrote: >> Hi, >> >>For years now I've simply backed up my databases by doing a nightly >>pg_dump, but since we added the ability for users to import binary files >>in to our application, which are stored in a bytea fields, the dump >>sizes have gone through the roof —

Re: [GENERAL] Backup strategies with significant bytea data

Leigh Dyer wrote: Hi, For years now I've simply backed up my databases by doing a nightly pg_dump, but since we added the ability for users to import binary files in to our application, which are stored in a bytea fields, the dump sizes have gone through the roof — even with gzip compression, th

[GENERAL] Backup strategies with significant bytea data

Hi, For years now I've simply backed up my databases by doing a nightly pg_dump, but since we added the ability for users to import binary files in to our application, which are stored in a bytea fields, the dump sizes have gone through the roof — even with gzip compression, they're significantly