From 4c90804e4e2cf9f5b7cc116cda41741e41a0fcbb Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Fri, 8 Sep 2023 17:06:52 -0500 Subject: [PATCH] Add create-adminuser-root target to build system --- make_files/make_db.mk | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/make_files/make_db.mk b/make_files/make_db.mk index 565780c..8b4f691 100644 --- a/make_files/make_db.mk +++ b/make_files/make_db.mk @@ -499,6 +499,24 @@ create-adminuser: ) \ | psql $(PSQL_ARGS) $(PSQL_SINGLE_TRANS) --set=ON_ERROR_STOP=y +## create-adminuser-root +## This target only works when the PostgreSQL cluster +## with which you are interacting is on the local host. +## Create the role, TARGET_USER, expected to own all +## objects in the database -- without having an +## existing PostgreSQL user to use to login. This is +## expected to be executed as the Unix "root" user. +## See also the description of create-adminuser above. +.PHONY: create-adminuser-root +create-adminuser-root: + [ -n "$(NEW_PASSWORD)" ] \ + || { printf 'The NEW_PASSWORD variable must be set\n' >&2 ; \ + exit 1 ; } + ( $(PSQL_SETUP) \ + printf "$(CREATE_ADMINUSER)\n" ; \ + ) \ + | su postgres -c 'psql -h $(HOST) -d postgres -U postgres' + ## init-database Create and initialize the database named ## by the NEW_DB variable. This target may be used ## by a regular, non-root, Unix user. To create the db -- 2.34.1