SQL command in Slave Database - Monitor Replication

[Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx>]

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

Tel.: +44 (0)2380 386578

Email: alberto.olivares@xxxxxxxxxxxxxxxxxxxxx

Website: www.snowflakesoftware.com
Twitter: @sflakesoftware

Follow us on LinkedIn

Winner of IHS Jane's ATC Award - Enabling Technology

Read more

Registered in England & Wales. Registered Number: 4294244

-----------------------------------------------------------------------------------------

Winner of IHS Jane's ATC Award - Enabling Technology

Read more