[otrs] Postgres problem

[Bryan Fullerton]

On 9/6/06, mohamad <mohamad.wali at alliedexpress.com.au> wrote:
> i am using redhat 9  ..
> i was just wondering if i can use postgres  instead of mysql working ?
> if anyone has instructions on how to do that i would be very grate
> full... i got all of otr's working on my sql and apache on redhat   but
> my manager if very picky and wants to use postgres instead of mysql
> database..... anyways if you can help me out with step by step con fig i
> would be realy great  fully.

You'll need to install PostgreSQL and DBD::Pg. You'll also need to
know how to create a user and database, and setup access permissions,
which is fairly well documented in the PostgreSQL docs.

To setup OTRS to use PostgreSQL, you need to comment out the MySQL
driver and uncomment the PostgreSQL driver in Config.pm, and use the
PostgreSQL schema sql instead of the MySQL ones during install. That's
pretty much all there is to it.

Bryan