Thanks for all of the help. Here, is the summary that I had promised. In addition to the documentation here
https://www.postgresql.org/docs/manuals/ and https://wiki.postgresql.org/wiki/Main_Page I will explain how I install PostgreSQL using on Windows using Mingw with zlib, pltcl, plperl, and plpython. This information presented here is only meant to explain solutions to things that are a little 'more difficult' on Windows. Begin acquiring the software. Get already compiled zlib here ftp://ftp.zlatkovic.com/libxml/64bit/ Specifically, get exactly zlib from here. ftp://ftp.zlatkovic.com/libxml/64bit/zlib-1.2.8-win32-x86_64.7z (Note, the zlib home is actually here: http://www.zlib.net/) Extract, those folders and files to a folder on disk. For example. C:\Users\TargetUser\Documents\zlib-1.2.8-win32-x86_64 Identify the header(include) and lib directories. C:\Users\TargetUser\Documents\zlib-1.2.8-win32-x86_64\include C:\Users\TargetUser\Documents\zlib-1.2.8-win32-x86_64\lib Note those locations, and save that information for later Information about the languages follow. Get to know what the needed library versions from here. (1) TCL with TK; 8.5 (2) Perl; 5.20 (3) Python; 3.3 http://get.enterprisedb.com/docs/README-languagepack-950.txt (1) TCL with TK; 8.5 (2) Perl; 5.20 (3) Python; 3.3 http://get.enterprisedb.com/docs/README-edb-languagepack-9.6.txt Get Python and Perl from the Graphical installer from here. http://www.enterprisedb.com/products-services-training/pgdownload#windows Download the graphical installer and install (1) Python and (2) PERL Make a note of where the perl.exe and python.exe files are located. C:\EnterpriseDB\LanguagePack\9.5\x64\Perl-5.20\bin\perl.exe C:\EnterpriseDB\LanguagePack\9.5\x64\Python-3.3\python.exe Do not install TCL from EnterpriseDB. If one were TOO install the TCL from EnterpriseDB and if one were to inspect the tclConfig.sh file that is found in the 'lib' directory, a surprise may be seen. The EnterpriseDB TCL tclConfig.sh file has a hard coded TCL_LIB_SPEC TCL_LIB_SPEC='C:\EnterpriseDB\LanguagePack\9.5\x64\Tcl-8.5\lib\tcl85.lib' But the TCL_LIB_SPEC actually needs to be something like TCL_LIB_SPEC='-LC:/Path/To/folder/lib -ltcl85' So EnterpriseDB TCL can not be used in the compiling of the TCL language into PostgreSQL. I found that to be surprising. Download TCL from here. https://www.tcl.tk/software/tcltk/ Specifically here https://www.tcl.tk/software/tcltk/8.5.html Install those files to a convenient place. C:\Tcl.8.5.18.0 Inspect the tclConfig.sh file that is found in the 'lib' directory This line TCL_LIB_SPEC='-LC:/Tcl.8.5.18.0/lib -ltcl85' is the form TCL_LIB_SPEC='-LC:/Path/To/folder/lib -ltcl85' So, this TCL is useful Make a note of where the tclsh.exe executable is located C:\Tcl.8.5.18.0\bin\tclsh.exe The pexports.exe file is needed. This is NOT included in the standard Mingw distribution ( but the dlltool.exe is in Mingw ). This pexports.exe file is called a Mingw Extension. For each language:Tcl, Perl, and Python, pexports ( driven and done in 'make' later ) will run the following. pexports LANGUAGE.dll > LANGUAGE.def dlltool --dllname LANGUAGE.dll --def LANGUAGE.def --output-lib LANGUAGE.a Specifically, pexports /c/Tcl.8.5.18.0/bin//tcl85.dll > tcl85.def dlltool --dllname tcl85.dll --def tcl85.def --output-lib libtcl85.a pexports /c/EnterpriseDB/LanguagePack/9.5/x64/Perl-5.20/bin/perl520.dll > perl520.def dlltool --dllname perl520.dll --def perl520.def --output-lib libperl520.a pexports C:/Windows/system32/python33.dll > python33.def dlltool --dllname python33.dll --def python33.def --output-lib libpython33.a Notice, that the Python33.dll comes from the C:\Windows\system32 folder and NOT the 'same directory as the executable' that Perl and TCL use. I found that to be surprising. Get pexports.exe from one of two places. In one place, a compiled pexports.exe can found with the Strawberry Perl distribution. Specifically it is in here. C:\Strawberry\c\bin The other place is the source. A person would have to manually compile and make the pexports.exe file. The source is here. https://sourceforge.net/projects/mingw/files/MinGW/Extension/pexports/ Copy the pexports.exe to the same place where the Mingw dlltool.exe is located ( this is already in the Mingw PATH ). That is specifically here. C:\x86_64-6.2.0-release-posix-seh-rt_v5-rev0\mingw64\bin That was the end of acquiring the software. This is the beginning of compiling. Prepare to start an msys shell. Edit the msys.bat file: C:\MinGW\msys\1.0\msys.bat Near the top of the msys.bat file add the simple line that removes anything not important to the compiling process from the PATH. set PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ In the MSYS shell at the command prompt($), place the LANGUAGE .exes in the path. export PATH=/c/Tcl.8.5.18.0/bin:$PATH export PATH=/c/EnterpriseDB/LanguagePack/9.5/x64/Perl-5.20/bin:$PATH export PATH=/c/EnterpriseDB/LanguagePack/9.5/x64/Python-3.3:$PATH Configure. Below are the options I use and why. Start configuration. ./configure Languages: their .exe files are in the path. The ./lib and ./include locations seems to be picked up from the location of the .exe in the PATH. So no other ./include nor ./lib information are needed. I found that to be slightly surprising. -with-tcl --with-python --with-perl zlib --with-includes=/c/Users/TargetUser/Documents/zlib-1.2.8-win32-x86_64/include --with-libraries=/c/Users/TargetUser/Documents/zlib-1.2.8-win32-x86_64/lib Compile target --host=x86_64-w64-mingw32 Install location ( files are copied here as a result of 'make install' ) --prefix=/usr/local/pgsql_0ab9c56_debug Make PostgreSQL relocatable, so I can move the binaries to a different folder later and PostgreSQL will still start up. --disable-rpath For development, if a change is done such that something is re-compiled, then dependent objects also get re-compiled. --enable-depend Debugging help --enable-cassert --enable-debug So, I can track exactly which github mirror version I have. Also, I can track how much debugging information I have. --with-extra-version=_CFLAGS_O_0ab9c56 For development, turn off optimizations, so I can see the values of 'more' variables to aid in debugging. CFLAGS="-O -fno-omit-frame-pointer" So the configure line would approximately look like this. However running it would still require it all to be on one very very long line. ./configure -with-tcl --with-python --with-perl --with-includes=/c/Users/AnonymousUser/Documents/zlib-1.2.8-win32-x86_64/include --with-libraries=/c/Users/AnonymousUser/Documents/zlib-1.2.8-win32-x86_64/lib --host=x86_64-w64-mingw32 --prefix=/usr/local/pgsql_0ab9c56_debug --disable-rpath --enable-depend --enable-cassert --enable-debug --with-extra-version=_CFLAGS_O_0ab9c56 CFLAGS="-O -fno-omit-frame-pointer" After configuring, do the following. Clean up with make clean Make with make Check with make check (Above) 'make check' actually makes a mini PostgreSQL, so I make sure that I do not have another PostgreSQL up and listening on the same ( default ) port of 5432. Install with make install That was the end of compiling. This is the beginning of extension creation. Plan to startup PostgreSQL. Get Portable PostgreSQL from here. https://sourceforge.net/projects/postgresqlportable/ Extract the 'startup batch' file. Customize the startup batch as necessary. In the 'startup batch', put the tclsh.exe, perl.exe,and python.exe 'paths' in the PATH. Also, set the PYTHONHOME environment variable. It is all explained in here. http://get.enterprisedb.com/docs/README-languagepack-950.txt http://get.enterprisedb.com/docs/README-edb-languagepack-9.6.txt Place the 'startup batch' file in the parent folder, of the ./bin directory of PostgreSQL. Modify the 'startup batch' environment variables including PG* postgreSQL environment variables. Execute the batch to start PostgreSQL. Run the following SQL create extension pltcl; create extension plperl; create extension plpython3u; ( or sometimes ... plythonu; ) Follow the rest of the instructions here. https://www.postgresql.org/docs/current/static/pltcl-functions.html https://www.postgresql.org/docs/current/static/plperl-funcs.html https://www.postgresql.org/docs/current/static/plpython-funcs.html This is the end of extension creation. Consider more powerful Language distributions ( other than the ones that were mentioned earlier ) Activestate TCL ACTIVETCL COMMUNITY EDITION DOWNLOAD http://www.activestate.com/activetcl/downloads Strawberry Perl http://strawberryperl.com/ WinPython https://winpython.github.io/ Andre Mikulec andre_miku...@hotmail.com
