Suhal Vemu <suhal(at)cropextechnology(dot)com> writes:
> so, i need to import the tif file of memory greater than 500mb at least .
If you're trying to cram that into a single bytea field, it's unsurprising
that it fails. PG is not designed to work with table rows (let alone
individual fields) that exceed some not-very-large fraction of 1GB.
You could stream the value into a "large object", perhaps.
regards, tom lane