There is a three-day vacuum freeze on a partition table with wait_event =
BufferPin, no transactions (active or idle) older than it that are not blocked,
but at least one select query is executing at all times related of this
partition table.
This behaviour happens with some partitions, but n
Hello,
I am having the following issue below. Please, I need help to fix it.
[image: User]
*ERROR: could not access status of transaction 756525298*
*Could not open file "pg_xact/02C8": No such file or directory.*
Thank You
Johnathan T
Hi All,
I am trying to fetch the list of tables that have cascade constraints
enabled. Can someone help me with the query related to this?
Regards,
Satalabha
On Wednesday, January 31, 2024, Satalabaha Postgres <
satalabaha.postg...@gmail.com> wrote:
>
> I am trying to fetch the list of tables that have cascade constraints
> enabled. Can someone help me with the query related to this?
>
>
https://www.postgresql.org/docs/current/catalog-pg-constraint.ht
Hi,
We are facing issue while trying to connect securely(ssl) from postgres c
client(libpq) with postgresql server.
We have compiled postgreClient 14.9(postgresql-14.9.tar.gz) using OpenSSL
version 3.2.0.
Backtrace of the issue is mentioned below :
#0 0x009a71f8 in _shi_r
On Wednesday, January 31, 2024, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
>
> We also find similar type of issues on internet and one link from postgres
> website as well.
>
>
>
> https://www.postgresql.org/message-id/cx9su44gh3p4.17x6zzuj5d...@neon.tech
>
> NOTE: When compiles postg
On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> I am having the following issue below. Please, I need help to fix it.
>
> ERROR: could not access status of transaction 756525298
> Could not open file "pg_xact/02C8": No such file or directory.
That is data corruption, and you shoul
session 1:
create temp table ttt ( a int );
insert into ttt values(3); -- query_id is XXX from
pg_stat_activity
session 2:
create temp table ttt ( a int );
insert into ttt values(3);-- query_id is YYY from
pg_stat_activity
I know temp table h
