Re: pg_restore (fromuser -> touser) - Mailing list pgsql-general

From David G. Johnston
Subject Re: pg_restore (fromuser -> touser)
Date
Msg-id CAKFQuwa2q05+Qa-k55MyOtWPeCLXA8AMfM2Ye5Z_gZtjYpF8pA@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore (fromuser -> touser)  (Ganesh Korde <ganeshakorde@gmail.com>)
Responses Re: pg_restore (fromuser -> touser)  (Mayan <popalzie@gmail.com>)
List pgsql-general
On Sun, Jul 25, 2021 at 8:02 PM Ganesh Korde <ganeshakorde@gmail.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.

pgsql-general by date:

Previous
From: Ganesh Korde
Date:
Subject: Re: pg_restore (fromuser -> touser)
Next
From: Matthias Apitz
Date:
Subject: PostgreSQL reference coffee mug