Re: pg_dump out of memory for large table with LOB

2018-11-10 Thread Adrian Klaver
On 11/10/18 2:46 PM, Ron wrote: On 11/09/2018 05:49 PM, Jean-Marc Lessard wrote: I am running PostgreSQL 9.6.5 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit on win2012 with 12Gb RAM The dumped table is 0.5TB, 17 million rows and LOB uses about 99% of

Re: pg_dump out of memory for large table with LOB

2018-11-10 Thread Ron
On 11/09/2018 05:49 PM, Jean-Marc Lessard wrote: I am running PostgreSQL 9.6.5 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit on win2012 with 12Gb RAM The dumped table is 0.5TB, 17 million rows and LOB uses about 99% of the space. The pg_dump consum

pg_dump out of memory for large table with LOB

2018-11-10 Thread Jean-Marc Lessard
I am running PostgreSQL 9.6.5 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit on win2012 with 12Gb RAM The dumped table is 0.5TB, 17 million rows and LOB uses about 99% of the space. The pg_dump consumes the entire system memory and swap, then terminates with

Missing RHEL rpm(pg_catcheck-11) in postgres 11 repo.

2018-11-10 Thread Chatterjee, Satyajit
Hello team, We are looking to upgrade our application from Postgres 9.5 to 11x, but we are unable to find the RPM named 'pg_catcheck-11x' for Redhat: https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.5-x86_64/. We request your help in getting this rpm to the repo. Thanks, -Satyaj