@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
lxid | | | | | 1/1|
> | | | | 1/0| 17333 |
> ExclusiveLock | t | t
>
> (3 rows)
>
>
>
> postgresql=#
>
>
>
>
>
>
>
>
>
> *From: *SATYANARAYANA NARLAPURAM
>
ts.postgresql.org
Subject: [Ext:] Re: Stream Replication not working
[External Email]
Seems there is a problem with the replay on your standby. Either it is too slow
or stuck behind some locks ( replay_lag of 20:38:47.00904 indicates this and
the flush_lsn is the same as lsn on primary ) . Run pg_lock
Seems there is a problem with the replay on your standby. Either it is too
slow or stuck behind some locks ( replay_lag of 20:38:47.00904 indicates
this and the flush_lsn is the same as lsn on primary ) . Run pg_locks to
see if the replay is stuck behind a lock.
On Mon, Jan 10, 2022 at 11:53 AM
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
