From:       To:      

Home > Documentation > PostgreSQL to MySQL

PostgreSQL to MySQL FAQ

This page contains answers for the most frequently asked questions regarding PostgreSQL to MySQL converter. If some question is not answered here, please ask Intelligent Converters support team via Feedback Form

What versions of PostgreSQL and MySQL are supported?
All versions of PostgreSQL and MySQL servers hosted on Linux/Unix and Windows systems are supported. Also, the product provides verified compatibility with MariaDB, Percona and Heroku variations of DBMS.
Go to Top

How to resolve "The program does not support authentication protocol requested by server..." error?
The reason of the error is that authentication protocol of the target MySQL server is not supported by PostgreSQL to MySQL converter. Use OLD_PASSWORD function to make the user account compatible with PostgreSQL to MySQL database migration tool. For this purpose, login to MySQL server using administrator account and run the following statements:

    mysql> USE mysql;
    mysql> UPDATE user SET Password = OLD_PASSWORD('some_pass')
        -> WHERE Host = 'some_host' AND User = 'some_user';
After this is done, you can use 'some_user' account with PostgreSQL to MySQL conversion tool.
Go to Top

What are the system prerequisites for the application?
PostgreSQL to MySQL converter works on Windows XP (SP2 or SP3), Windows 2003, Windows Vista, Windows Server 2008, Windows 7, Windows 8 and Windows 10. Also, the program requires server or client components of PostgreSQL to be installed on the same machine.
Go to Top

What kind of PostgreSQL data is converted to MySQL?
The application converts table definitions with corresponding attributes, data, indexes and constraints. It does not convert views, triggers and stored procedures. Demo version converts only 50 records per table and does not convert foreign keys.
Go to Top

Does PostgreSQL to MySQL migration tool provide automation feature?
The program does not support automation directly. However, it is supplied with console version (p2sagent.exe in the installation directory). This version supports command line arguments and so it can be called from any script. Write simple batch script calling p2sagent.exe with the appropriate parameters and you will be able to launch conversion recurrently using Windows Task Scheduler. Read Command line article of the product documentation for more information about p2sagent.exe.
Go to Top

It is possible to connect to MySQL over SSH?
Yes, PostgreSQL to MySQL converter supports connection to MySQL server via SSH. Please refer to Connecting to MySQL over SSH article for more details.
Go to Top

How to fix "The ordinal XXXX could not be located in the dynamic link library LIBEAY32.dll." error?
The error means that the program failed to find at least one of required libraries. Verify that client or server components of PostgreSQL are installed on the same machine where PostgreSQL to MySQL database migration tool is running. Also make sure that the path to PostgreSQL installation folder is in the $PATH environmental variable. If the problem persists, copy pgs2sql.exe into PostgreSQL BIN subfolder and try to run it again.
Go to Top

How to resolve error "Access denied for user: <user-name>"?
You will not be able to connect to the target MySQL server until you have the appropriate permissions. Ask your MySQL server administrator to give you sufficient permissions to create new databases on the target MySQL server.
Go to Top

I see the error: "Access denied for user: <user name> to database <database>". How to handle it?
If the destination database already exists, user must have privileges to create/delete tables and to write data. If MySQL database does not exist, user must have sufficient privileges to create new databases on the target MySQL server.
Go to Top