[rt-users] migrating from MySQL to Postgres?
Dario Landazuri
dario at astro.as.utexas.edu
Mon Jun 27 12:06:05 EDT 2011
Ruslan,
> Here is the page from the archive:
> http://wiki-archive.bestpractical.com/view/MySQLToPg
Thanks. Trying to work with the last iteration of the script on there.
Having some problems with encoding of attachments.
Also tried doing a data-only migration using EDB's wizard after manually
importing the correct schema from <rt_home>/etc/schema.Pg, but ran into
a problem doesn't seem to respect the schema file's specifying some
capital letters and creates everything in lowercase.
i.e:
rt4=# \d
List of relations
Schema | Name | Type | Owner
--------+------------------------------+----------+----------
public | acl | table | postgres
public | acl_id_seq | sequence | postgres
public | articles | table | postgres
public | articles_id_seq | sequence | postgres
public | attachments | table | postgres
public | attachments_id_seq | sequence | postgres
public | attributes | table | postgres
This screws up the wizard.
Thanks,
Dario
--
************************************************************
Dario Landazuri dario at astro.as.utexas.edu
Systems Administrator (512) 471-3334
McDonald Observatory
************************************************************
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6558 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110627/acbd16df/attachment.bin>
More information about the rt-users
mailing list