Re: pg_restore (fromuser -> touser)

Thanks for the responses everyone and the reality check of how new features
get in. I will look into the suggestion by Vijaykumar in more detail and
try it out.

Thanks again,
Mayan

On Sun, Jul 25, 2021 at 10:11 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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.
>
>