Fix domtool-postgres script
authorClinton Ebadi <clinton@unknownlamer.org>
Tue, 11 Dec 2012 07:51:06 +0000 (02:51 -0500)
committerClinton Ebadi <clinton@unknownlamer.org>
Tue, 11 Dec 2012 07:51:06 +0000 (02:51 -0500)
Export PGPORT is not enough, because sudo clears the environment. Whoops.

src/plugins/domtool-postgres

index 03320d0..45d7735 100755 (executable)
@@ -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
        ;;
 
        *)