Primary - Master :-
postgres=# select pg_is_in_recovery();
pg_is_in_recovery
-------------------
f
Standby - Slave :-
postgres=# select pg_is_in_recovery();
pg_is_in_recovery
-------------------
t
Subscribe to:
Post Comments (Atom)
-
I have installed the PostgreSQL-15 on my Linux machine Kindly use below link for the installation https://www.postgresql.org/download/linu...
-
Physical Backup:- pg_basebackup pg_basebackup is a simple but powerful utility provided by PostgreSQL to take online and consistent file ...
-
What is PostgreSQL WAL Archiving? Any transaction performed on the database is first written into a WAL file like redo logs in Oracle, the...
No comments:
Post a Comment