Hi,
Thanks for the good point:
$ sysctl vm.overcommit_memory
vm.overcommit_memory = 0
That is a difference, the old pg11 running on Ubuntu 18.4 had
disabled overcommit (vm.overcommit_memory = 2).
Anyway, on a dedicated DB server box with 123GB RAM running only vacuum (14
parallel processes (2GB
On 2025-Jun-19, Dominique Devienne wrote:
> Hi. Little mystery we don't understand. v17.
>
> Create new DB, owned by dedicated new ROLE.
> Create extension (pgcrypto) in our case. Installed in public, owned by
> DB owner role.
> Create schemas and populate them inside the DB.
I would investigate
Hello all,
I've been lurking for quite a while on the pg lists but now I need some
help or rather, want to start a discussion:
We can set a password for a role in PG but there is no way to force a
user to change it, prevent reuse or to enforce some complexity on it. As
I understand, that's b
Hi,
The problem is as follows.
A replication cluster includes a primary server and one hot-standby replica.
The workload on the primary server is represented by multiple requests generating multixact IDs, while the hot-standby replica performs reading requests.
After some time, all requests on th
raphi writes:
> We can set a password for a role in PG but there is no way to force a
> user to change it, prevent reuse or to enforce some complexity on it. As
> I understand, that's by choice and when I ask about this, the usual
> answer is "that's not the job of a database, use LDAP for it".
Hi, The problem is as follows.A replication cluster includes a primary server and one hot-standby replica.The workload on the primary server is represented by multiple requests generating multixact IDs, while the hot-standby replica performs reading requests. After some time, all requests on the ho
Am 23.06.2025 um 17:05 schrieb Tom Lane:
raphi writes:
We can set a password for a role in PG but there is no way to force a
user to change it, prevent reuse or to enforce some complexity on it. As
I understand, that's by choice and when I ask about this, the usual
answer is "that's not the job
Re: raphi
> Sorry for this rather long (first) email on this list but I feel like I had
> to explain our usecase and why LDAP is not always as simple as adding a line
> to hba.conf.
Did you give the "pam" method a try? There are PAM modules for all
sorts of password checks.
Christoph
Hi there and thx for reading and answering if you can
A few years ago, I wrote a pg module in C on gcc/linux. This module works fine,
and I'm striving to port on windows postgres edb, I compiled the corresponding
.dll wirh both mingw54 and msvc 2022, but got postgres crashes.
I also tried the re
On 6/23/25 12:32, C. wrote:
Hi there and thx for reading and answering if you can
A few years ago, I wrote a pg module in C on gcc/linux. This module
works fine, and I'm striving to port on windows postgres edb, I compiled
the corresponding .dll wirh both mingw54 and msvc 2022, but got postgr
On 6/23/25 13:19, C. wrote:
Reply to list also.
Ccing list.
I don't know. The postgres kernel crashes, not the client
app.
So does the Postgres log show anything?
On Monday, June 23, 2025 at 09:41:33 PM GMT+2, Adrian Klaver
wrote:
On 6/23/25 12:32, C. wrote:
> Hi there and thx for re
Am 23.06.2025 um 22:39 schrieb Christoph Berg:
Re: raphi
Sorry for this rather long (first) email on this list but I feel like I had
to explain our usecase and why LDAP is not always as simple as adding a line
to hba.conf.
Did you give the "pam" method a try? T
Not really because it's a loca
12 matches
Mail list logo
