> Yes, after Tom's hint, a search for "single-user" took me to that page. But,
> beginner as I am,
> I didn't know that single-user mode was the thing that I needed. I need a
> remedial class.
> Something like "PostgreSQL for those whose mental model has been conditioned
> by decades of working
Hi Team,
Anyone on PCI-DSS requirements for PostgreSQL DB, need help for some of the
points.
Regards,
Inzamam Shafiq
DBA
Thanks.
As soon as I read your reply I recalled the leakproof issue from a
discussion with a former colleague years ago.
At the time, I was new to Postgresql and I realize now I should have
remembered that.
Disabling the RLS indeed resulted in the superior plan for the test_user.
The harder part w
On 9/20/22 04:27, Inzamam Shafiq wrote:
Hi Team,
Anyone on PCI-DSS requirements for PostgreSQL DB, need help for some of
the points.
Can you be more specific? (Typically. the auditors or the "audit pre-check"
team will ask for a bunch of details on how your instance is configured.)
Th
I'm wondering if there's a disconnect between my servers postgresql.conf
and the system tcp settings? Are the config names supposed to match a
file in /proc/sys/net/ipv4?
In postgres 14 install's postgresql.conf on centos 7:
# - TCP settings -
# see "man tcp" for details
#tcp_keepal
Has anyone used SRM/SRDF to replicate a Linux VM running PostgreSQL?
If so, did you have any problems when "flipping" to the DR replica?
I don't think PostgreSQL will care or notice, as long as data/base and
data/pg_xlog are on the same replicated LUN, but wanted to ask for others'
experience.
On 9/19/22 18:15, Tom Lane wrote:
Bryn Llewellyn writes:
Is rescue possible? Or must I simply remove my cluster and use "pg_ctl" to
create a new one within my existing PG 14.5 software env?
Stop the cluster, start a single-user session ("postgres --single"),
re-grant superuser to the postgres
.
.
.
And Tom’s English is excellent!
On Tue, Sep 20, 2022, 18:29 Mladen Gogala wrote:
> On 9/19/22 18:15, Tom Lane wrote:
>
> Bryn Llewellyn writes:
>
> Is rescue possible? Or must I simply remove my cluster and use "pg_ctl" to
> create a new one within my existing PG 14.5 software env?
>
>
Rob Sargent writes:
> I'm wondering if there's a disconnect between my servers postgresql.conf
> and the system tcp settings? Are the config names supposed to match a
> file in /proc/sys/net/ipv4?
Probably not --- we certainly didn't pick them with the intention
of matching any specific system'
>> My issue is that psql is timing out with "SSL SYSCALL error: Connection
>> timed out".
>
> then keepalives aren't necessarily the solution anyway. When is
> this failure occurring ... is it while trying to establish the
> database connection in the first place? Or does it only happen
> if
> On Sep 20, 2022, at 4:54 PM, Theodore M Rolle, Jr. wrote:
>
>
> .
> .
> .
> And Tom’s English is excellent!
>>
That’s what this is! With the bonus of AK,DJ and the gang - and you Mladen.
(Maybe not as searchable as one might like but that makes one pay attention. )
Rob Sargent writes:
>> then keepalives aren't necessarily the solution anyway. When is
>> this failure occurring ... is it while trying to establish the
>> database connection in the first place? Or does it only happen
>> if you've left the psql session sit idle for a long while?
> Sitting idle
12 matches
Mail list logo
