upload large files in pgadmin

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

upload large files in pgadmin

Sebastian Wandernoth
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
 
Reply | Threaded
Open this post in threaded view
|

Re: upload large files in pgadmin

fahar
Hi Sebastian!

RM is already reported:-


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
Reply | Threaded
Open this post in threaded view
|

Aw: Re: upload large files in pgadmin

Sebastian Wandernoth
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:-
 
 
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
Reply | Threaded
Open this post in threaded view
|

Re: Re: upload large files in pgadmin

fahar
Hi Sebastian!

We can not give any timeline for this and it's already in our list.

Kind Regards,


On Fri, Jul 19, 2019 at 5:42 PM Sebastian Wandernoth <[hidden email]> wrote:
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:-
 
 
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


--
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
Reply | Threaded
Open this post in threaded view
|

Re: upload large files in pgadmin

sylviayzc
In reply to this post by Sebastian Wandernoth
Hello Sebastian,

I wonder have you solved the problem? I am facing pretty much the same issue
but the post on https://redmine.postgresql.org/issues/2097 could not help me
at all.

I am using pgAdmin 4.21 to backup(actully my boss asked me to "copy", but I
can't download the snapshot :( ) and try to restore a database from AWS
RDS(postgres12) to the other ubuntu server(postgres13). Successful backup,
however, facing the upload limit 50mb when restoring. I saw there is some
adjustment could be made in phpPgAdmin configuration. But pgAdmin doesn't
work that way. I've also tried command line suggested in  stack
<https://stackoverflow.com/questions/1237725/copying-postgresql-database-to-another-server>
, even I adjusted the "Security Group" still no working.

So now I started it over again digging every possible solution.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html