Home Explore Blog CI



postgresql

53th chunk of `doc/src/sgml/installation.sgml`
7de1d7f91f052597490ec986cd4342bf1908fabce8300b130000000100000d5a
 <productname>Zstandard</productname> compression.
        Binaries and source can be downloaded from
        <ulink url="https://github.com/facebook/zstd/releases"></ulink>.
       </para></listitem>
      </varlistentry>

      <varlistentry>
       <term><productname>OpenSSL</productname></term>
       <listitem><para>
        Required for SSL support. Binaries can be downloaded from
        <ulink url="https://slproweb.com/products/Win32OpenSSL.html"></ulink>
        or source from <ulink url="https://www.openssl.org"></ulink>.
       </para></listitem>
      </varlistentry>

      <varlistentry>
       <term><productname>ossp-uuid</productname></term>
       <listitem><para>
        Required for UUID-OSSP support (contrib only). Source can be
        downloaded from
        <ulink url="http://www.ossp.org/pkg/lib/uuid/"></ulink>.
       </para></listitem>
      </varlistentry>

      <varlistentry>
       <term><productname>Python</productname></term>
       <listitem><para>
        Required for building <application>PL/Python</application>. Binaries can
        be downloaded from <ulink url="https://www.python.org"></ulink>.
       </para></listitem>
      </varlistentry>

      <varlistentry>
       <term><productname>zlib</productname></term>
       <listitem><para>
        Required for compression support in <application>pg_dump</application>
        and <application>pg_restore</application>. Binaries can be downloaded
        from <ulink url="https://www.zlib.net"></ulink>.
       </para></listitem>
      </varlistentry>

     </variablelist>
    </para>
   </sect3>

   <sect3 id="install-windows-full-64-bit">
    <title>Special Considerations for 64-Bit Windows</title>
    <para>
     PostgreSQL will only build for the x64 architecture on 64-bit Windows.
    </para>
    <para>
     Mixing 32- and 64-bit versions in the same build tree is not supported.
     The build system will automatically detect if it's running in a 32- or
     64-bit environment, and build PostgreSQL accordingly. For this reason, it
     is important to start the correct command prompt before building.
    </para>
    <para>
     To use a server-side third party library such as <productname>Python</productname> or
     <productname>OpenSSL</productname>, this library <emphasis>must</emphasis> also be
     64-bit. There is no support for loading a 32-bit library in a 64-bit
     server. Several of the third party libraries that PostgreSQL supports may
     only be available in 32-bit versions, in which case they cannot be used with
     64-bit PostgreSQL.
    </para>
   </sect3>

   <sect3 id="windows-crash-dumps">
    <title>Collecting Crash Dumps</title>

    <para>
     If PostgreSQL on Windows crashes, it has the ability to generate
     <productname>minidumps</productname> that can be used to track down the cause
     for the crash, similar to core dumps on Unix. These dumps can be
     read using the <productname>Windows Debugger Tools</productname> or using
     <productname>Visual Studio</productname>. To enable the generation of dumps
     on Windows, create a subdirectory named <filename>crashdumps</filename>
     inside the cluster data directory. The dumps will then be written
     into this directory with a unique name based on the identifier of
     the crashing process and the current time of the crash.
    </para>
   </sect3>
  </sect2>
 </sect1>

</chapter>

Title: Building and Configuring PostgreSQL on Windows
Summary
This section discusses special considerations for building and running PostgreSQL on 64-bit Windows, including the requirement for 64-bit third-party libraries, and provides information on collecting crash dumps for debugging purposes.