From: Clinton Ebadi <clinton@unknownlamer.org>
Date: Tue, 11 Dec 2012 07:51:06 +0000 (-0500)
Subject: Fix domtool-postgres script
X-Git-Tag: release_20121218~2
X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/commitdiff_plain/46cdd29c3b96d2c3332cc595164773c195176eb5

Fix domtool-postgres script
Export PGPORT is not enough, because sudo clears the environment. Whoops.
---

diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index 03320d0..45d7735 100755
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -6,8 +6,8 @@ case $1 in
 	adduser)
 		USERNAME=$3
 
-		sudo -u postgres psql -h postgres -c "CREATE USER $USERNAME" template1
-		sudo -u postgres psql -h postgres -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
+		sudo -u postgres psql -h postgres -p $PGPORT -c "CREATE USER $USERNAME" template1
+		sudo -u postgres psql -h postgres -p $PGPORT -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
 	;;
 
 	createdb)
@@ -20,7 +20,7 @@ case $1 in
 		    ENCODING="-E $ENCODING"
 		fi
 
-		sudo -u postgres createdb -h postgres -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME
+		sudo -u postgres createdb -h postgres -p $PGPORT -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME
 	;;
 
 	dropdb)
@@ -28,7 +28,7 @@ case $1 in
 		DBNAME_BASE=$4
 		DBNAME="${USERNAME}_${DBNAME_BASE}"
 
-		sudo -u postgres dropdb -h postgres $DBNAME
+		sudo -u postgres dropdb -h postgres -p $PGPORT $DBNAME
 	;;
 
 	*)