RT and Postgresql 8?

RT Users
1

Hi,

is there anything specific that makes using RT with PostgreSQL8 a bad
choice ?

My test-installation runs MySQL 4.0.x and does so quite well - but I’ve
got more trust in PostgreSQL from a RDBMS point of view.

cheers,
Rainer

~ Rainer Duffner - rainer@ultra-secure.de ~
~ Freising - Munich - Germany ~
~ Unix - Linux - BSD - OpenSource - Security ~
~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~

2

Hi,

is there anything specific that makes using RT with PostgreSQL8 a bad
choice ?

My test-installation runs MySQL 4.0.x and does so quite well - but I’ve
got more trust in PostgreSQL from a RDBMS point of view.

Nothing specific, but I’d like to hear back from folks who’ve put it
through its paces. We don’t have Pg 8.0 “in the lab” yet.

Jesse
3

Jesse Vincent wrote:

Hi,

is there anything specific that makes using RT with PostgreSQL8 a bad
choice ?

My test-installation runs MySQL 4.0.x and does so quite well - but I’ve
got more trust in PostgreSQL from a RDBMS point of view.

Nothing specific, but I’d like to hear back from folks who’ve put it
through its paces. We don’t have Pg 8.0 “in the lab” yet.

I know that MySQL is much better tested.

Is there a simple way to “generate”, say, 25000 (“realistic”) tickets
via email ?
With attachments ?
I could do a installs in different GSX-server instances (under FreeBSD5)
and see what happens…

But that would still have them (the tickets) lacking any kind of
transactions…

cheers,
Rainer

~ Rainer Duffner - rainer@ultra-secure.de ~
~ Freising - Munich - Germany ~
~ Unix - Linux - BSD - OpenSource - Security ~
~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~

4

I know that MySQL is much better tested.

Well, these days we test on MySQL, PostgreSQL and Oracle.

Is there a simple way to “generate”, say, 25000 (“realistic”) tickets
via email ?
With attachments ?
I could do a installs in different GSX-server instances (under FreeBSD5)
and see what happens…

Not quite, but “make regression” will put RT through its paces, running
almost 1500 tests on all aspects of the system.

5

Hi,

is there anything specific that makes using RT with PostgreSQL8 a bad
choice ?

My test-installation runs MySQL 4.0.x and does so quite well - but I’ve
got more trust in PostgreSQL from a RDBMS point of view.

Nothing specific, but I’d like to hear back from folks who’ve put it
through its paces. We don’t have Pg 8.0 “in the lab” yet.
working fine here, FWIW. Not heavy, but it works out of the box.

3.4.1.

Jesse

cheers,
Rainer

–

~ Rainer Duffner - rainer@ultra-secure.de ~
~ Freising - Munich - Germany ~
~ Unix - Linux - BSD - OpenSource - Security ~
~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-351-4152 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611

6

Nothing specific, but I’d like to hear back from folks who’ve put it
through its paces. We don’t have Pg 8.0 “in the lab” yet.

So far so good here. I put it in on a new install and haven’t had any
problems. Passed all tests before install.

I don’t push this install hard enough to know how fast it is compared
with version 7.

-Bill
Bill McGonigle, Owner Work: 603.448.4440
BFC Computing, LLC Home: 603.448.1668
bill@bfccomputing.com Mobile: 603.252.2606
http://www.bfccomputing.com/ Pager: 603.442.1833
AIM: wpmcgonigle Skype: bill_mcgonigle