[postgis-tickets] [PostGIS] #4330: postgis_restore fails when output piped to an intermediate process

[PostGIS]

#4330: postgis_restore fails when output piped to an intermediate process
------------------------------------+---------------------------
  Reporter:  hranalli               |      Owner:  strk
      Type:  patch                  |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 2.5.2
 Component:  build/upgrade/install  |    Version:  2.5.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by hranalli):

 It's been a while since I made this patch, as I didn't want to submit it
 until after several test runs, but I am pretty sure the CREATE TABLE
 statement also processes the table data. To figure out the problem, I
 added logging to see where it crashed. And it was in the  middle of the
 CREATE TABLE loop that it ran out of memory. The change I made there
 resolves the problem. I've run the script several times on our database,
 and it always fails without the patch, and succeeds with it.

 I adjusted the COMMENT area because, as there was no intermediate
 processing required, it seemed reasonable to remove a similar, potential
 failure point (though I agree an unlikely one, given the data sizes
 involved). Other sections which buffer data need the buffer to make
 decisions, and so would be harder to adjust.

 You can certainly leave out the patch on the COMMENTS section. I do know
 the patch on CREATE TABLE solves the problem. There may be a more
 fundamental issue, but I'm not a Perl programmer or PostGIS expert.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4330#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.