search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 637 forks source link

Backup on a shared server doesn't seem to work (RM #6385) #4272

Closed dpage closed 2 years ago

dpage commented 3 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/6385 Originally created by Pradip Parkale at 2021-04-13 16:45:00 UTC.

Hello,

I'm running some pgadmin4 on Kubernetes clusters, using the image dpage/pgadmin4:5. I've created multiple servers from the default account and shared them to my users, unfortunately when they try to open the Backup dialog box, the following message is displayed :

The Backup dialog box works fine from the default account. I've tried to open the dialog box on a shared database from an administrator account, which shows me the same message. The "Binary paths" configuration seems fine since it's the same in the default account and the user accounts. I can't see any error message in docker logs.

If I recreate the exact same server from a user account and hit Backup on this one, it works well, so I guess the problem comes from the sharing, although the documentation states these limitations but doesn't mention dumping or restoring : The Users accessing the shared servers cannot do the following operations on the shared servers: Create a server Delete the server Rename the server Rename the group server Change of host, port, and maintenance database I couldn't find anything on the mailing list about this and I found an old bug on redmine (pgadmin/#3722), which doesn't seem related to shared servers.

Is there any way to increase log verbosity or do you have any idea what's going on ?

Thanks for your support, -- Bastien Ogier

dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-1 Originally created by Pradip Parkale at 2021-04-13 17:06:58 UTC.

As a part of this story, verify Backup, Restore, and Maintenance for all supported nodes.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 5.2
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-2 Originally created by Pradip Parkale at 2021-04-14 06:42:04 UTC.

Applied in changeset commit:cb7bcaf939d7d67fd164b03b581d16bc573c1576.

Redmine ticket header update:

Name Old Value New Value
Done Ratio changed 0 90
Status changed In Progress In Testing
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-3 Originally created by Akshay Joshi at 2021-04-14 10:32:43 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 88 EDB Sprint 89
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-4 Originally created by Akshay Joshi at 2021-04-20 08:51:19 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Pradip Parkale Yogesh Mahajan
dpage commented 3 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/5801 Originally created by Yogesh Mahajan at 2021-04-20 13:53:38 UTC.

Screenshot_2021-04-20_at_5.31.54_PM.png

Filename: Screenshot_2021-04-20_at_5.31.54_PM.png

dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-6 Originally created by Yogesh Mahajan at 2021-04-20 13:53:40 UTC.

This is working fine on . Verified on docker, centos in server mode. But issue is reproducible on pgAdmin installs using pip packages.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Attachment added Screenshot 2021-04-20 at 5.31.54 PM.png
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-7 Originally created by Yogesh Mahajan at 2021-04-21 09:49:20 UTC.

Issue stil reproducible if non-admin user added new server or have auto-detected servers & then he access shared servers.

Redmine ticket header update:

Name Old Value New Value
Status changed Resolved New
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-8 Originally created by Pradip Parkale at 2021-04-22 06:49:24 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Yogesh Mahajan Pradip Parkale
Status changed New In Progress
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-9 Originally created by Akshay Joshi at 2021-04-22 08:49:40 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 5.2
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-10 Originally created by Akshay Joshi at 2021-04-22 11:57:13 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 5.3
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-11 Originally created by Pradip Parkale at 2021-04-22 12:11:40 UTC.

Applied in changeset commit:8ae8fea6d2c4198af96e7bf380c2f5c108a32ed9.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-12 Originally created by Pradip Parkale at 2021-04-23 06:39:41 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing In Progress
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-13 Originally created by Akshay Joshi at 2021-04-27 06:30:38 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-14 Originally created by Yogesh Mahajan at 2021-04-28 04:06:14 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Pradip Parkale Yogesh Mahajan
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-15 Originally created by Akshay Joshi at 2021-04-28 10:49:44 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 89 EDB Sprint 90
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6385#note-16 Originally created by Yogesh Mahajan at 2021-04-29 05:06:57 UTC.

This is working fine. Non-admin user can perform backup & restore actions on shared server depending on database object access.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
dpage commented 2 years ago

Issue closed on Redmine.