Re: Check Postgres DB open mode

Holger Jakobs <holger@xxxxxxxxxx> · Thu, 14 Jul 2022 07:41:28 +0200



    Am 14.07.22 um 06:13 schrieb Goti:

    
        Hi
          Listers,
        

        I am new
          to postgres and would like to know how to check whether the DB
          is opened in read write mode or read-only mode.
        

            Thanks,
              

              Goti
            
          
    Hi Goti,
    The PostgreSQL database isn't
        "opened", but the clients connect to it.
    Whether the connection is
        read-only can be found out by executing the command
        show transaction_read_only
    Unless you are connected to a
        standby server, connections will be read-write.
    Regards,
    Holger

      
    -- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature