From bae18fdb80148edcdae1b2576e950bd40bcbea4d Mon Sep 17 00:00:00 2001 From: Adis Nezirovic Date: Tue, 11 May 2010 15:18:43 +0200 Subject: system/postgresql: Initial import --- system/postgresql/setup.postgresql | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 system/postgresql/setup.postgresql (limited to 'system/postgresql/setup.postgresql') diff --git a/system/postgresql/setup.postgresql b/system/postgresql/setup.postgresql new file mode 100644 index 0000000000000..0c52cbf949287 --- /dev/null +++ b/system/postgresql/setup.postgresql @@ -0,0 +1,33 @@ +#!/bin/bash +#BLURB="PostgreSQL" + +PG_HOME=/var/lib/pgsql +PG_USER=postgres +PG_USER_ID=26 +PG_GROUP=postgres +PG_GROUP_ID=26 + +echo "Adding PostgreSQL user and group..." +groupadd -g $PG_GROUP_ID $PG_GROUP +useradd -g $PG_GROUP -u $PG_USER_ID -d $PG_HOME -c PostgreSQL $PG_USER +mkdir -p $PG_HOME/data + +## default permissions +echo "Setting up permissions..." +chown -R $PG_USER:$PG_GROUP $PG_HOME +chmod 700 $PG_HOME +chmod 700 $PG_HOME/data + +## database cluster +if [ ! -f $PG_HOME/data/PG_VERSION ]; then + echo "Creating database cluster in $PG_HOME/data..." + su $PG_USER -c "initdb -D $PG_HOME/data" +else + echo "*** WARNING ***" >&2 + echo " There is already a database cluster in $PG_HOME/data." >&2 + echo " If you are upgrading from an older version of PostgreSQL" >&2 + echo " you will have to 'dump' and 'restore' your database." >&2 + echo " See PostgreSQL manual for more details." >&2 +fi + +echo "PostgreSQL post-installation setup completed" -- cgit v1.2.3