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.