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/2016120
output :
______________________________
:~$ raster2pgsql -I -C /home/XXXXX/Downloads/2016120
Processing 1/1: /home/suhalvemu/Downloads/2016
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@cropextechnology.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_T42QY L/20161207T055222_20161207T055 323_T42QYL.ndvi.tif postgis.gistesttable6 |psql -h localhost -U XXXX -d gisdb -p 5432 output :____________________________________________________________ ______________________________ ______________________________ ______ :~$ raster2pgsql -I -C /home/XXXXX/Downloads/20161207T055222_20161207T055323_T42QY L/20161207T055222_20161207T055 323_T42QYL.ndvi.tif postgis.gistesttable6 |psql -h localhost -U XXX -d gisdb -p 5432 Processing 1/1: /home/suhalvemu/Downloads/20161207T055222_20161207T055323_T4 2QYL/20161207T055222_20161207T 055323_T42QYL.ndvi.tif Password for user cropin_suhal:BEGINCREATE TABLEERROR: invalid memory alloc request size 1073741824ERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction blockROLLBACK--On Wed, Apr 11, 2018 at 2:34 PM, David Rowley <david.rowley@2ndquadrant.com> wrote:On 7 April 2018 at 02:14, Suhal Vemu <suhal@cropextechnology.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 & ServicesThanks,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.
В списке pgsql-hackers по дате отправления: