On Friday, November 20, 2020, Paul Förster wrote:
> Hi David,
>
> > On 20. Nov, 2020, at 10:34, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
> >
> >
> > On Friday, November 20, 2020, Paul Förster
> wrote:
> >
> > > On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
> >
> > >
> > >
Ok, Thanks!
Raul
Kontakt Paul Förster () kirjutas kuupäeval R, 20.
november 2020 kell 12:54:
> Hi Raul,
>
> > On 20. Nov, 2020, at 11:45, Raul Kaubi wrote:
> >
> > Hmm, ok.
> >
> > But how is this possible..?
> >
> > when b.sender>0 and c.receiver>0 then
> > 'Primary+Replica'
> >
>
Hi Raul,
> On 20. Nov, 2020, at 11:45, Raul Kaubi wrote:
>
> Hmm, ok.
>
> But how is this possible..?
>
> when b.sender>0 and c.receiver>0 then
> 'Primary+Replica'
>
> Raul
this happens for example if you have a primary a and replica b running as a
normal cluster (we use Patron
Hmm, ok.
But how is this possible..?
when b.sender>0 and c.receiver>0 then
> 'Primary+Replica'
Raul
Kontakt Paul Förster () kirjutas kuupäeval R, 20.
november 2020 kell 12:04:
> Hi Raul,
>
> > On 20. Nov, 2020, at 10:41, Raul Kaubi wrote:
> >
> > Hi
> >
> > Thanks.
> > Seems lik
Hi Raul,
> On 20. Nov, 2020, at 10:41, Raul Kaubi wrote:
>
> Hi
>
> Thanks.
> Seems like 9.5 does not work.
>
> ERROR: relation "pg_stat_wal_receiver" does not exist
> LINE 20: from pg_stat_wal_receiver
>
> Any ide how to achieve this in 9.5 ?
>
> Raul
this query is tested to work
Hi David,
> On 20. Nov, 2020, at 10:34, David G. Johnston
> wrote:
>
>
> On Friday, November 20, 2020, Paul Förster wrote:
>
> > On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> >
> > select pg_is_in_recovery();
>
> I usually don't recommend using pg_is_in_recovery() only because
Hi
Thanks.
Seems like 9.5 does not work.
ERROR: relation "pg_stat_wal_receiver" does not exist
> LINE 20: from pg_stat_wal_receiver
Any ide how to achieve this in 9.5 ?
Raul
Kontakt Paul Förster () kirjutas kuupäeval R, 20.
november 2020 kell 11:29:
> Hi Thomas,
>
> > On 20. Nov, 20
On Friday, November 20, 2020, Paul Förster wrote:
>
>
> > On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> >
> > select pg_is_in_recovery();
>
> I usually don't recommend using pg_is_in_recovery() only because a
> database cluster can be in recovery for other reasons. This is why I always
Hi Thomas,
> On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> Raul Kaubi schrieb am 20.11.2020 um 09:53:
>> CentOS 7
>> Postgres 9 to 12
>>
>> For monitoring purpose, I would like that certain scripts are only run in
>> primary server.
>> So I am looking ways to universally discover if p
Raul Kaubi schrieb am 20.11.2020 um 09:53:
> CentOS 7
> Postgres 9 to 12
>
> For monitoring purpose, I would like that certain scripts are only run in
> primary server.
> So I am looking ways to universally discover if postgresql cluster that is
> running is primary or not.
As the standby will b
10 matches
Mail list logo
