Re: tell master to tell it's the master - ?

lejeczek <peljasz@xxxxxxxxxxx> · Fri, 18 Aug 2023 13:06:58 +0200



    On 18/08/2023 11:34, Emile Amewoto
      wrote:

    
      Hi Lejeczek,
      What are you using to control your cluster?
      If you are using patroni, you can use regex to grep the
        Leader or if you are not using any cluster manager you can do:
      

        SELECT Count(pid)) 
                  FROM pg_stat_activity WHERE wait_event IS NOT
          NULL AND backend_type = ‘walsender'
        The master will always have walsender process and the
          standby walreiver
        

        Regards,
        Emile
        

            On 18 Aug 2023, at 11:07, lejeczek
              <peljasz@xxxxxxxxxxx> wrote:
            

               Hi
                    guys.

                    
                    Is it possible to configure pgSQL to announce it's
                    being a master and not querying it?

                    I was hoping for a file whose existence or content
                    would confirm that and would be generated/created by
                    pqSQL itself - am I too naive?

                    
                    many thanks, L.

                   
    Hi, thanks for the tip.

    I'm looking at what I wrote - perhaps I was bit vague -  ... it's being a master by
        not querying it & via means of config/uration instead - is
        what wanted to ask.