Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql api

postgresql api

From
vyshu Ysh
Date:
Hi Team,

Is there any postgresql API which tells when the master/standby server is down ?

Thanks,
Sudha

Re: postgresql api

From
Enrico Pirozzi
Date:
Hi, 
Have you tried to query the pg_stat_replication?

Enrico

Il lun 17 set 2018, 11:52 vyshu Ysh <sudha.2114@gmail.com> ha scritto:
Hi Team,

Is there any postgresql API which tells when the master/standby server is down ?

Thanks,
Sudha

Re: postgresql api

From
vyshu Ysh
Date:
Hi,

I wanted to query from my c# application. Am using npgsql, is there any parameter or api ? 

On Mon, 17 Sep 2018, 5:22 pm Enrico Pirozzi, <sscotty71@gmail.com> wrote:
Hi, 
Have you tried to query the pg_stat_replication?

Enrico

Il lun 17 set 2018, 11:52 vyshu Ysh <sudha.2114@gmail.com> ha scritto:
Hi Team,

Is there any postgresql API which tells when the master/standby server is down ?

Thanks,
Sudha

Re: postgresql api

From
Raymond O'Donnell
Date:
On 17/09/18 13:31, vyshu Ysh wrote:
> Hi,
> 
> I wanted to query from my c# application. Am using npgsql, is there any 
> parameter or api ?

select * from pg_stat_replication;

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie