You just need to export dump without any privileges. And while restoring dump use the new role.
Regards,
Ganesh Korde.
On Mon, 26 Jul 2021, 1:01 am David G. Johnston, <david.g.johnston@xxxxxxxxx> wrote:
On Sun, Jul 25, 2021 at 8:39 AM Mayan <popalzie@xxxxxxxxx> wrote:Thanks for your reply. Is this something that I can request as a feature add? I don't think it should be too much of effort (based on my limited source code knowledge), but I'm not familiar with the process to request a feature.You just did. But unless you are going to fund or help with actual development I don't see this going very far. This has been inquired about many times in the past yet the feature still does not exist.David J.