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

From Ganesh Korde
Subject Re: pg_restore (fromuser -> touser)
Date
Msg-id CAPNyb0WBZH7S233yFjPBdAArzFVmA3wmif6h=y5r3BLDzntSzQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore (fromuser -> touser)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pg_restore (fromuser -> touser)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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.johnston@gmail.com> wrote:
On Sun, Jul 25, 2021 at 8:39 AM Mayan <popalzie@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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_restore (fromuser -> touser)
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_restore (fromuser -> touser)