upload large files in pgadmin

Hey guys,

 

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

 

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

 

If I try to upload the file (after of course adjusting the Maximum file upload size 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

 

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?

 

Am I doing something else wrong? Does anyone have experience with such a setup?

 

This is the version of pgadmin I am using:

Version

4.10

Copyright

Copyright (C) 2013 - 2019, The pgAdmin Development Team

Python Version

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

Flask Version

1.0.2

 

Thanks in advance for your help

Sebastian

 

Hi Fahar,

 

Thanks for reraising the issue. I see that it has been there for 2 years already. How are the chances for this to be fixed in the near future?

 

Gesendet: Freitag, 19. Juli 2019 um 14:31 Uhr
Von: "Fahar Abbas" <[hidden email]>
An: "Sebastian Wandernoth" <[hidden email]>
Cc: "pgadmin-support lists.postgresql.org" <[hidden email]>
Betreff: Re: upload large files in pgadmin

Hi Sebastian!

 

RM is already reported:-

 

https://redmine.postgresql.org/issues/2097

 

On Fri, Jul 19, 2019 at 5:23 PM Sebastian Wandernoth <[hidden email]> wrote:

Hey guys,

 

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

 

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

 

If I try to upload the file (after of course adjusting the Maximum file upload size 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

 

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?

 

Am I doing something else wrong? Does anyone have experience with such a setup?

 

This is the version of pgadmin I am using:

Version

4.10

Copyright

Copyright (C) 2013 - 2019, The pgAdmin Development Team

Python Version

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

Flask Version

1.0.2

 

Thanks in advance for your help

Sebastian

 

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com