Changes between Version 21 and Version 22 of SysAdmin

Timestamp:

01/14/11 08:30:05 (14 years ago)

Author:

Fran Boon

Comment:

--

SysAdmin

@@ -138 +138 @@
    * [http://trac-hacks.org/wiki/PyDotOrgTheme PyDotOrgTheme] (modified CSS) - No official support (tests ok)
  * Convert from sqlite to PostgreSQL (or MySQL) to improve performance
+  * [wiki:InstallationGuidelinesPostgreSQL#InstallPostgreSQL Install PostgreSQL]
+{{{
+su postgres
+createuser -s -P trac
+
+createdb -O trac -E UTF8 trac
+}}}
   * http://trac-hacks.org/wiki/SqliteToPgScript
+{{{
+svn co http://trac-hacks.org/svn/sqlitetopgscript/0.10 sqlitetopgscript
+cd sqlitetopgscript
+./sqlite2pg -e /home/sahana/trac -p 'postgres://trac:pass@localhost/trac?schema=myschema'
+}}}
  * Add Timing & Estmation Plugin
  * Investigate a fix or alternative to http://trac-hacks.org/wiki/MathCaptchaPlugin for allowing Trac users to register bugs anonymously whilst not locking out our testing team.