@gmail.com , satyanarlapu...@gmail.com
, pgsql-hackers@lists.postgresql.org
Subject: Re: [Ext:] Re: Stream Replication not working
Hi.
At Tue, 11 Jan 2022 15:05:55 +, Allie Crawford
wrote in
> er it. How do I figure out which database and relation is db:16384
> and relation:12141.?
Hi.
At Tue, 11 Jan 2022 15:05:55 +, Allie Crawford
wrote in
> er it. How do I figure out which database and relation is db:16384
> and relation:12141.?
On any database,
select datname from pg_database where oid = 16384;
Then on the shown database,
select relname from pg_class where oid
, 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
,
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
On Tue, Jan 11, 2022 at 2:12 AM Allie Crawford
wrote:
>
> Thank you so much for your help on this Satya. I have detailed right below
> the output of the query you asked me to run.
>
>
>
> Master
>
> postgresql@ ~>psql
>
> psql (13.5)
>
> Type "help" for help.
>
>
>
> postgresql=# select * from pg
Hi All,
for us also, logs are applying at slave server but very very slow. While
checking we also have seen same set of locks to Master and Slave servers.
Please suggest the solution for that.
Many Thanks in Advance !!
Thanks
On Tue, Jan 11, 2022 at 2:12 AM Allie Crawford <
crawfor...@churchofjes
Thank you so much for your help on this Satya. I have detailed right below the
output of the query you asked me to run.
Master
postgresql@ ~>psql
psql (13.5)
Type "help" for help.
postgresql=# select * from pg_locks;
locktype | database | relation | page | tuple | virtualxid | transacti
