Re: ERROR: invalid memory alloc request size 1073741824

Hi all,

This is gisdb and my POSTGIS VERSION
------------------------------------------------------------
---------------------------------
*gisdb=# SELECT PostGIS_version();*
* postgis_version *
*---------------------------------------*
* 2.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1*
*(1 row)*
*---------------------------------------------------------------------------------------------*
*It didn't create the table it rolled back .*

*Actually the table creating command is: *

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

*output :*
*______________________________________________________________________________________________________________________________*
*:~$ raster2pgsql -I -C
/home/XXXXX/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif
postgis.gistesttable6 |psql -h localhost -U XXX -d gisdb -p 5432*
*Processing 1/1:
/home/suhalvemu/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif*
*Password for user cropin_suhal: *
*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*

On Wed, Apr 11, 2018 at 3:16 PM, Suhal Vemu <suhal(at)cropextechnology(dot)com>
wrote:

> Hi David,
>
> This is gisdb and my POSTGIS VERSION
> ------------------------------------------------------------
> ---------------------------------
> *gisdb=# SELECT PostGIS_version();*
> * postgis_version *
> *---------------------------------------*
> * 2.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1*
> *(1 row)*
>
> *---------------------------------------------------------------------------------------------*
> *It didn't create the table it rolled back .*
>
> *Actually the table creating command is: *
>
> *raster2pgsql -I -C
> /home/XXXXX/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif
> postgis.gistesttable6 |psql -h localhost -U XXXX -d gisdb -p 5432*
>
>
> *output :*
>
> *______________________________________________________________________________________________________________________________*
> *:~$ raster2pgsql -I -C
> /home/XXXXX/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif
> postgis.gistesttable6 |psql -h localhost -U XXX -d gisdb -p 5432*
> *Processing 1/1:
> /home/suhalvemu/Downloads/20161207T055222_20161207T055323_T42QYL/20161207T055222_20161207T055323_T42QYL.ndvi.tif*
> *Password for user cropin_suhal: *
> *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*
>
>
>
> On Wed, Apr 11, 2018 at 2:34 PM, David Rowley <
> david(dot)rowley(at)2ndquadrant(dot)com> wrote:
>
>> On 7 April 2018 at 02:14, Suhal Vemu <suhal(at)cropextechnology(dot)com> wrote:
>> > Hi David,
>> >
>> > This is gisdb and my POSTGIS VERSION
>> > ------------------------------------------------------------
>> ---------------------------------
>> > gisdb=# SELECT PostGIS_version();
>> > postgis_version
>>
>> Hi Suhal,
>>
>> Please reply including the list. You've not really shown the
>> information I asked for. Best to reply to the list with that
>> information.
>>
>> --
>> David Rowley http://www.2ndQuadrant.com/
>> PostgreSQL Development, 24x7 Support, Training & Services
>>
>
>
>
> --
> Thanks,
> Suhal Vemu
>

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