[rt-users] conversion of mysql to pgsql database

Olaf Hamann pooka at t-online.de
Wed Mar 22 06:05:50 EST 2006


Hi Luke,

perhaps I had a analog problem while importing sql-dump from one 
RT-instance in another. Import went well until a special data record.
This record was very long.

On mysql there is a server configuration parameter max_allowed_packet 
(you can set this in my.cnf for example) which I had to increase to 
import the sql-dump of another RT-instance.

Does your mysql-dump-output look consistent? (means: max_allowed_packet 
large enough to export the records)
Is there a equivalent configuration parameter in Postgres to allow 
imports of really big records?

Hope, this helps,
greetings Olaf




More information about the rt-users mailing list