1 Topic by sword47

  • sword47
  • Member
  • Offline
  • Registered: 2012-06-24
  • Posts: 2

Topic: pgsql to mysql

==== Provide required information ====
- iRedMail version and backend (LDAP/MySQL/PGSQL): PGSQL (iRedAdmin    v0.1.7 )
- Linux/BSD distribution name and version: Centos 6.2
- Any related log? Log is helpful for troubleshooting.
====

Help,

how do I move iredmail PGSQL (iredAdmin v0.1.7) to iredmail MYSQL (iredadmin v0.1.8)?

sorry my bed english .

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,768

Re: pgsql to mysql

The SQL structures of MySQL and PostgreSQL are exactly the same. So you can simple dump all records from PGSQL to MySQL, or from MySQL to PGSQL.

3 Reply by sword47

  • sword47
  • Member
  • Offline
  • Registered: 2012-06-24
  • Posts: 2

Re: pgsql to mysql

and maybe tell me how to login as root in phppgadmin? that would make uploading of data, or is there a sh script to unload?

sorry my bed english sad

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,768

Re: pgsql to mysql

You cannot login as root in phpPgAdmin, because the root account name is postgres in PostgreSQL database.
Please try below steps:

1: Edit /var/www/phppgadmin/conf/config.inc.php, find below setting:

    $conf['extra_login_security'] = true;

2: Change it to false.

    $conf['extra_login_security'] = false;

3: Restart Apache web server.

You can now login as postgres in phpPgAdmin.