Re: Check Postgres DB open mode

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 14 Jul 2022 07:01:07 -0500



    On 7/13/22 23:13, Goti wrote:

    
        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.
      
    
    Pedantically, databases are not opened; the postmaster
    is running or not.  We of course colloquially say that "the
    database is open" when the postmaster is running.

    
    Locally, you can run the command "pg_ctl status", and systemctl
    probably also has a status option.

    
    -- 

      Angular momentum makes the world go 'round.