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
--
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.