Re: [rt-users] migrating from MySQL to Postgres?

[Dario Landazuri]

Ruslan,

Here is the page from the archive:
http://wiki-archive.bestpractical.com/view/MySQLToPg

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                    da...@astro.as.utexas.edu
Systems Administrator                         (512) 471-3334
McDonald Observatory
************************************************************

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.

smime.p7s
Description: S/MIME Cryptographic Signature

--------
2011 Training: http://bestpractical.com/services/training.html