> On Jan 25, 2023, at 14:21, Dirschel, Steve
> wrote:
> From my perspective "idle in transaction" isn't necessarily a problem
> (although I don't like seeing sessions sitting like that for a long time).
> The problem is when pg_stat_activity.backend_xmin is populated- that can
> prevent a
On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
The problem is users will connect using DBeaver and their sessions
will sit idle.
Idle is not a problem, "idle in transaction" is.
From my perspective "idle in transaction" isn't necessarily a problem
(although I don't like seeing sessions sitti
>> When I connect to the database through DBeaver with those 2 default
>> settings changed and find that session in pg_stat_activity column
>> xact_start is populated along with backend_xmin. Those get populated
>> just by logging in.
>As you found out in the log, the driver runs DbEaver run m
Dirschel, Steve schrieb am 25.01.2023 um 20:36:
When I connect to the database through DBeaver with those 2 default
settings changed and find that session in pg_stat_activity column
xact_start is populated along with backend_xmin. Those get
populated just by logging in.
As you found out in the
Not sure if anyone on this list may have ideas on this or not. I will also try
and find a DBeaver e-mail list and send to that also.
We are running into a problem where users will connect to a database through
DBeaver. I have found if I leave all DBeaver options as default this issue
does not
Hi!
Please be warned that this approach (if not exists create) is not thread safe,
even "create table if not exists" syntax is not thread safe too.
Im using this kind of "dynamic partitioning" and use Advisory locks to make
sure creating partitions is thread safe. Im using native partitioning, s
I'm creating partition tables on the fly following the technique described
in https://minervadb.com/index.php/postgresql-dynamic-partitioning/ .
Regardless of whether a partition table is created or already exists all I
really want to do is change the destination table (TG_TABLE_NAME?) of the
inser
Sorry for the confusion, I must have done some crazy stuff about the user
of pg_basebackup.
Please just consider the question:
* is there a way to tell pg_rewind to use the passfile?
Thanks!
On Wed, Jan 25, 2023 at 10:37 AM Wiwwo Staff wrote:
> Hi!
> I have noticed, if I use
> pg_basebackup -D
Hi!
I have noticed, if I use
pg_basebackup -D $PGDATA -h $NEW_PRIMARY -U $SOME_ADMIN_USER
(where $SOME_ADMIN_USER is a privileged user, not the replica user)
i got a "show primary_conninfo" as ;
user= passfile='/var/lib/postgresql/.pgpass'
channel_binding=prefer host=pg_red port=5432 sslmode=p
