On 1/23/25 19:46, anlex N wrote:
Hello Adrian, Laurenz. Have you tried postgresql's json in your everyday
life? How fast is it? how is it than mongodb?
To get the answers you want it would be better to describe what you are
trying to achieve by using JSON.
On Thu, Jan 16, 2025 at 6:57 PM A
Hello Adrian, Laurenz. Have you tried postgresql's json in your everyday
life? How fast is it? how is it than mongodb?
On Thu, Jan 16, 2025 at 6:57 PM Adrian Klaver
wrote:
> On 1/16/25 04:25, anlex N wrote:
> > I have searched all archives, but have no results. Please help me.
>
> Consistency of
Thanks for the correction Adrian - my oversimplification went too far, and
into "plain wrong" territory.
(The detail that I felt was too much for this explanation was: "and the way
to simply get rid of them would be to set your archive command to
'/bin/true', say".. but didn't want to make it seem
On 1/23/25 10:21, Durgamahesh Manne wrote:
At subscription side
getting this error repeatedly So Do we have any solution without resync
full data again from scratch
* |2025-01-23 18:11:46 UTC::@:[507]:DEBUG: logical replication did not
find row to be updated in replication target relat
On 1/23/25 09:54, Durgamahesh Manne wrote:
See comments in line below.
Source Publication Side:
archiving=> select * from pg_stat_replication;
There is missing information here.
Am I right in assuming this is for slot cls_eva_msa?
And that it going to same client_addr 10.80.0.168?
cl
On Thu, Jan 23, 2025 at 11:24 PM Durgamahesh Manne <
maheshpostgr...@gmail.com> wrote:
>
>
> On Thu, Jan 23, 2025 at 10:08 PM Adrian Klaver
> wrote:
>
>> On 1/22/25 18:53, Durgamahesh Manne wrote:
>> >
>> >
>> >
>>
>> > > But records count varies with difference of more than 10 thousand
>> >
>>
On Thu, Jan 23, 2025 at 10:08 PM Adrian Klaver
wrote:
> On 1/22/25 18:53, Durgamahesh Manne wrote:
> >
> >
> >
>
> > > But records count varies with difference of more than 10 thousand
> >
> > Have you looked at the I/0 statistics between the Postgres instances?
> >
> > Seems everything looks go
On 1/22/25 18:53, Durgamahesh Manne wrote:
> But records count varies with difference of more than 10 thousand
Have you looked at the I/0 statistics between the Postgres instances?
Seems everything looks good with pg replication slots
Except the subscriber is lagging behind the publish
On 1/23/25 06:51, Saul Perdomo wrote:
This is why everybody will tell you "don't just delete these files,
archive them properly!" Again, for operational purposes, you could just
delete them. But you really want to make a /copy /of them before you
do... you know, /just in case /something bad ha
