Fix domtool-postgres script

[hcoop/domtool2.git] / src / plugins / domtool-postgres

diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index 03320d0..45d7735 100755 (executable)
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -6,8 +6,8 @@ case $1 in
        adduser)
                USERNAME=$3
 
        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)
        ;;
 
        createdb)


@@ -20,7 +20,7 @@ case $1 in
                    ENCODING="-E $ENCODING"
                fi
 
                    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)
        ;;
 
        dropdb)


@@ -28,7 +28,7 @@ case $1 in
                DBNAME_BASE=$4
                DBNAME="${USERNAME}_${DBNAME_BASE}"
 
                DBNAME_BASE=$4
                DBNAME="${USERNAME}_${DBNAME_BASE}"
 

-               sudo -u postgres dropdb -h postgres $DBNAME
+               sudo -u postgres dropdb -h postgres -p $PGPORT $DBNAME

        ;;
 
        *)
        ;;
 
        *)