Клиент для postgresql для windows

Клиент для postgresql для windows

Interactive installer by EnterpriseDB

Download the installer certified by EnterpriseDB for all supported PostgreSQL versions.

This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers. Stackbuilder includes management, integration, migration, replication, geospatial, connectors and other tools.

This installer can run in graphical or silent install modes.

The installer is designed to be a straightforward, fast way to get up and running with PostgreSQL on Windows.

Advanced users can also download a zip archive of the binaries, without the installer. This download is intended for users who wish to include PostgreSQL as part of another application installer.

Platform support

The installers are tested by EnterpriseDB on the following platforms. They can generally be expected to run on other comparable versions:

PostgreSQL Version 64 Bit Windows Platforms 32 Bit Windows Platforms
12 2019, 2016, 2012 R2
11 2019, 2016, 2012 R2
10 2016, 2012 R2 & R1, 7, 8, 10 2008 R1, 7, 8, 10
9.6 2012 R2 & R1, 2008 R2, 7, 8, 10 2008 R1, 7, 8, 10
9.5 2012 R2 & R1, 2008 R2 2008 R1
9.4 2012 R2, 2008 R2 2008 R1

Copyright © 1996-2020 The PostgreSQL Global Development Group

PostgreSQL Tools

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

pgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above.

Quick Links

2020-04-02 — pgAdmin 4 v4.20 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.20. This release of pgAdmin 4 includes over 13 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
  • Added support of Domain, Domain Constraints and Types to the Schema Diff.
  • Added and fixed gettext usage for better translation coverage.
  • Improve logic to get the DDL statements as a part of the comparison.
  • Enhance the color of switch control for both light and dark theme.
  • Change some colors and opacity to comply with WCAG color contrast standards.
  • Fixed tab key navigation issue for Grant Wizard.
  • Fix an issue where the user can not change the value of DateTime picker control using keyboard.
Читайте также:  Мегафон интернет на 3 часа

Download your copy here.

2020-03-05 — pgAdmin 4 v4.19 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.19. This release of pgAdmin 4 includes over 18 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added Python 3.8 support.
  • Added accessibility support in AlertifyJS.
  • Added Czech language support.
  • Improvements in the UI for both default and dark themes.
  • Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
  • Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
  • Fixed Firefox monospaced issue by updating the font to the latest version.
  • Improve the style of the highlighted code after query execution for Dark mode.
  • Changed background pattern for geometry viewer to use #fff for all themes.

Download your copy here.

2020-02-06 — pgAdmin 4 v4.18 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.18. This release of pgAdmin 4 includes over 23 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added a Schema Diff tool to compare two schemas and generate a diff script.
  • Added support for a multi-level partitioned table.
  • Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
  • Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.
  • Fix an issue where select, insert and update scripts on tables throwing an error.
  • Logout the pgAdmin session when no user activity of mouse move, click or keypress.
  • Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
  • Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
  • Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.

Download your copy here.

2020-01-09 — pgAdmin 4 v4.17 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.17. This release of pgAdmin 4 includes over 20 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Allow screen-reader to read relationship attributes in nested elements.
  • Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle.
  • Added support to view multilevel partitioned tables.
  • Rename some internal environment variables that could conflict with Kubernetes.
  • Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
  • Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
  • Fix syntax highlighting in code mirror for backslash and escape constant.
  • Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
  • Added support for on-demand loading of items in Select2
Читайте также:  Крестик на иконке outlook

Download your copy here.

2019-12-12 — pgAdmin 4 v4.16 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.16. This release of pgAdmin 4 includes over 43 bug fixes and new features. For more details please see the release notes here.

Warning: This release includes a change to the container distribution to run pgAdmin as a non-root user. Those users of the container who are running with mapped storage directories may need to change the ownership on the host machine, for example:

Notable changes in this release include:

  • Run pgAdmin in the container as a non-root user.
  • Added aria-label to provide an invisible label where a visible label cannot be used.
  • Added role="status" attribute to all the status messages for accessibility.
  • Use a ‘play’ icon for the Execute Query button in the Query Tool for greater consistency with other applications.
  • Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE.
  • Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
  • Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
  • Enhance the logic to change the label from ‘Delete/Drop’ to ‘Remove’ for the server and server group node.
  • Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node.
  • Ensure that the Servers collection node should expand independently of server connections.
  • Fix pgAdmin4 failed to start issue after upgrading to version 4.15.

Download your copy here.

2019-11-21 — Try pgAdmin online!

Our friends at EnterpriseDB have kindly made an online demo environment for pgAdmin available to allow new users to try it out in their browser without needing to download or install any software. The environment (based on the Katacoda learning platform) includes pgAdmin and PostgreSQL 12, preloaded with the pagila sample database, and is unique to every user allowing a far better experience than typical shared demo environments.

Читайте также:  Жидкость для очистки бритвы браун

Click here to try it out now!

2018-07-12 — pgAgent v4.0.0 Released

The pgAdmin Development Team are pleased to announce the release of pgAgent v4.0.0.

pgAgent is a job scheduler for PostgreSQL; for more information please see the documentation included as part of the pgAdmin documentation at https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html.

We expect DEB and RPM packages to be available from the PostgreSQL APT/YUM repositories in due course, as well as an updated installer from EnterpriseDB available through StackBuilder.

Notable changes in this release include:

  • Remove the dependency on wxWidgets. pgAgent now uses Boost for thread management and synchronisation [Neel Patel]
  • Refactor connection parsing logic to fix issues with and improve handling of connection strings [Thomas Krennwallner]
  • Handle 2 digit server version numbers [Ashesh Vashi]
  • Fix handling of the "succeeded" flag on job steps which could prevent failure of steps causing the following steps to fail [Sanket Mehta]

Для упрощения администрирования на сервере postgresql в базовый комплект установки входит такой инструмент как pgAdmin . Он представляет графический клиент для работы с сервером, через который мы в удобном виде можем создавать, удалять, изменять базы данных и управлять ими. Так, на Windows после установки мы можем найти значок pgAdmin в меню Пуск и запустить его:

После этого нам откроется следующая программа:

Теперь подключимся к серверу PostgreSQL. Для этого в левой части окна программы раскроем пункт Servers, который содержит набор серверов PostgreSQL. При установке последней версии устанавливается сервер, который по умолчанию имеет название PostgreSQL 10 . Нажмем на этот пункт, и нам отобразится окно для ввода пароля:

Здесь необходимо ввести пароль для суперпользователя postgres, который был задан при установке PostgreSQL.

После успешного логина нам откроется содержимое сервера:

В частности, в узле Databases мы можем увидеть все имеющиеся базы данных. По умолчанию здесь есть только одна база данных — postgres.

Также в правой части мы можем увидеть узел Login/Group Roles , который предназначен для управления пользователями и их ролями.

И третий узел — Tablespaces позволяет управлять местом хранения файлов баз данных.

Теперь создадим свою базу данных. Для этого нажмем правой кнопкой мыши на узел Databases . И далее в контекстном меню выберем Create -> Database.

После этого нам отобразится окно для создания базы данных. Введем название для БД, например, test1 и нажмем на кнопку "Save":

После этого в древовидном меню слева отобразится содержимое созданной базы данных test1:

Ссылка на основную публикацию
Калибровка монитора macbook pro
Сервисный центр MacPlus (ремонт Apple) раскрывает секреты калибровки дисплея iMac и Macbook Вы замечали, что одни и те же изображения...
Какие разделы нужны для ubuntu
Разделы в Ubuntu и Windows: в чем отличия? Разметка диска, или по-другому — создание разделов, всегда вызывала у начинающих пользователей...
Какие роутеры подходят для билайн домашнего интернета
Хочу купить вай-фай роутер (провайдер Билайн) , что бы можно было вай фай раздавать на ноут и др устройства плюсь...
Калькулятор градусов и минут сложение и вычитание
Калькулятор, поддерживающий основные арифметические действия над выражениями с градусами. Создан по запросу пользователя. Этот калькулятор выполняет арифметические действия над градусами....
Adblock detector