Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how PostgreSQL compiles mysql_fdw under Windows". In daily operation, I believe many people have doubts about how PostgreSQL compiles mysql_fdw under Windows. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how PostgreSQL compiles mysql_fdw under Windows". Next, please follow the editor to study!

Here is a poor method of compiling mysql_fdw under Windows, which is bad because this step is not automated. All the Windows compilation scripts are under src/tools/msvc, you can read them if you are interested, mainly Perl scripts, it is not difficult to understand.

1. Download and install mysql client

Https://dev.mysql.com/downloads/installer/

You can download mysql-installer-web-community. You don't need to download the hundreds of megabytes. Choose MySQL Connector/C when installing.

I put the directory in C:\ MySQL\ 6.1. all the include and lib are here.

2. Download the mysql_fdw source code, put it under contrib, and add it to Makefile

Https://github.com/EnterpriseDB/mysql_fdw

Ltree\ mysql_fdw\ oid2name\

3. Modify src/tools/msvc/Solution.pm

Sub AddProject adds the last two lines here, using the reference position of the first two lines. If there is a difference in the installation location, please adjust it yourself.

Push @ {$self- > {projects}-> {$folder}}, $proj; $proj- > AddDir ($initialdir) if ($initialdir); if ($name eq 'mysql_fdw') {$proj- > AddIncludeDir (' C:\ MySQL\ 6\ include'); $proj- > AddLibrary ('C:\ MySQL\ 6.1\ lib\ libmysql.lib');}

4. Modify src/include/pg_config_manual.h and add

# define _ MYSQL_LIBNAME "C:\\ MySQL\\ 6.1\\ lib\\ libmysql.dll"

5. Modify mysql_fdw.c

Add a reference

# include "dynloader.h"

Code modification

Mysql_dll_handle = dlopen (_ MYSQL_LIBNAME, RTLD_LAZY | RTLD_DEEPBIND); change to mysql_dll_handle = dlopen (_ MYSQL_LIBNAME, 1)

6. Compile PG and refer to the articles in my blog

There are a bunch of warnings, compilation passes, tests:

Flying=# create extension mysql_fdw;CREATE EXTENSIONflying=# CREATE SERVER mysql_serverflying-# FOREIGN DATA WRAPPER mysql_fdwflying-# OPTIONS (host '127.0.0.1, port' 3306); CREATE SERVERflying=# CREATE USER MAPPING FOR "Quan Zongliang" flying-# SERVER mysql_serverflying-# OPTIONS (username 'foo', password' bar') CREATE USER MAPPINGflying=# CREATE FOREIGN TABLE warehouse (flying (# warehouse_id int,flying (# warehouse_name text,flying (# warehouse_created timestamp) flying-# SERVER mysql_serverflying-# OPTIONS (dbname 'db', table_name' warehouse'); CREATE FOREIGN TABLEflying=# select * from warehouse;ERROR: failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (10061)

Because I don't have MySQL installed, the connection will fail, but it has been shown to be normal.

At this point, the study of "how PostgreSQL compiles mysql_fdw under Windows" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.