How To Compile PostgreSQL for Windows 64bit

See also: How to install MSYS2 with MinGW-w64 and development tools at https://youtu.be/pb6Yb819pF0

Commands used in the video:

To install/update git, gcc, and base-devel:
pacman –needed -S git mingw-w64-86_64-gcc base-devel

To clone the git repository locally:
git clone git://git.postgresql.org/git/postgresql.git source

cd source
rel=REL9_5_0
git checkout $rel

cd ../build
mkdir $rel
cd $rel

source={path-to-source}
dist={path-to-output}

$source/configure –host=x86_64-w64-mingw32 –prefix=$dist && make && make install