ERROR: invalid memory alloc request size 1073741824

Hi,

I have a tif image of 483 mb, i am uploading the raster into postgis using

"*raster2pgsql -I -C
/home/XXXXXX/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif
postgis.gistesttable6 |psql -h localhost -U XXXX -d gisdb -p 5432*"

i have checked with tiles by setting -t auto but when aggregating results
of titles using st_union my system is getting hung.

so, i need to import the tif file of memory greater than 500mb at least .

the error that i am getting is

*ERROR:*
*BEGIN*
*CREATE TABLE*
*ERROR: invalid memory alloc request size 1073741824*
*ERROR: current transaction is aborted, commands ignored until end of
transaction block*
*ERROR: current transaction is aborted, commands ignored until end of
transaction block*
*ERROR: current transaction is aborted, commands ignored until end of
transaction block*
*ROLLBACK*

please help me with the pointers and suggestions to fix this

--
Thanks,
Suhal Vemu

--
Please note that this email, including any attachments, is intended solely
for the individual (s) or entity (ies) to whom they are addressed and may
contain information that is private, confidential and privileged. In case
you are not the intended recipient, request you to notify the sender by
reply mail and delete this email, including any copies or attachments from
your system. Any unauthorized dissemination, disclosure and/or use of the
contents of this communication to anyone is strictly prohibited and
punishable by law.