[cvs] [Wiki] changed: FC4InstallationNotes

[Eric Rostetter]

ericr  Fri, 04 Aug 2006 13:35:12 -0700

Modified page: http://wiki.horde.org/FC4InstallationNotes
New Revision:  3.3
Change log:  "More better" PostgreSQL instructions

@@ -132,9 +132,24 @@
  
  ++ PostgreSQL
  
  Before you can use the PostgreSQL server with Horde, you must setup the SQL server and create the needed database tables.
-Unfortunately, we don't have step by step instructions at this time...
+<code>
+cd /var/www/html/horde/scripts/sql
+vi pgsql_create.sql
+</code>
+
+Then change the database password in the file and save it.  Once you have set the password correctly in the script,
+you should run the script in order to create the database:
+
+<code>
+psql -d template1 -f pgsql_create.sql -U postgres
+psql -d horde -U horde -f auth.sql
+psql -d horde -U horde -f category.sql
+psql -d horde -U horde -f prefs.sql
+</code>
+
+Note that you may see some NOTICE messages from PostreSQL noting that implicit indexes have been created; these are normal and can be ignored.
  
  ++ Horde
  
  First, you need to install the distribution default configuration files, present in the config subdirectory within each Horde application (including the base Horde configuration directory itself):