[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