Skip to Content.
Sympa Menu

en - Re: [sympa-users] migrating db from postgresql to mysql

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Miles Fidelman <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] migrating db from postgresql to mysql
  • Date: Mon, 27 Oct 2014 12:37:25 -0400

Any particular reason WHY you're migrating?

Given Oracle's acquisition of MySQL, it seems like most people are moving the other way, or at least from MySQL to the Mariadb fork of MySQL.

I'm kind of curious why you're migrating TO MySQL.

Regards,

Miles Fidelman

------------------------------------------------------------------------
*De :* address@concealed [mailto:address@concealed] *De la part de* Amos
*Envoyé :* vendredi 24 octobre 2014 22:35
*À :* address@concealed
*Objet :* [sympa-users] migrating db from postgresql to mysql

It was decided that the db should be migrated from PostgreSQL to MySQL. The DBA team imported the data from the PostgreSQL db into MySQL. I then proceeded to bring up Sympa 6.1.23.

Overall things go well. Sympa updates the db structure to match the mysql settings. However, the following error message is logged:


Oct 24 15:23:20 localhost sympa[27509]: err Upgrade::probe_db() Could not set field 'robot_subscriber,list_subscriber,user_subscriber' as PRIMARY KEY, table'subscriber_table'.


Is this serious, anything to worry about? Should something be done manually?






Archive powered by MHonArc 2.6.19+.

Top of Page