From 3a79b35aa24abaafe1809004d102d9b55b8dcc4f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 21 Jan 2025 14:29:14 -0600 Subject: [PATCH] Add a target to create a Postgres cluster Not needed when using cloud hosting, but handy to have. --- make_files/make_cluster.mk | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/make_files/make_cluster.mk b/make_files/make_cluster.mk index 31b51ca..c18187a 100644 --- a/make_files/make_cluster.mk +++ b/make_files/make_cluster.mk @@ -212,6 +212,16 @@ az-drop-throwawaydb: printf '$(DROP_THROWAWAYDB)\n' \ | psql -U $(ADMINUSER) -h $(HOST) postgres --set=ON_ERROR_STOP=y +## init-cluster Create a "primedb" Postgres cluster. +## THIS MUST BE RUN AS UNIX ROOT. +## CAUTION: This creates a cluster that runs on the +## default PostgreSQL port, 5432. Don't have +## another cluster that uses this port! +.PHONY: init-cluster +init-cluster: + su postgres -c \ + 'pg_createcluster -p 5432 --lc-collate C --start 16 primedb -- -k' + ## create-adminuser This target only works when the PostgreSQL cluster ## with which you are interacting is on the local host. ## If your cluster was created on a remote host you are -- 2.34.1