Postgres Pro
Downloads
Home   >   mailing lists

SQL command in Slave Database - Monitor Replication - Mailing list pgsql-admin

From Alberto Olivares
Subject SQL command in Slave Database - Monitor Replication
Date
Msg-id CAGdoAzi4HOLAFFy-5VzRRsWfnxhvCYQatufOyZ86HTEyKUyTAg@mail.gmail.com
Whole thread Raw
Responses Re: SQL command in Slave Database - Monitor Replication
List pgsql-admin
Tree view
Hi all,

Is there any SQL command that I can run on the slave database to check if the replication is still working or not? I know that you can check the postgresql.conf but I want to do it directly on the SQL panel.

Database:  Postgresql 9.1 on Linux

Thanks for your answers.

Regards,
Alberto.

Alberto Olivares Colas
Technical Consultant
Snowflake Software



Winner of IHS Jane's ATC Award - Enabling Technology

Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------




Winner of IHS Jane's ATC Award - Enabling Technology

pgsql-admin by date:

Previous
From: Kiswono Prayogo
Date:
Subject: Re: PostgreSQL doesn't log
Next
From: Matheus de Oliveira
Date:
Subject: Re: SQL command in Slave Database - Monitor Replication