On Sun, Jul 25, 2021 at 8:02 PM Ganesh Korde <ganeshakorde(at)gmail(dot)com> wrote:
> You just need to export dump without any privileges. And while restoring
> dump use the new role.
>
You should read the body of the original email and not just the subject
line. The actual question pertains to schemas - which IIUC are tightly
linked to roles in other DBs (hence the observed behavior elsewhere) but
aside from some default search_path stuff are unrelated in PostgreSQL.
David J.