How to test replication without doing a failover

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: How to test replication without doing a failover
Date: 2022-11-10 14:59:20
Message-ID: CA+wokJ8FQ0c5NwhPL1Bv2_fcyndwZNEqoJFORnORvVRxSX+61w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

List

Very newbie here on PostgreSQL coming from an Oracle DBA background mostly

How do I test and confirm whether replication is working or not besides
depending on just running the SQL below?

select pg_is_in_recovery() ;

select * from pg_stat_replication ;

Is it possible to force/initiate a log transaction and see if that gets
replicated or not? I mean for example on Oracle we can do a switch logfile
and check if that log gets shipped across and applied on the standby, is
there something similar in PostgreSQL?
Maybe someone can refer me to an example if there is one somewhere?

Regards,
Ed

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Smith 2022-11-10 15:43:26 Re: How to test replication without doing a failover
Previous Message Ron 2022-11-10 14:00:22 Re: WAL Async Replication Question