Re: [Patch] ALTER SYSTEM READ ONLY

From:	Amul Sul <sulamul(at)gmail(dot)com>
To:	Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:	Michael Paquier <michael(at)paquier(dot)xyz>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: [Patch] ALTER SYSTEM READ ONLY
Date:	2020-07-14 06:37:28
Message-ID:	CAAJ_b9793K85h-YGhufcEP=Sk0V6toZek2eu1wOsE4ac3O1qbA@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-06-16 13:55:40 from amul sul <sulamul(at)gmail(dot)com> 📎  2020-06-17 13:02:12 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2020-06-17 14:41:55 from Robert Haas <robertmhaas(at)gmail(dot)com>    2020-06-18 04:08:56 from amul sul <sulamul(at)gmail(dot)com>    2020-06-18 09:55:10 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2020-06-18 11:18:51 from amul sul <sulamul(at)gmail(dot)com>      2020-06-18 14:54:22 from Robert Haas <robertmhaas(at)gmail(dot)com>       2020-07-24 00:58:18 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>        2020-07-24 05:13:54 from Amul Sul <sulamul(at)gmail(dot)com>         2020-07-24 17:10:19 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>          2020-07-29 11:05:08 from Amul Sul <sulamul(at)gmail(dot)com>     2020-06-18 14:52:49 from Robert Haas <robertmhaas(at)gmail(dot)com>      2020-06-18 15:08:38 from Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>       2020-06-18 15:23:41 from Robert Haas <robertmhaas(at)gmail(dot)com>      2020-06-19 03:58:53 from amul sul <sulamul(at)gmail(dot)com>       2020-06-22 06:29:09 from Amul Sul <sulamul(at)gmail(dot)com> 📎        2020-06-24 08:24:29 from tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>         2020-06-26 04:41:41 from Amul Sul <sulamul(at)gmail(dot)com>          2020-06-26 09:59:21 from Michael Paquier <michael(at)paquier(dot)xyz>           2020-06-26 12:46:41 from Robert Haas <robertmhaas(at)gmail(dot)com>            2020-07-14 06:37:28 from Amul Sul <sulamul(at)gmail(dot)com> 📎             2020-07-16 06:11:54 from Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>              2020-07-16 13:10:45 from Robert Haas <robertmhaas(at)gmail(dot)com>               2020-07-22 22:03:15 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>                2020-07-22 23:03:57 from SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>                 2020-07-23 10:43:14 from Amul Sul <sulamul(at)gmail(dot)com>                2020-07-23 10:41:45 from Amul Sul <sulamul(at)gmail(dot)com>                 2020-07-23 16:10:41 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>                  2020-07-24 14:33:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2020-07-24 19:11:47 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>                2020-07-24 14:31:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2020-07-24 19:11:43 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>                  2020-07-29 16:09:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2020-08-19 10:28:15 from Amul Sul <sulamul(at)gmail(dot)com> 📎                    2020-08-28 19:53:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2020-09-01 11:13:10 from Amul Sul <sulamul(at)gmail(dot)com> 📎                      2020-09-09 21:03:42 from Andres Freund <andres(at)anarazel(dot)de>                       2020-09-12 05:22:38 from Amul Sul <sulamul(at)gmail(dot)com>                        2020-09-15 09:05:39 from Amul Sul <sulamul(at)gmail(dot)com> 📎                         2020-09-23 06:04:41 from Amul Sul <sulamul(at)gmail(dot)com> 📎                          2020-09-28 12:29:41 from Amul Sul <sulamul(at)gmail(dot)com> 📎                        2020-12-09 21:13:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2020-12-10 00:34:28 from Andres Freund <andres(at)anarazel(dot)de>                          2020-12-14 05:58:38 from Amul Sul <sulamul(at)gmail(dot)com>                           2020-12-14 14:33:32 from Amul Sul <sulamul(at)gmail(dot)com>                            2021-01-14 11:29:14 from Amul Sul <sulamul(at)gmail(dot)com> 📎                             2021-01-18 18:02:39 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2021-01-19 20:45:03 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2021-01-21 14:46:46 from Amul Sul <sulamul(at)gmail(dot)com> 📎                               2021-01-25 21:07:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2021-01-28 12:16:28 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                 2021-02-16 22:11:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2021-02-17 02:20:26 from Andres Freund <andres(at)anarazel(dot)de>                                   2021-02-19 12:13:08 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                    2021-02-26 11:40:34 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                    2021-03-02 12:22:23 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                     2021-03-02 14:24:15 from Amul Sul <sulamul(at)gmail(dot)com>                                      2021-03-02 15:31:41 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                       2021-03-03 06:37:53 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                        2021-03-03 11:20:19 from Amul Sul <sulamul(at)gmail(dot)com>                                         2021-03-03 14:26:06 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                          2021-03-04 17:51:32 from Amul Sul <sulamul(at)gmail(dot)com>                                     2021-03-03 15:26:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                                      2021-03-04 17:32:27 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                       2021-03-09 10:30:30 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                        2021-03-14 18:21:02 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com> 📎                                         2021-03-15 07:25:42 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                          2021-03-15 12:15:22 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                          2021-03-19 13:46:55 from Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>                                           2021-03-22 06:43:43 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                            2021-04-05 05:31:16 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                             2021-04-05 11:15:32 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                              2021-04-05 11:57:17 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                               2021-04-07 07:08:23 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                2021-04-12 14:04:15 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                 2021-05-06 19:52:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                  2021-05-09 05:26:07 from Amul Sul <sulamul(at)gmail(dot)com>                                                   2021-05-10 15:51:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                    2021-05-10 16:55:14 from Amul Sul <sulamul(at)gmail(dot)com>                                                     2021-05-11 06:02:43 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                      2021-05-11 08:45:32 from Amul Sul <sulamul(at)gmail(dot)com>                                                       2021-05-11 08:56:19 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                        2021-05-11 10:08:18 from Amul Sul <sulamul(at)gmail(dot)com>                                                         2021-05-11 10:42:53 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                          2021-05-11 11:19:54 from Amul Sul <sulamul(at)gmail(dot)com>                                                           2021-05-11 13:17:44 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                            2021-05-11 13:26:22 from Amul Sul <sulamul(at)gmail(dot)com>                                                             2021-05-11 14:19:53 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                              2021-05-11 15:17:32 from Amul Sul <sulamul(at)gmail(dot)com>                                                               2021-05-11 18:24:25 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                2021-05-12 05:38:53 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                 2021-05-12 12:25:08 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                  2021-05-13 07:06:28 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                   2021-05-13 09:24:04 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                    2021-05-13 09:26:29 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                     2021-05-15 09:42:15 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                      2021-05-17 06:17:28 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                       2021-05-17 07:36:58 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                        2021-06-17 05:22:27 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                         2021-07-23 20:03:25 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                                                          2021-07-27 20:55:52 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                           2021-07-28 11:07:01 from Amul Sul <sulamul(at)gmail(dot)com>                                                                            2021-07-28 11:32:33 from Amul Sul <sulamul(at)gmail(dot)com>                                                                             2021-07-29 11:17:09 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                                              2021-07-29 11:52:21 from Amul Sul <sulamul(at)gmail(dot)com>                                                                             2021-07-29 16:16:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                              2021-07-30 09:37:37 from Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> 📎                                                                              2021-08-04 12:56:30 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                               2021-08-31 12:15:40 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                2021-09-02 15:47:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                2021-09-07 15:13:52 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                 2021-09-07 16:32:32 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                  2021-09-08 13:44:54 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                   2021-09-09 17:42:11 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                    2021-09-09 18:21:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                     2021-09-09 18:49:34 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                    2021-09-10 14:36:30 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                     2021-09-10 15:42:09 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                      2021-09-10 16:20:38 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                       2021-09-10 16:56:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                        2021-09-10 17:16:48 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                         2021-09-10 17:48:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                     2021-09-22 12:48:30 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                          2021-09-15 10:49:17 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                           2021-09-15 14:32:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                            2021-09-15 16:08:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                             2021-09-20 15:19:50 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                              2021-09-23 18:26:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                               2021-09-24 11:37:42 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                2021-09-30 11:58:24 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                 2021-09-30 20:59:18 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                  2021-10-04 08:27:01 from Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>                                                                                   2021-10-05 10:41:58 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                    2021-10-07 00:26:51 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>                                                                                     2021-10-07 12:51:44 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                      2021-10-12 12:17:22 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                       2021-10-14 17:40:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                        2021-10-18 13:54:13 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                         2021-10-18 22:20:34 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                                                                          2021-10-25 07:04:23 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                           2021-10-25 14:45:21 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                            2021-10-25 19:14:44 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                                                                             2021-10-25 20:31:59 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                              2021-10-25 20:35:28 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                                                                            2021-10-26 10:59:55 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                             2021-11-08 13:20:01 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                              2021-11-12 20:48:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                               2021-11-17 05:43:32 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                                2021-11-17 10:37:15 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                                 2021-11-17 12:50:42 from Amul Sul <sulamul(at)gmail(dot)com>                                                                                                  2021-11-23 13:53:22 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                                   2021-11-26 12:59:25 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                                    2021-12-01 04:59:15 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                                     2022-04-08 14:27:03 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                                                      2022-07-27 22:35:44 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                                                       2022-07-28 03:45:05 from Amul Sul <sulamul(at)gmail(dot)com>                                                                 2021-05-12 20:56:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                  2021-05-13 06:02:20 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                          2022-04-23 08:03:56 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                           2022-04-26 12:43:18 from Amul Sul <sulamul(at)gmail(dot)com>                                      2021-03-08 11:06:27 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                     2020-09-08 18:20:05 from Andres Freund <andres(at)anarazel(dot)de>                      2020-09-16 19:33:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2020-10-07 17:48:49 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                        2020-10-08 10:22:58 from Amul Sul <sulamul(at)gmail(dot)com>                         2020-10-28 11:43:38 from Amul Sul <sulamul(at)gmail(dot)com> 📎                         2020-11-20 16:23:44 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2020-11-20 17:43:22 from Amul Sul <sulamul(at)gmail(dot)com>                           2020-11-23 06:36:45 from Amul Sul <sulamul(at)gmail(dot)com> 📎                          2020-12-09 23:16:10 from Andres Freund <andres(at)anarazel(dot)de>             2020-07-24 02:04:02 from Andres Freund <andres(at)anarazel(dot)de>              2020-07-24 13:09:14 from Amul Sul <sulamul(at)gmail(dot)com>              2020-07-24 14:35:32 from Robert Haas <robertmhaas(at)gmail(dot)com>               2020-07-29 10:35:00 from Amul Sul <sulamul(at)gmail(dot)com> 📎         2020-06-26 06:45:53 from Michael Banck <michael(dot)banck(at)credativ(dot)de>          2020-06-26 10:39:47 from Amul Sul <sulamul(at)gmail(dot)com>   2020-06-17 14:58:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2020-06-17 16:07:22 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-06-17 16:27:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2020-06-17 16:34:53 from Robert Haas <robertmhaas(at)gmail(dot)com>       2020-06-17 16:45:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2020-06-17 17:26:18 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-06-17 18:05:46 from Andres Freund <andres(at)anarazel(dot)de>     2020-06-18 10:35:03 from Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>     2020-06-18 10:56:06 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>  2020-06-17 13:51:18 from tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>   2020-06-17 14:45:44 from Robert Haas <robertmhaas(at)gmail(dot)com>    2020-06-18 04:19:45 from amul sul <sulamul(at)gmail(dot)com>  2020-06-18 10:39:33 from Simon Riggs <simon(at)2ndquadrant(dot)com>   2020-06-18 14:56:27 from Robert Haas <robertmhaas(at)gmail(dot)com>  2020-07-23 00:37:28 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>   2020-07-23 10:56:35 from Amul Sul <sulamul(at)gmail(dot)com>    2020-07-24 00:56:37 from Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>  2021-09-14 23:04:01 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> 📎   2021-09-22 13:14:57 from Amul Sul <sulamul(at)gmail(dot)com>    2021-09-22 13:29:09 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>     2021-09-22 13:39:04 from Amul Sul <sulamul(at)gmail(dot)com>      2021-09-22 14:03:15 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>       2021-09-23 03:51:21 from Amul Sul <sulamul(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v3-0001-Allow-error-or-refusal-while-absorbing-barriers.patch	application/octet-stream	4.4 KB
v3-0004-Use-checkpointer-to-make-system-READ-ONLY-or-READ.patch	application/octet-stream	16.2 KB
v3-0002-Add-alter-system-read-only-write-syntax.patch	application/octet-stream	7.4 KB
v3-0003-Implement-ALTER-SYSTEM-READ-ONLY-using-global-bar.patch	application/octet-stream	22.4 KB
v3-0005-Error-or-Assert-before-START_CRIT_SECTION-for-WAL.patch	application/octet-stream	59.3 KB
v3-0006-Documentation-WIP.patch	application/octet-stream	6.5 KB

In response to

• Re: [Patch] ALTER SYSTEM READ ONLY at 2020-06-26 12:46:41 from Robert Haas

Responses

• Re: [Patch] ALTER SYSTEM READ ONLY at 2020-07-16 06:11:54 from Prabhat Sahu
• Re: [Patch] ALTER SYSTEM READ ONLY at 2020-07-24 02:04:02 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	vignesh C	2020-07-14 06:47:49	Re: Improvements in Copy From
Previous Message	Dilip Kumar	2020-07-14 06:34:56	Re: replication_origin and replication_origin_lsn usage on subscriber