Re: pg_restore (fromuser -> touser)

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ganesh Korde <ganeshakorde(at)gmail(dot)com>
Cc: Mayan <popalzie(at)gmail(dot)com>, Ninad Shah <nshah(dot)postgres(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore (fromuser -> touser)
Date: 2021-07-26 03:10:53
Message-ID: CAKFQuwa2q05+Qa-k55MyOtWPeCLXA8AMfM2Ye5Z_gZtjYpF8pA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2021-07-26 06:56:15 PostgreSQL reference coffee mug
Previous Message Ganesh Korde 2021-07-26 03:01:58 Re: pg_restore (fromuser -> touser)