Make standalone backends ignore pg_database.datallowconn, so that there

tglsfdc · tglsfdc · commit ffac21ec13c3 · 2005-05-05T19:54:13.000Z
is a way to recover from disabling connections to all databases at once.
diff --git a/src/backend/utils/init/postinit.c b/src/backend/utils/init/postinit.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/init/postinit.c,v 1.97 2001/11/02 16:30:29 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/init/postinit.c,v 1.97.2.1 2005/05/05 19:54:13 tgl Exp $
  *
  *
  *-------------------------------------------------------------------------
@@ -113,9 +113,11 @@ ReverifyMyDatabase(const char *name)
 
 	/*
 	 * Also check that the database is currently allowing connections.
+	 * (We do not enforce this in standalone mode, however, so that there is
+	 * a way to recover from "UPDATE pg_database SET datallowconn = false;")
 	 */
 	dbform = (Form_pg_database) GETSTRUCT(tup);
-	if (!dbform->datallowconn)
+	if (IsUnderPostmaster && !dbform->datallowconn)
 		elog(FATAL, "Database \"%s\" is not currently accepting connections",
 			 name);
 

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/utils/init/postinit.c,v 1.97 2001/11/02 16:30:29 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/init/postinit.c,v 1.97.2.1 2005/05/05 19:54:13 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*`
`14`	`14`	`*-------------------------------------------------------------------------`
`@@ -113,9 +113,11 @@ ReverifyMyDatabase(const char *name)`
`113`	`113`
`114`	`114`	`/*`
`115`	`115`	`* Also check that the database is currently allowing connections.`
	`116`	`+ * (We do not enforce this in standalone mode, however, so that there is`
	`117`	`+ * a way to recover from "UPDATE pg_database SET datallowconn = false;")`
`116`	`118`	`*/`
`117`	`119`	`dbform = (Form_pg_database) GETSTRUCT(tup);`
`118`		`- if (!dbform->datallowconn)`
	`120`	`+ if (IsUnderPostmaster && !dbform->datallowconn)`
`119`	`121`	`elog(FATAL, "Database \"%s\" is not currently accepting connections",`
`120`	`122`	`name);`
`121`	`123`