Hi.
Will RT 2.0 “release” have PostgreSQL support “out da box”?
Will RT 2.0 alpha 3 have it?
Does RT 2.0 alpha 2 have it?
Better yet, is there a stabilized version of RT that has PostgreSQL
support?
I was unable to answer these questions by perusing the RT web site.
Perhaps I missed stuff.
Thanks.
Will RT 2.0 “release” have PostgreSQL support “out da box”?
Yes.
Does RT 2.0 alpha 2 have it?
Yes, but it’s known to have issues. I’m currently waiting on a patch
to the database substrate, DBIx::SearchBuilder, which addresses many of them.
Better yet, is there a stabilized version of RT that has PostgreSQL
support?
long long long ago, somoene ported rt 0.99.something to postgres as a oneoff.
however it was rather a lot of work and it wasn’t possible to maintain
that in the same codebase as the core distribution.
jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
They’ll take my private key when they pry it from my cold dead fingers!
Yes, but it’s known to have issues. I’m currently waiting on a patch
to the database substrate, DBIx::SearchBuilder, which addresses many of them.
Do you have a patch that needs to be applied or you waiting for author to
make one?
-alex
We’ve got an RT instance that is starting to grow, and is getting
harder and harder on the system. We’ve seen PostgreSQL use 20-25% of
CPU, with multiple instances running.
I guess a first question: does RT support connection pooling, or can
it use Unix-style sockets (instead of TCP/IP sockets) with PostgreSQL?
It looks like it can with MySQL, though I may be mistaken.
Secondly, does anyone have any pointers to postgres tuning? I think
I’ve got it pretty well configured, just looking for someone to
compare configurations to. The most I can think of is to up our
SHMMAXPGS (we’re running FreeBSD), but I’m afraid of locking down too
much RAM.
The current system is a PIII-1GHz, with 756MB RAM. When busy, the
load can easly hit 2.00, but usually sits around 0.30. We
continuously see processes blocking (but that may be something else
going on), and there is little to no paging at all.
TIA.