| From: | Alberto Olivares <alberto(dot)olivares(at)snowflakesoftware(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | SQL command in Slave Database - Monitor Replication |
| Date: | 2015-07-03 15:03:23 |
| Message-ID: | CAGdoAzi4HOLAFFy-5VzRRsWfnxhvCYQatufOyZ86HTEyKUyTAg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)olivares(at)snowflakesoftware(dot)com
Website: www.snowflakesoftware.com
Twitter: @sflakesoftware <http://www,twitter(dot)com(at)sflakesoftware/>
Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software>
*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*
Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------
--
*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matheus de Oliveira | 2015-07-04 14:37:11 | Re: SQL command in Slave Database - Monitor Replication |
| Previous Message | Kiswono Prayogo | 2015-07-03 13:19:04 | Re: PostgreSQL doesn't log |