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

This article focuses on "how to use the compiled PostgreSQL binary package to compile mysql_fdw", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to compile mysql_fdw using compiled PostgreSQL binaries.

1. Download the PostgreSQL binary package:

Download PostgreSQL Binaries, click download.

This is the download address of EnterpriseDB Company. Don't worry about the Trojan horse in the version I compiled.

Some people are really worried. It's not a bad thing to be wary of being away from home. If you don't need it, you can always rest assured to use EDB. )

The file name is postgresql-11.4-2-windows-x64-binaries.zip, and the package looks large because it contains the pgAdmin4 and Python environment.

After decompressing them, I put them in the directory: C:\ postgresql-11.4-2-bin

It's not a good habit, mainly to save trouble, and my virtual machine has only one C disk.

2. Clone mysql_fdw source code

There is no need to elaborate on this, assuming that it is placed in the C:\ mysql_fdw directory.

3. Install the client for MySQL development

As before, suppose you put it in the C:\ MySQL\ 6. 1 directory.

4. Download mysql_fdw.sln, mysql_fdw.vcxproj, MYSQL_FDW.def

These three files are placed under C:\ mysql_fdw.

If you are not familiar with VC++, it is recommended to use the same directory name as above, without modification.

Sharing with Baidu cloud disk may expire after a period of time. Download it as soon as possible.

These three are all text, so you can open them with NotePad++ or something like that.

If you're not sure, just don't download it. Don't ask me if I have a Trojan horse. Even if I release the horse, I won't tell you the truth. Is that right?

5. Open mysql_fdw.sln with VC++ 2013 CE

Download address for old version of Visual Studio: https://visualstudio.microsoft.com/zh-hans/vs/older-downloads/

If you are familiar enough, you can put it in any directory you like and modify mysql_fdw.vcxproj.

If you have any more questions, please check Microsoft documentation.

At this point, I believe you have a better understanding of "how to compile mysql_fdw using compiled PostgreSQL binaries". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.