s or commentaries about the proposal?
>
> [1]:
> https://www.postgresql.org/message-id/flat/HE1PR0701MB256920EEAA3B2A9C06249F339E110%40HE1PR0701MB2569.eurprd07.prod.outlook.com
> [2]:
> https://git.kernel.org/pub/scm/linux/kernel/git/torvalds/linux.git/commit/?id=4ca9b3859dac14bbef0c27d00667bb5b10917adb
>
--
Gabriele Bartolini
VP, Chief Architect, Kubernetes
enterprisedb.com
to install multiple versions of an extension, we could mount
them in different directories, with the version included in the folder
name—for example, `pgvector-0.7.4` instead of just `pgvector`. However, I'm
a bit rusty with the extensions framework, so I'll need to check if this
approach is
gt; GUCs. So you could say:
>
> SET extension_search_path = /mnt/extensions/pg16/*
>
> To mean effectively the same as you're describing above.
>
That'd be great. +1.
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
n path contianing matching extension control file
> * use this directory as the extension directory for all subsequent SQL
> script loading and running actions
>
It could work, but it requires some prototyping and exploration. I'm
willing to participate and use CloudNativePG as a test bed.
Cheers,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
gres/pull/3/files
>
> Rebased and restored PGC_SUSET in the attached v5 patch, plus noted the
> required privileges in the docs.
>
> Best,
>
> David
>
>
>
>
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
Hi Joel,
On Wed, 7 Feb 2024 at 10:00, Joel Jacobson wrote:
> On Fri, Sep 8, 2023, at 16:17, Gabriele Bartolini wrote:
> > ```
> > postgres=# ALTER SYSTEM SET wal_level TO minimal;
> > ERROR: could not open file "postgresql.auto.conf": Permission denie
experiments enabling the change in the configuration file, but wasn't
sure in which `config_group` to place the 'enable_alter_system` GUC, based
on the src/include/utils/guc_tables.h. Any thoughts/hints?
Cheers,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
. Of course you can bypass it using
> COPY PROGRAM etc., but then you *know* that you are *bypassing*
> something. If you just see ALTER SYSTEM, you'll think, "that is
> obviously the appropriate tool", and there is no generally accepted way
> to communic
Hi,
I am sending an updated patch, and submitting this to the next commit fest,
as I still believe this could be very useful.
Thanks,
Gabriele
On Thu, 7 Sept 2023 at 21:51, Gabriele Bartolini <
gabriele.bartol...@enterprisedb.com> wrote:
> Hi everyone,
>
> I would like to propo
story is not).
>
> I don't have a strong opinion about this, but I also can't think of a
> reason to want to create partitions for pgbench_accounts but leave out
> pgbench_history.
>
> > From ba8f507b126a9c5bd22dd40bb8ce0c1f0c43ac59 Mon Sep 17 00:00:00 2001
> > Fr
Please discard the previous patch and use this one (it had a leftover
comment from an initial attempt to limit this to hash case).
Thanks,
Gabriele
On Thu, 30 Nov 2023 at 11:29, Gabriele Bartolini <
gabriele.bartol...@enterprisedb.com> wrote:
> Hi there,
>
> While benchmarkin
you think.
Thanks,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
0001-Include-pgbench_history-in-partitioning-method-for-p.patch
Description: Binary data
ke to see your extension, I would still like to
understand why Postgres itself shouldn't solve this basic requirement
coming from the configuration management driven/Kubernetes space. It
shouldn't be a big deal to have such an option, either as a startup one or
a GUC, should it?
Thanks,
Gabr
o see some merit in
> making it so that you can't actually change the config that's loaded at
> system start from inside the data directory or as the PG superuser,
> which my proposal above would support- just configure in postgresql.conf
> to not include any of the alter-sys
nt the role of an
operator. An operator, at that point, will have the possibility to
configure this knob in conjunction with others. A possibility that Postgres
is not currently giving.
Postgres itself should be able to give this possibility, as these
environments demand Postgres to address their emerging needs.
Thank you,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
ilability we are forced to go beyond
the single instance and think in terms of primary with one or more standbys
or at least continuous backup in place).
Thanks,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
-o "-c enable_alter_system=off"
The setting can be verified with:
psql -c 'SHOW enable_alter_system'
enable_alter_system
-
off
(1 row)
And then:
psql -c 'ALTER SYSTEM SET max_connections TO 10'
ERROR: permission denied to run ALTER SYSTEM
Thanks
d not open file "postgresql.auto.conf": Permission denied
```
IMO we should clearly state that `ALTER SYSTEM` is deliberately disabled in
a system, rather than indirectly hinting it through an inaccessible file.
Not sure if I am clearly highlighting the fine difference here.
Thanks,
Gabriele
--
Hi Tom,
On Thu, 7 Sept 2023 at 22:27, Tom Lane wrote:
> Gabriele Bartolini writes:
> > I would like to propose a patch that allows administrators to disable
> > `ALTER SYSTEM` via either a runt-time option to pass to the Postgres
> server
> > process at startup (e.g.
dly features! :)
That sounds like a good idea to me.
Thanks,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
if there’s room for it.
Thanks for your attention and … looking forward to your feedback!
Ciao,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com
21 matches
Mail list logo
