PostgreSQL Windows package by Postgres Professional

Postgres Professional has prepared the PostgreSQL distribution packages for Windows.

The 32 bit version requires Windows XP SP3 or newer,  the 64 bit one requires Windows Vista 64bit or newer.

To install PostgreSQL on your computer please download one of the following files (Note that downloading any of them means your agreement with  PostgreSQL License):

For older Windows versions, like WinXP and Windows Server 2003 use the following links for 64- and 32-bit respectively:

  Specific features of Postgres Professional build are:

  • automatic server configuration parameters setup based on available RAM
  • non-latin messages encoding issue solved (at least for cyrillic)
  • additional shortcuts for server stop, start and restart.
  • critical bug fixes

The installer sources are at GitHub: https://github.com/postgrespro/pgwininstall

Disclaimer

This software is provided AS IS, without expressed or implied warranty of any kind, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. In no event shall Postgres Professional  or any contributors of this software be liable for any kind of damages, including, but not limited to, direct, indirect, incidental, special, exemplary, consequental, procurement of substitute goods or services, loss of use, data or profits, or business interruption.

Your proposals and feedback are welcome at info@postgrespro.ru.

License

PostgreSQL is distributed under the terms of  PostgreSQL License.

Portions Copyright (c) 1996-2017, The PostgreSQL Global Development Group

Portions Copyright (c) 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

Installation notes

Supported Operation Systems

This PostgreSQL version can be installed only on Windows SP3 or newer. The 64 bit build requires the 64-bit Windows version.

Installation process

At the beginning of installation choose the components to install.

If the installation script detects a previously installed PostgreSQL server, it proposes to stop and upgrade it. If so, all the connections to the server would be broken. The detection of previously installed server is performed using the system registry, so it might not work for manual or nonstandard installations.

During the installation it is prompted for the executable files and PGDATA directories. If the PGDATA directory already contains data, it will be used without reinitialization, so the prevoius data and configuration files will be preserved. If it does not exists or is empty, the user is prompted for the port number, superuser name and password and other options. The most important memory options shared_buffers and work_mem will be guessed if available RAM is > 1Gb.

After installation the server is started and is ready for work without rebooting the computer.

Windows service account

The server is started using the special windows account  'NT AUTHORITY\NetworkService'. This can be changed later using the Windows administration software.

Shortcuts

The following shortcuts are created in Windows Start menu (if it exists in your Windows version):

  • SQL Shell (psql) — the main native administration and quering tool.
  • Reload Configuration — signal the server to reload configuration files. Please note that changing some of the configuration parameters require server restart.
  • Restart Server — stop and start the server with closing all active connections.
  • Stop Server — stop the server with closing all active connections.
  • Start Server — start the server.

If you have chosen to install pgAdmin, it will be also  provided a shortcut.

Uninstallation

To uninstall the server use the Uninstall shortcut or Windows Control Panel. All connections are closed. Data is not removed. Reboot is not required.

Trademark Notices

Microsoft®, Windows®, Windows NT®, Windows Server® and Windows VistaTM are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.