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.johns...@gmail.com> wrote: > On Sun, Jul 25, 2021 at 8:39 AM Mayan <popal...@gmail.com> 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. > >