Re: [Ext:] Re: Stream Replication not working

2022-01-18 Thread Allie Crawford
postgresql=# select relname from pg_class where oid = 12141; relname -- pg_locks (1 row) postgresql=# Have a great week everyone. Regards, Allie From: Kyotaro Horiguchi Date: Tuesday, January 11, 2022 at 6:18 PM To: Allie Crawford Cc: sushant.postg...@gmail.com , amit.kapil...

Re: [Ext:] Re: Stream Replication not working

2022-01-11 Thread Allie Crawford
, January 11, 2022 at 6:28 AM To: Allie Crawford Cc: SATYANARAYANA NARLAPURAM , pgsql-hackers@lists.postgresql.org Subject: Re: [Ext:] Re: Stream Replication not working It seems both master and standby have an exclusive lock on db:16384 and relation:12141. Which is this database/relation and why is

Re: [Ext:] Re: Stream Replication not working

2022-01-11 Thread Allie Crawford
, Allie From: Sushant Postgres Date: Tuesday, January 11, 2022 at 12:49 AM To: Allie Crawford Cc: SATYANARAYANA NARLAPURAM , pgsql-hackers@lists.postgresql.org Subject: Re: [Ext:] Re: Stream Replication not working Hi All, for us also, logs are applying at slave server but very very slow. While

Re: [Ext:] Re: Stream Replication not working

2022-01-10 Thread Allie Crawford
| t | t virtualxid | | | | | 1/1| | | | | 1/0| 17333 | ExclusiveLock | t | t (3 rows) postgresql=# From: SATYANARAYANA NARLAPURAM Date: Monday, January 10, 2022 at 1:06 PM To: Allie Crawford Cc: pgsql-hackers@lis

Stream Replication not working

2022-01-10 Thread Allie Crawford
Hi All, I have implemented Stream replication in one of my environments, and for some reason even though all the health checks are showing that the replication is working, when I run manual tests to see if changes are being replicated, the changes are not replicated to the standby postgresql env