[Trac] PostgreSQL Conversion

[Brad Anderson]

Due to the overwhelming support for this post to the mailing list ;) ... I 
continued on and put another patch for PostgreSQL on my wiki page.

Now you don't have to convert an existing Trac SQLite database for this to 
work.  'trac-admin' was hacked around (the 'initenv' command only), so if you 
wanted to see an instance of Trac running on pgsql, you could just make 
another Trac environment, and choose 'pgsql' at the fourth question of 
initenv.  Also, the createdb script is no longer needed.  trac-admin will 
attempt to create the database and then populate it with the default values, 
just like with SQLite.  You still have to get PostgreSQL up and running and 
create the 'trac' user.

I still have a bunch of queries to test by clicking on the different features 
on each page.  Assistance would be appreciated.

There are more instructions and notes here:
http://trac.dsource.org/projects/test/wiki/PostgresqlPatch

Enjoy,
Brad




On Monday 03 January 2005 12:39 am, Brad Anderson wrote:
> Hi all,
>
> This weekend, I tinkered with a patch to allow Trac to work with a
> PostgreSQL database instead of SQLite.  It is just the beginning of what is
> required, but I got most modules to at least come up and render data.
>
> http://trac.dsource.org/projects/test/wiki/PostgresqlPatch
>
> Comments are welcome.
>
> Cheers,
> Brad
>
>
> See also:
> http://projects.edgewall.com/trac/ticket/126
> http://projects.edgewall.com/trac/wiki/DatabaseBackend
> _______________________________________________
> Trac mailing list
> Trac at lists.edgewall.com
> http://lists.edgewall.com/mailman/listinfo/trac