upload large files in pgadmin

From: "Sebastian Wandernoth" <s_wandernoth(at)gmx(dot)de>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: upload large files in pgadmin
Date: 2019-07-19 12:23:20
Message-ID: trinity-7fd53ae9-7fa8-4343-819e-d12c5e175d8a-1563539000704@3c-app-gmx-bs21
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hey guys,</div>

<div>&nbsp;</div>

<div>I would like to use pgadmin4 to restore a postgres database from a backup file that is about 300MB in size.</div>

<div>&nbsp;</div>

<div>Both pgadmin and postgres are running in separate docker containers in the same pod on a kubernetes cluster.</div>

<div>&nbsp;</div>

<div>If I try to upload the file (after of course adjusting the <em>Maximum file upload size</em> in the preferences) it gets stuck and does not do anything. I also tried it locally with the same result (So it is definitely not a network/firewall issue). A smaller file (7MB) works without problems</div>

<div>&nbsp;</div>

<div>My suspicion is that pgadmin does not internally adjust the max file size even though it is showing the new number in the UI. Is it possible to adjust this value in the config file?</div>

<div>&nbsp;</div>

<div>Am I doing something else wrong? Does anyone have experience with such a setup?</div>

<div>&nbsp;</div>

<div>This is the version of pgadmin I am using:</div>

<div>
<div>
<div><b>Version</b></div>

<div>4.10</div>
</div>

<div>
<div><b>Copyright</b></div>

<div>Copyright (C) 2013 - 2019, The pgAdmin Development Team</div>
</div>

<div>
<div><b>Python Version</b></div>

<div>3.7.3 (default, May 11 2019, 02:00:41) [GCC 8.3.0]</div>
</div>

<div>
<div><b>Flask Version</b></div>

<div>1.0.2</div>
</div>
</div>

<div>&nbsp;</div>

<div>Thanks in advance for your help</div>

<div>Sebastian</div>

<div>&nbsp;</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.5 KB

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Fahar Abbas 2019-07-19 12:31:24 Re: upload large files in pgadmin
Previous Message Dave Irwin 2019-07-18 17:02:02 Re: PGAdmin4 - Not connected to the server or the connection to the server has been closed.