--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/inst-resources/postgresql.nsh	Wed May 27 01:05:23 2009 -0400
@@ -0,0 +1,59 @@
+/**
+ * Verify credentials for a PostgreSQL database. Assumes we are connecting to BitNami's DB.
+ * @param string Username
+ * @param string Password
+ * @return int 0 if successful, >0 on error. Will push an error string to the stack if >0.
+ */
+
+!macro postgresql_get_bin_dir
+  StrCpy $R2 "$stack_instdir\postgresql\bin"
+!macroend
+
+Function postgresql_connect
+  Pop $R1 ; Password
+  Pop $R0 ; Username
+
+  SetOutPath $PLUGINSDIR
+  File "inst-resources\postgresqlutil.php"
+  
+  nsExec::ExecToLog '"$stack_instdir\php\php.exe" "$PLUGINSDIR\postgresqlutil.php" "$R0" "$R1"'
+  Delete "$PLUGINSDIR\postgresqlutil.php"
+  ; just be done; nsExec's result is on the top of the stack.
+FunctionEnd
+
+/**
+ * Create a postgresql database and grant privileges on it to the given user.
+ * @param string User to connect with
+ * @param string Password to connect with
+ * @param string Database name
+ * @param string New user
+ * @param string New user's password
+ */
+
+Function postgresql_create_db
+  Pop $R5 ; Password
+  Pop $R4 ; User
+  Pop $R3 ; Database
+  Pop $R1 ; Password
+  Pop $R0 ; Username
+
+  /*
+  ; This isn't a working feature in PostgreSQL.
+  IfFileExists "$stack_instdir\postgresql\data\$R3" 0 DatabaseDoesNotExist
+    MessageBox MB_YESNO|MB_ICONQUESTION|MB_DEFBUTTON2 "The database $\"$R3$\" already exists. Do you want to delete and recreate it?$\n$\nIf you choose No, Setup will not alter PostgreSQL's permissions, and you may need to set up permissions manually." IDYES +2
+      Return
+
+  DatabaseDoesNotExist:
+  */
+
+  SetOutPath $PLUGINSDIR
+  File "inst-resources\postgresqlutil.php"
+
+  nsExec::ExecToLog '"$stack_instdir\php\php.exe" "$PLUGINSDIR\postgresqlutil.php" "$R0" "$R1" \
+                     "DROP DATABASE IF EXISTS $R3; \
+                      DROP ROLE IF EXISTS $R4; \
+                      CREATE ROLE $R4 WITH PASSWORD $\'$R5$\' LOGIN; \
+                      CREATE DATABASE $R3 WITH OWNER $R4;"'
+  Delete "$PLUGINSDIR\postgresqlutil.php"
+FunctionEnd
+