[Openupload-svn-update] SF.net SVN: openupload:[125] trunk/INSTALL

[<ts...@us...>]

Revision: 125
          http://openupload.svn.sourceforge.net/openupload/?rev=125&view=rev
Author:   tsdogs
Date:     2008-11-07 17:58:57 +0000 (Fri, 07 Nov 2008)

Log Message:
-----------
add pgsql instructions

Modified Paths:
--------------
    trunk/INSTALL

Modified: trunk/INSTALL
===================================================================
--- trunk/INSTALL	2008-11-06 19:57:33 UTC (rev 124)
+++ trunk/INSTALL	2008-11-07 17:58:57 UTC (rev 125)
@@ -62,6 +62,16 @@
            mysql <database> -u <user> -p < sql/mysql/2_base.sql
          - import the configuration mode (it is not required):
            mysql <database> -u <user> -p < sql/mysql/3_mode_<selected>.sql
+       PGSQL:
+         - create the user and the db
+           su - postgres (or whatever is the db admin)
+           createuser -P -S -D -R -l openupload 
+           createdb --owner=openupload openupload "OpenUpload DB"
+         - import the database schema and default config options
+           psql -h 127.0.0.1 -W -U openupload -f sql/pgsql/1_structure.sql
+           psql -h 127.0.0.1 -W -U openupload -f sql/pgsql/2_base.sql
+         - import the configuration mode (it is not required):
+           psql -h 127.0.0.1 -W -U openupload -f sql/pgsql/3_mode_<selected>.sql
        FLAT FILE (TXT):
          - the txt is usable, but I would not suggest it unless it's a really low traffic site.
          - make sure the "rootdir" for the txtdb folder is writable by your apache user


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.