Home > mailing lists

Check Postgres DB open mode - Mailing list pgsql-admin

From	Goti
Subject	Check Postgres DB open mode
Date	July 14, 2022 07:13:46
Msg-id	CAOzfMupiY3kXE9zQ-V_9OLwbdCVn4g5vdHRuA4nSKNZriWzHBw@mail.gmail.com Whole thread Raw
Responses	Re: Check Postgres DB open mode Re: Check Postgres DB open mode
List	pgsql-admin

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

From: Ron
Date: 13 July 2022, 16:16:27
Subject: Re: [EXT] Improve "select count(*)" query - takes more than 30 mins for some large tables

From: Holger Jakobs
Date: 14 July 2022, 08:41:28
Subject: Re: Check Postgres DB open mode