Re: pg_dumpall and owner of the extension

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall and owner of the extension
Date: 2024-01-29 09:03:37
Message-ID: CA+427g-Xh1H+zLP-CW9CUB_TO5dAsJBi-u0zUMteaKewxa1ewQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)albe(at)cybertec(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dirk Krautschick 2024-01-29 14:56:13 pg_repack vs. running logical/physical replication
Previous Message Laurenz Albe 2024-01-29 07:57:21 Re: pg_dumpall and owner of the extension