[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
 Keywords:                         |
-----------------------------------+---------------------------
 We are upgrading a database from Postgres 8.2.23 and PostGIS 1.4 to
 PostgreSQL 11.2 and PostGIS 2.5. As part of our process, we pipe the
 output of postgis_restore.pl to sed, whic makes some changes to the SQL
 before it is piped to psql.

 When we do this, postgis_restore buffers the output in memory, and then is
 killed by the OS when it runs out of memory. I've created a patch that
 eliminates this buffering in the places where it is unnecessary (the
 culprit is in the TABLE DATA commands, as these are the most memory
 intensive).

 Once postgis_restore is run with the patch in place, it does a fine job of
 upgrading the database.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4330>
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.