How do I find PostgreSQL's data directory? Ask Question 104. @Tom I don't think the formula really intended to use the datadir passed to configure. Browse other questions tagged postgresql mac-os-x or ask your own question. 7 years, 11 months ago. 127,475 times.

Important If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package. The msodbcsql17 package can be installed side by side with the msodbcsql v13 package. This will avoid conflicts. Note • Driver version 17.2 or higher is required for Ubuntu 18.04 support. • The unixodbc-dev package 2.3.1 is not available on Ubuntu 14.04. Access driver for mac.

If you plan to use the MySQL Workbench Migration Wizard to migrate databases from PostgreSQL to MySQL you first need to configure an ODBC driver to connect to your PostgreSQL server. In this post I’ll cover how to set up and configure, the official ODBC driver for PostgreSQL.

Installing the psqlODBC Driver The procedure is different for every platform so make sure to follow the instructions that correspond to the OS where you have MySQL Workbench installed. The driver needs to be installed in that machine, as explained in the. Important: Always install the 32 bit version of the driver, even on x64 systems, as MySQL Workbench is a 32 bits application. Windows If you are running MySQL Workbench on Windows download the MSI package for psqlODBC. Go to its download page () and pick the most recent file from the list.

(The most recent one is at the bottom of the page.) Unzip the downloaded file and install the provided MSI package. This is all you have to do. You can skip the rest of this post. Linux The Migration Wizard uses as a driver manager for all of its ODBC connections in Linux.

This may give you some troubles because most Linux distributions provide ODBC drivers compiled against unixODBC. This is another driver manager not supported by MySQL Workbench so you won’t be able to use those drivers unless you compile them against iODBC. Here’s what you should do. Make sure that you have iODBC installed.

If you are using Debian, Ubuntu or another Debian based distro, type this command in your terminal: $> sudo apt-get install iodbc libiodbc2-dev libpq-dev libssl-dev For RPM based distros (RedHat, Fedora, etc.) type this command instead of the previous one: $> sudo yum install iodbc iodbc-dev libpqxx-devel openssl-devel Now we need to install the PostgreSQL ODBC drivers. Download the psqlODBC source tarball from. Use the latest version available for download. As of this writing the latest version corresponds to the file psqlodbc.tar.gz. Extract this tarball to a directory in your hard drive and open a terminal and cd into that directory. Type this in the terminal window: $>./configure --with-iodbc --enable-pthreads $> make $> sudo make install Verify that you have the file psqlodbcw.so in the /usr/local/lib directory. Mac OS X To build psqlODBC in Mac OS X, you need to have Xcode and the “Command Line Tools” additional component installed, so that the gcc compiler is available.