AW: pg_dump --binary-upgrade out of memory

From: "Dischner, Anton" <Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de>
To: 'Антон Глушаков' <a(dot)glushakov86(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: AW: pg_dump --binary-upgrade out of memory
Date: 2024-02-14 07:11:00
Message-ID: e0bd4eb1253645558bc18c63de13ef7a@med.uni-muenchen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

-Hi.
-I encountered the problem of not being able to upgrade my instance (14->15) via pg_upgrade.
-The utility crashed with an error in out of memory.-
-After researching a bit I found that this happens at the moment of export schema with pg_dump.

-Then I tried to manually perform a dump schema with the parameter --binary-upgrade option and also got an out of memory.
-Digging a little deeper, I discovered quite a large number of blob objects in the database (pg_largeobject 10GB and pg_largeobject_metadata 1GB (31kk rows))
-I was able to reproduce the problem on a clean server by simply putting some random data in pg_largeobject_metadata

-$insert into pg_largeobject_metadata (select i,16390 from generate_series(107659,34274365) as i);

-$pg_dump --binary-upgrade --format=custom -d mydb -s -f tmp.dmp
-and after 1-2 min get out of memory ( i tried on server with 4 and 8 gb RAM)

-Perhaps this is a bug? How can I perform an upgrade?

a quick and dirty solution might be an additional temporary swap space like this https://en.euro-linux.com/blog/creating-a-swap-file-or-how-to-deal-with-a-temporary-memory-shortage/

best,

Anton

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Антон Глушаков 2024-02-14 11:26:13 Re: pg_dump --binary-upgrade out of memory
Previous Message M Sarwar 2024-02-13 20:27:31 RE: pg_restore error