El mié, 7 feb 2024 8:07, Sean v escribió:
> Exactly. I'm really just trying to understand if there's some functional
> limitation to it being able to do that with how it executes these types of
> queries, or if its just an optimization that hasn't been built into the
> query planner yet.
>
> I kn
On Tue, Feb 6, 2024 at 2:40 PM veem v wrote:
> Thank you Laurenz. Got it.
>
> So basically , you mean to say any DDL on a table won't allow the table to
> be read by other processes. I was under the assumption that it should allow
> the read queries to move ahead at least. I must be wrong here. T
Thank you Laurenz. Got it.
So basically , you mean to say any DDL on a table won't allow the table to
be read by other processes. I was under the assumption that it should allow
the read queries to move ahead at least. I must be wrong here. Thanks for
correcting me.
On Tue, 6 Feb 2024 at 15:46, L
gdal-libs package belongs to PostGIS
PostGIS Support Ticket #5664 -
https://trac.osgeo.org/postgis/ticket/5664#ticket
On Tue, Feb 6, 2024 at 10:12 AM Marcelo Marques
wrote:
> I appreciate the reply.
> We have an internal Satellite that we pull from the EPEL repo.
> The Satellite Repos are refres
On 2/6/24 10:18 AM, Adrian Klaver wrote:
On 2/6/24 10:11 AM, Ron Johnson wrote:
Currently, we use Object audit logging to capture all READ access to
columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE. (They are the
three columns have PII data.)
Using what audit software?
Memo to sel
> On Feb 6, 2024, at 10:11, Ron Johnson wrote:
> Thus, I'd like to exclude reads from "Postgresql JDBC Driver". (Currently, I
> filter that out using "grep -v" in a shell script that runs hourly from cron,
> but I find that unsatisfactory.)
pgAudit doesn't currently include filters by appl
On 2/6/24 10:11 AM, Ron Johnson wrote:
Currently, we use Object audit logging to capture all READ access to
columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE. (They are the
three columns have PII data.)
Using what audit software?
The problem is that the application legitimately read
I appreciate the reply.
We have an internal Satellite that we pull from the EPEL repo.
The Satellite Repos are refreshed daily by the IT department.
It seems then that the EPEL repo has not been refreshed.
I will check with my IT department.
Thanks again for your help.
On Mon, Feb 5, 2024 at 8:18
Currently, we use Object audit logging to capture all READ access to
columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE. (They are the three
columns have PII data.)
The problem is that the application legitimately reads these columns
thousands of times per day. Thus, the log fills up with mean
Am 06.02.24 um 00:32 schrieb David G. Johnston:
On Mon, Feb 5, 2024 at 4:09 PM David Gauthier
wrote:
I want the result to be just 2 recs, one for each dog.
My present goto link for this question:
https://harshitjain.home.blog/2019/06/17/postgresql-how-to-delete-duplicate-rows-in-pos
On Tue, 2024-02-06 at 00:26 +0530, veem v wrote:
> On Mon, 5 Feb 2024 at 17:52, Laurenz Albe wrote:
> > On Mon, 2024-02-05 at 03:09 +0530, veem v wrote:
> > > In postgresql, Is it possible to partition an existing nonpartitioned
> > > table having data
> > > already residing in it and indexes and
> On 5 Feb 2024, at 22:38, Максим Чистяков wrote:
>
> Is there a way to save the pre-master keys which are encrypted TLS handshake
> between PostgreSQL server and psql client due to a TLS handshake?
> For example, in a Chrome you can save those keys due to connecting through
> HTTPS with option
On Mon, Feb 5, 2024 at 9:54 PM Greg Sabino Mullane
wrote:
> The pg_stat_*_tables tables idx_* columns has accumulated usage since the
>> last time you started the postmaster.
>>
>
> Actually, those persist at restart - you can use
>
> select datname, stats_reset from pg_stat_database;
>
> to see
Is there a way to save the pre-master keys which are encrypted TLS
handshake between PostgreSQL server and psql client due to a TLS handshake?
For example, in a Chrome you can save those keys due to connecting through
HTTPS with option --ssl-key-log-file or an environment variable
SSLKEYLOGFILE (
h
Hi,
I use patroni version 3.2.1. There is a point that I do not understand in
the slots management with Patroni.
Patroni creates a slot automatically on primary node when there is a
standby attached, although this slot does not belong to the patroni
configuration.
How to prevent the automatic crea
15 matches
Mail list logo
