I can not migrate the PostegreSql database to mysql because of this error:
psqlodbca.so: Unable to open shared object file: File or directory not found
I'm using ubuntu 64 Postgresql 9x and workbench 6.x, how should I proceed?
Connection String: ODBC connection string: DRIVER = PostgreSQL ANSI; SERVER = 127.0.0.1; PORT = 5432; DATABASE = financial; UID = postgres; UseDeclareFetch = 1;
It seems to me that you do not have the Postgres ODBC driver installed on your system.
You can do this using the apt-get package manager:
$ sudo apt-get install odbc-postgresql
Or manually download the package .deb containing the driver to Ubuntu 17.04 (Zesty Zapus) :
$ wget http://archive.ubuntu.com/ubuntu/pool/universe/p/psqlodbc/odbc-postgresql_09.05.0400-2_amd64.deb
And then install the .deb package manually:
$ sudo dpkg -i odbc-postgresql_09.05.0400-2_amd64.deb