Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall and owner of the extension - Mailing list pgsql-admin

From kaido vaikla
Subject Re: pg_dumpall and owner of the extension
Date
Msg-id CA+427g-Xh1H+zLP-CW9CUB_TO5dAsJBi-u0zUMteaKewxa1ewQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumpall and owner of the extension  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
Thnx, at least something.
Especially for them, whose  use pg_dumpall as a backup tool.

br
Kaido

On Mon, 29 Jan 2024 at 09:57, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2024-01-24 at 19:04 +0200, kaido vaikla wrote:
> CREATE EXTENSION doc should be change like:
> "The user who runs CREATE EXTENSION becomes the owner of the extension until first export-import" ;)

Here is a patch that implements something like that.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_dumpall and owner of the extension
Next
From: Dirk Krautschick
Date:
Subject: pg_repack vs. running logical/physical replication