Re: [Patch] ALTER SYSTEM READ ONLY

Michael Banck <michael.banck@credativ.de>

From: Michael Banck <michael.banck@credativ.de>

To: tushar <tushar.ahuja@enterprisedb.com>

Cc: Amul Sul <sulamul@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2020-06-26T06:45:53Z

Lists: pgsql-hackers

Hi,

On Wed, Jun 24, 2020 at 01:54:29PM +0530, tushar wrote:
> On 6/22/20 11:59 AM, Amul Sul wrote:
> > 2. Now skipping the startup checkpoint if the system is read-only mode, as
> > discussed [2].
> 
> I am not able to perform pg_checksums o/p after shutting down my server in
> read only  mode .
> 
> Steps -
> 
> 1.initdb (./initdb -k -D data)
> 2.start the server(./pg_ctl -D data start)
> 3.connect to psql (./psql postgres)
> 4.Fire query (alter system read only;)
> 5.shutdown the server(./pg_ctl -D data stop)
> 6.pg_checksums
> 
> [edb@tushar-ldap-docker bin]$ ./pg_checksums -D data
> pg_checksums: error: cluster must be shut down
> [edb@tushar-ldap-docker bin]$

What's the 'Database cluster state' from pg_controldata at this point?


Michael

-- 
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax:  +49 2166 9901-100
Email: michael.banck@credativ.de

credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer

Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz

Commits

Initialize variable to placate compiler.
- a030a0c5ccb1 15.0 landed
StartupXLOG: Don't repeatedly disable/enable local xlog insertion.
- 18e0913a4203 15.0 landed
StartupXLOG: Call CleanupAfterArchiveRecovery after XLogReportParameters.
- a75dbf7f9ee6 15.0 landed
Postpone some end-of-recovery operations related to allowing WAL.
- 811051c2e7af 15.0 landed
Refactor some end-of-recovery code out of StartupXLOG().
- 6df1543abfed 15.0 landed
Re-enable contrib/bloom's TAP tests.
- 7d1aa6bf1c27 15.0 cited
Remove unnecessary call to ReadCheckpointRecord().
- 1d919de5eb3f 15.0 cited
Allow for error or refusal while absorbing a ProcSignalBarrier.
- a3ed4d1efe9f 14.0 landed
Add comment to explain an unused function parameter
- 101f903e51f5 14.0 cited
Extend the ProcSignal mechanism to support barriers.
- 16a4e4aecd47 13.0 cited
At promotion, don't leave behind a partial segment on the old timeline.
- 7cbee7c0a1db 9.5.0 cited