Re: Logical Replication 08P01 invalid memory alloc request size 1095736448

2025-07-06 Thread Soni M
Thanks Tom, really appreciate it. On Sun, Jul 6, 2025 at 10:12 PM Tom Lane wrote: > Soni M writes: > > We just do patch updates from 15.12 to 15.13, restart Logical Master and > > then Logical Replica, and suddenly Logical replication stops working. > > Streaming replica

Re: Logical Replication 08P01 invalid memory alloc request size 1095736448

2025-07-06 Thread Soni M
m_exit callbacks to make",,,,,"","logical replication worker",,0 DEBUG,0,"proc_exit(1): 1 callbacks to make","","logical replication worker",,0 DEBUG,0,"exit(1)","","logical replication worke

Logical Replication 08P01 invalid memory alloc request size 1095736448

2025-07-06 Thread Soni M
Hello All, we have this set up : Postgres 15.13 on RHEL 9.6 Logical Master also have 2 streaming replica Logical Replica also have 1 streaming replica We just do patch updates from 15.12 to 15.13, restart Logical Master and then Logical Replica, and suddenly Logical replication stops working. Str

Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

2021-01-15 Thread Soni M
Fix it already, so it was the SAN and vmware issue. Thanks Everyone. On Fri, Jan 15, 2021 at 4:40 PM Soni M wrote: > More disk space now available, but still the error happens and postgres > won't start. > I think it could be corrupted shared buffers, as stated on the log &

Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

2021-01-15 Thread Soni M
13 +0700, Soni M wrote: > > We filled out the wal archive disk, and then those messages appear > > > > [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": > Input/output error" > > > > And now I cannot start postgres > >

could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

2021-01-15 Thread Soni M
Hi All, Postgres 11 on RHEL 7.9 We filled out the wal archive disk, and then those messages appear 2021-01-15 01:18:47.284 CST,"replicator","consprod",3510,"[local]",5fdebf22.db6,21,"SELECT",2020-12-19 21:04:02 CST,35/46792889,437317854,PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": I

Encrypted connection SQL server fdw

2020-01-10 Thread Soni M
Hi All, currently I'm trying to configure postgres (on centos) to load data from MS SQL server (on windows server) on an encrypted connection. Trying with tds_fdw, but found that it doesn't support encrypted connection. Is there any solution to this? Thanks, Soni.