Hello community,
actually I have a problem wit PG13 on Windows 10 (both x64), Postgres
version is 13.0.2.21090 from EDB installer.
I have to develop a logical replication cluster, where sometimes there
happens a shutdown of one host. Logical replication works nice, thank
you for that.
My i
> Is there a way to avoid this (without restarting the service after every
> reboot). Is this a bug or a normal behavior?
>
I have less knowledge of windows.
https://www.enterprisedb.com/blog/postgresql-shutdown
Do you see shutdown/termination messages in the db logs or windows event
logs when
select pg_stat_reset();
Can you run above function, to check if stats are reset and things are fine
without a pg restart?
I not able to understand how new connection stats are added, along with old
stale states, if I assume stats collector process is having issues , or the
stats folder is corrupt
Hello Vijaykumar Jain,
thank you for fast answer, today I'm not able to access the hardware,
I'll be back tomorrow and will do the required tests.
Wolfgang
Am 21.07.2021 um 15:14 schrieb Vijaykumar Jain:
select pg_stat_reset();
Can you run above function, to check if stats are reset and thi
Hello,
Would you be able to verify the process trees for those PIDs on Windows?
You may be able to see who holds the connections?
Regards,
Ninad Shah
On Wed, 21 Jul 2021 at 19:15, WR wrote:
> Hello Vijaykumar Jain,
>
> thank you for fast answer, today I'm not able to access the hardware,
> I'
Thanks all, I'll try this on Monday when I go back to the office.
Nicolas.
‐‐‐ Original Message ‐‐‐
On Wednesday, July 21st, 2021 at 02:55, Rob Sargent
wrote:
> > Query:
> >
> > INSERT INTO invl_aml_mapping_temp(invl_id, aml_id, cond)
> >
> > SELECT il.id, ml.id, 48
>
