psqlodbca.so: Cannot open shared object file: File or directory not found

Question

Asked 6 years, 11 months ago

Viewed 297 times

0

I cannot migrate Postegresql database to mysql due to this error:

psqlodbca.so: Cannot open shared object file: File or directory not found

I am 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;

I don’t understand, you are trying to use Mysql Workbench to access Postgres?

– bfavaretto

2017/10/23 at 13:27
perform a migration from the postgresql database to mysql

– alexjosesilva

2017/10/23 at 17:01

1 answer

You are not signed in. Login or sign up in order to post.

by Lacobus • **13,510** points · Answer 1 · 2017-10-25T14:49:46+00:00

1

Seems to me you don’t own the driver ODBC Postgres installed on your system.

You can do this using the package manager apt-get:

$ sudo apt-get install odbc-postgresql

Or manually download the package .deb containing the driver for 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 package .deb manually:

$ sudo dpkg -i odbc-postgresql_09.05.0400-2_amd64.deb

After executing the command I received this message: E: Sub-process /usr/bin/dpkg returned an error code (1)

– alexjosesilva

2017/10/25 at 14:55
and keeps repeating the same error: Could not connect to Source DBMS. [00000] [iODBC][Driver Manager]psqlodbca.so: Cannot open shared object file: File or directory not found (0) (Sqldriverconnect)

– alexjosesilva

2017/10/25 at 14:56
@alexjosesilva: Edited response. Any breakthrough?

– Lacobus

2017/10/25 at 15:35
Same mistake. I restarted the S.O.

– alexjosesilva

2017/10/25 at 15:53
@alexjosesilva: try manually, which is the error returned ?

– Lacobus

2017/10/25 at 15:58
how to insert odbc inside the Workbench ??

– alexjosesilva

2017/10/25 at 17:23
@alexjosesilva: Installing the Postgres ODBC driver on your Ubuntu, as I explained in the answer.

– Lacobus

2017/10/25 at 17:25
the error continues...

– alexjosesilva

2017/10/25 at 17:26
you executed the commands as root? tried in the two ways I explained? you are sure that the package was installed ?

– Lacobus

2017/10/25 at 17:28
yes...I used root made the two installations

– alexjosesilva

2017/10/25 at 17:32
ja habiliteir no php.ini o postgresql

– alexjosesilva

2017/10/25 at 17:33
Let’s go continue this discussion in chat.

– alexjosesilva

2017/10/25 at 17:35