Re: mystery with postgresql.auto.conf

2024-04-10 Thread Greg Sabino Mullane
On Wed, Apr 10, 2024 at 8:40 AM Matthias Apitz wrote: > Maybe later I did it accidently against the 15.1 server from the psql > history. Yes, as shown by the timestamps from your first post: -rw--- 1 postgres postgres 124 Mar 28 11:35 > postgresql151/data/postgresql.auto.conf > This is al

Re: mystery with postgresql.auto.conf

2024-04-10 Thread Laurenz Albe
On Wed, 2024-04-10 at 10:26 -0400, Tom Lane wrote: > Ian Lawrence Barwick writes: > > 2024年4月10日(水) 21:40 Matthias Apitz : > > > Why it does not give an error because the shared lib isn't there? > > > ALTER SYSTEM is a way of modifying the PostgreSQL configuration file > > via SQL; just as when y

Re: mystery with postgresql.auto.conf

2024-04-10 Thread Tom Lane
Ian Lawrence Barwick writes: > 2024年4月10日(水) 21:40 Matthias Apitz : >> Why it does not give an error because the shared lib isn't there? > ALTER SYSTEM is a way of modifying the PostgreSQL configuration file > via SQL; just as when you modify it manually, changes are not applied > until you actua

Re: mystery with postgresql.auto.conf

2024-04-10 Thread Ian Lawrence Barwick
2024年4月10日(水) 21:40 Matthias Apitz : > > El día miércoles, abril 10, 2024 a las 09:08:56 +0900, Ian Lawrence Barwick > escribió: > > > > # cat postgresql151/data/postgresql.auto.conf > > > # Do not edit this file manually! > > > # It will be overwritten by the ALTER SYSTEM command. > > > shared_pr

Re: mystery with postgresql.auto.conf

2024-04-10 Thread Matthias Apitz
El día miércoles, abril 10, 2024 a las 09:08:56 +0900, Ian Lawrence Barwick escribió: > > # cat postgresql151/data/postgresql.auto.conf > > # Do not edit this file manually! > > # It will be overwritten by the ALTER SYSTEM command. > > shared_preload_libraries = 'pg_tde' > > > > How is this possi

Re: mystery with postgresql.auto.conf

2024-04-10 Thread Ian Lawrence Barwick
Hi 2024年4月10日(水) 20:10 Matthias Apitz : (...) > End of March I started to investigate the TDE extension pg_tde within > the 16.2 server. And only this software contains this extension: > > # find /usr/local/sisis-pap/pgsql** | grep pg_tde > /usr/local/sisis-pap/pgsql-16.2/lib/pg_tde.so > /usr/loca