Dear Max,
Thanks for the report.
> The initial snapshot and data copy complete successfully for all tables.
> However, anywhere from 5
> minutes to 2 hours after the initial sync, the subscription consistently
> fails with memory allocation errors like:
>
> ```
> 2025-06-10 14:14:56.800 UTC [29
Logan Grosz writes:
> I have a `DOMAIN` on `JSONB`. I need to verify the shape of the JSON, so I
> have a check expression written in PL/pgSQL. The docs say
>> Each constraint must be an expression producing a Boolean result
> Would it be correct to raise an exception to indicate a failed
> chec
On Tue, Jun 10, 2025 at 4:53 PM Logan Grosz wrote:
> Hi,
>
> I have a `DOMAIN` on `JSONB`. I need to verify the shape of the JSON, so I
> have a check expression written in PL/pgSQL. The docs say
>
> > Each constraint must be an expression producing a Boolean result
>
> Would it be correct to rai
Hi,
I have a `DOMAIN` on `JSONB`. I need to verify the shape of the JSON, so I
have a check expression written in PL/pgSQL. The docs say
> Each constraint must be an expression producing a Boolean result
Would it be correct to raise an exception to indicate a failed check? I
perform type-casts (
On 6/10/25 13:14, Adrian Klaver wrote:
On 6/10/25 13:01, Jim Cunning wrote:
I had a Ubuntu 20.04 LTS system with a postgresql version 10 database,
and the system became unbootable. The database was stored in
/var/lib/postgresql/10/main and I was able to recover the entire
contents of the data
On Tue, Jun 10, 2025 at 1:01 PM Jim Cunning wrote:
> I obviously no longer have a running version 10 server,
>
You will need to correct this lack if you want to make use of version 10
data files.
David J.
On 6/10/25 13:01, Jim Cunning wrote:
I had a Ubuntu 20.04 LTS system with a postgresql version 10 database,
and the system became unbootable. The database was stored in
/var/lib/postgresql/10/main and I was able to recover the entire
contents of the data in that directory and below. I now hav
I had a Ubuntu 20.04 LTS system with a postgresql version 10
database, and the system became unbootable. The database was stored
in /var/lib/postgresql/10/main and I was able to recover the entire
contents of the data in that directory and below. I now have a
system ru
On 6/10/25 08:46, Dominique Devienne wrote:
On Tue, Jun 10, 2025 at 4:27 PM Tom Lane wrote:
Dominique Devienne writes:
So when and how fast does pg_stat_activity update, in the face of a
PQfinish?
The shared state underlying pg_stat_activity is updated
immediately when something changes. H
On Tue, Jun 10, 2025 at 4:27 PM Tom Lane wrote:
> Dominique Devienne writes:
> > So when and how fast does pg_stat_activity update, in the face of a
> > PQfinish?
>
> The shared state underlying pg_stat_activity is updated
> immediately when something changes. However ...
>
> PQfinish is asynchr
Hello,
I'm encountering a consistent issue with PostgreSQL 15 logical replication
and would appreciate any guidance on debugging or resolving this problem.
*Setup:*
- Source: PostgreSQL 15.x
- Target: PostgreSQL 15.x
- Replication: Logical replication using publication/subscription (pgoutput)
- T
Dominique Devienne writes:
> So when and how fast does pg_stat_activity update, in the face of a
> PQfinish?
The shared state underlying pg_stat_activity is updated
immediately when something changes. However ...
PQfinish is asynchronous: it sends a "goodbye" message and then
closes the connect
Hi. We're getting unit-test failures that look like data-races,
which somehow are getting very frequent recently, tripping our CI.
Basically we have a `services` table, for service discovery, which
records the backend PID of its main DB Connection. Such that we can
account for "stale" / "zombie"
On Tue, 2025-06-10 at 10:02 +0200, Dominique Devienne wrote:
> On Thu, Jun 5, 2025 at 1:06 AM Tom Lane wrote:
> > > Provide a client connection option (and/or implement the backend support)
> > > to allow only one statement in an execute request
> >
> > This exists already; you just have to use
On Thu, Jun 5, 2025 at 1:06 AM Tom Lane wrote:
> > Provide a client connection option (and/or implement the backend support)
> > to allow only one statement in an execute request
>
> This exists already; you just have to use the extended query protocol.
Hi Tom. Can you be more specific please?
I
15 matches
Mail list logo
