Postgresql 8 4 12
Author: e | 2025-04-24
13 4 years ago () Ends in 8 months () 13.20 () 12 More information is available on the PostgreSQL website. Foxpro to PostgreSQL Migration: 4. Informix to PostgreSQL Migration: 5. InterSystems Cache to PostgreSQL Migration: 6. MS Access to PostgreSQL Migration: 7. MS Excel to PostgreSQL Migration: 8. MariaDB to PostgreSQL Migration: 9. Oracle to PostgreSQL Migration: 10. SQL Azure to PostgreSQL Migration: 11. SQL Server to PostgreSQL Migration: 12
CentOS 8 install PostgreSQL 12 - zeldor.biz
Computer HardwareMinimum Requirement: 64-bit Windows: Any Intel or AMD quad-core processor with 4GB of RAM. Mac: Almost any Mac that runs macOS 10.15 or later released in 2014+ with 4GB of RAM.Recommended: 64-bit Windows: Modern Intel or AMD quad-core processor with 8GB of RAM or greater. Mac: Any Mac that runs macOS 12 or later with 8GB of RAM and an SSD.Optimal: Windows: 64-bit Windows: Any 6+ core Intel or AMD with 16GB of RAM or greater. Mac: Any Apple Silicon MacNot Recommended: Less than four cores. Less than 8GB of RAM. A disk hard drive.Operating SystemMinimum Requirement: 64-bit Windows: Windows 7/8. Mac: macOS 10.15 CatalinaRecommended: 64-bit Windows: Windows 10+. Mac: macOS 12 Monterey (or newer)Optimal: 64-bit Windows: Windows 10/11 with 64-bit PostgreSQL 12.x manually installed. Mac: macOS 14 with PostgreSQL 64-bit 12.x manually installedPostgreSQLMinimum Requirement: PostgreSQL 9.3 or greaterRecommended: The latest version of 64-bit PostgreSQL 16Optimal: The latest version of 64-bit PostgreSQL 16 with 8 GB of RAM or better for optimal performance.Hard DriveThe number one factor for speed performance is hard drive speed, the PostgreSQL Server which powers the PokerTracker database commonly moves gigabytes of data to allow PokerTracker 4 to perform it's reporting duties. PokerTracker recommends at least a 7200RPM hard drive or faster, Solid State Drives (SSDs) are currently the fastest drives available for optimal performance. The optimal solution for Mac users are computers that contains a built in SSD drive.
PostgreSQL 12のインストール (RHEL 8 / CentOS 8)
Hi Postgress,I used to have a functioning PostgreSQL database, but upon reinstalling due to computer issues, I am now getting this error after launching:Traceback (most recent call last): File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 98, in app = create_app() File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app if not os.path.exists(SQLITE_PATH) or get_version() == -1: File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version return version.valueAttributeError: 'NoneType' object has no attribute 'value'I've tried everything from these stackoverflow forums ( and in order to fix it, however the error remains. I'm out of options, hopefully you know the answer.I tried it with both PostgreSQL 11, 12 and 13. I'm using a windows 64 bit with PgAdmin 4.Kind regards,Derek[ - pgadmin4 : postgresql application server could not be contacted. - Stack Overflow have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_distro.py, and delete the files in Roaming folder,i tried standalone pgadmin4 installation, but no success.However, in my local ...stackoverflow.comPostgreSQL : Documentation: 12: E.8. Release 12.13
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. To use Postgre in your machine, you need to install:Postgre Database ServerA graphical tool to administer and manage the DB. pgAdmin is the most popular tool GUI Tool for PostgreYou could individually Download PostgreSQL for Windows and install these components but coupling the settings between the DB server, and a GUI tool could be a challenge. It’s best to use a bundled installer which takes care of configuration complexities.Install PostgreSQL on Windows Machine:Step 2) You are given two optionsInteractive Installer by EnterpriseDBGraphical Installer by BigSQLBigSQL currently installs pgAdmin version 3 which is deprecated. It’s best to choose EnterpriseDB which installs the latest version 4Step 3)You will be prompted to desired PostgreSQL version and operating system. Select the latest PostgreSQL version and OS as per your environmentClick the Download ButtonDownload will beginStep 4)Once you Download PostgreSQL, open the downloaded exe and Click next on the install welcome screen.Step 5)Change the Installation directory if required, else leave it to defaultClick NextStep 6)You may choose the components you want to install in your system. You may uncheck Stack BuilderClick NextStep 7)You may change the data locationClick NextStep 8)Enter super user password. Make a note of itClick NextStep 9)Leave the port number defaultClick NextStep 10)Check the pre-installation summary:Click NextStep 11) Click the next buttonStep 12) Once install is complete you will see the Stack Builder promptUncheck that option. We will use Stack Builder in more advance tutorialsClick. 13 4 years ago () Ends in 8 months () 13.20 () 12 More information is available on the PostgreSQL website. Foxpro to PostgreSQL Migration: 4. Informix to PostgreSQL Migration: 5. InterSystems Cache to PostgreSQL Migration: 6. MS Access to PostgreSQL Migration: 7. MS Excel to PostgreSQL Migration: 8. MariaDB to PostgreSQL Migration: 9. Oracle to PostgreSQL Migration: 10. SQL Azure to PostgreSQL Migration: 11. SQL Server to PostgreSQL Migration: 12Install PostgreSQL 12 on CentOS 7 and 8 with DirectAdmin
Convert any data source to convert any data source5 MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. It includes the following utilities: (1) Access-to-MySQL - migrates MS Access database to MySQL server; (2) DB2-to-MySQL - migrates IBM DB2 databases to MySQL server;(3) DBF-to-MySQL - moves DBase (dbf) databases to MySQL server;(4) Excel-to-MySQL - converts MS Excel spreadsheet into MySQL database; (5) MSSQL-to-MySQL - migrates MS SQL database to MySQL server; (6) MySQL-to-Access - converts MySQL database into MS Access format; (7) MySQL-to-DB2 - migrates MySQL databases to IBM DB2 server;(8) MySQL-to-DBF - converts MySQL databases into DBase (dbf) format;(9) MySQL-to-Excel - converts MySQL database into MS Excel spreadsheet; (10) MySQL-to-MSSQL - migrates MySQL database to MS SQL server; (11) MySQL-to-Oracle - migrates MySQL database to Oracle server; (12) MySQL-to-PostgreSQL - migrates MySQL database to PostgreSQL server; (13) Oracle-to-MySQL - migrates Oracle database to MySQL server;(14) PostgreSQL-to-MySQL - migrates PostgreSQL database to MySQL server.PostgreSQL : Documentation: 12: E.8. Release 12.12
Download PostgreSQL 17.4 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 17.3 Date released: 14 Feb 2025 (4 weeks ago) Download PostgreSQL 17.2 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 17.1 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 17.0 Date released: 26 Sep 2024 (6 months ago) Download PostgreSQL 16.8 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 16.6 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 16.5 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 16.4 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 16.3 Date released: 10 May 2024 (10 months ago) Download PostgreSQL 16.1 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.12 Date released: 22 Feb 2025 (3 weeks ago) Download PostgreSQL 15.10 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 15.9 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 15.8 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 15.5 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.4 Date released: 11 Aug 2023 (one year ago) Download PostgreSQL 15.3 Date released: 12 May 2023 (one year ago) Download PostgreSQL 15.2 Date released: 10 Feb 2023 (2 years ago) Download PostgreSQL 15.1 Date released: 10 Nov 2022 (2 years ago)PostgreSQL: Documentation: 12: Chapter 8. Data Types
Download PostgreSQL 10.18 Date released: 13 Aug 2021 (4 years ago) Download PostgreSQL 10.17 Date released: 14 May 2021 (4 years ago) Download PostgreSQL 10.16 Date released: 12 Feb 2021 (4 years ago) Download PostgreSQL 10.15 Date released: 13 Nov 2020 (4 years ago) Download PostgreSQL 10.14 Date released: 25 Aug 2020 (5 years ago) Download PostgreSQL 10.13 Date released: 22 May 2020 (5 years ago) Download PostgreSQL 10.9 (32-bit) Date released: 31 Jul 2019 (6 years ago) Download PostgreSQL 10.9 (64-bit) Date released: 31 Jul 2019 (6 years ago) Download PostgreSQL 10.7 (32-bit) Date released: 15 Feb 2019 (6 years ago) Download PostgreSQL 10.7 (64-bit) Date released: 15 Feb 2019 (6 years ago) Download PostgreSQL 10.5.1 (32-bit) Date released: 09 Aug 2018 (7 years ago) Download PostgreSQL 10.5.1 (64-bit) Date released: 09 Aug 2018 (7 years ago) Download PostgreSQL 10.4.1 (32-bit) Date released: 11 May 2018 (7 years ago) Download PostgreSQL 10.4.1 (64-bit) Date released: 11 May 2018 (7 years ago) Download PostgreSQL 10.3.2 (32-bit) Date released: 21 Apr 2018 (7 years ago) Download PostgreSQL 10.3.2 (64-bit) Date released: 21 Apr 2018 (7 years ago) Download PostgreSQL 10.3 (32-bit) Date released: 01 Mar 2018 (7 years ago) Download PostgreSQL 10.3 (64-bit) Date released: 01 Mar 2018 (7 years ago) Download PostgreSQL 10.2 (32-bit) Date released: 08 Feb 2018 (7 years ago) Download PostgreSQL 10.2 (64-bit) Date released: 08 Feb 2018 (7 years ago)Easy PostgreSQL 12 and pgAdmin 4 Setup with Docker
Navicat for PostgreSQL (macOS) version 17.1.7 Bug-fixes:Unable to backup with Automation.Crashed when finding data in query results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 12 2024 Navicat for PostgreSQL (macOS) version 17.1.6 Bug-fixes:Time delay when reporting errors.Wrongly displayed German in UI.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 8 2024 Navicat for PostgreSQL (macOS) version 17.1.5 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 2 2024 Navicat for PostgreSQL (macOS) version 17.1.4 Bug-fixes:Unable to copy multiple columns in the data viewer.Lost focus when updating row value.Unable to open database connection after VPN disconnected/reconnected.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 10 2024 Navicat for PostgreSQL (macOS) version 17.1.3 Main New Features:All-New Model WorkspaceData ProfilingData DictionaryQuery Pinned ResultVisual Query ExplainTable ProfileNavicat URIManage ConnectionEnhanced BI FeatureFocus ModeSupport Alibaba Cloud PolarDB for PostgreSQLMany other new features and improvementsTo upgrade, please visit our Customer Center. May 9 2024 Navicat for PostgreSQL (macOS) version 16.3.9 Bug-fixes:Column headers were not aligned in the data grid.Cannot open PostgreSQL tables in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Apr 23 2024 Navicat for PostgreSQL (macOS) version 16.3.8 Bug-fixes:Crashed when transferring PostgreSQL data in some cases.The screen scrolled to the left after refreshing the data in Data Viewer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 4 2024 Navicat for PostgreSQL (macOS) version 16.3.7 Bug-fixes:Crashed when PostgreSQL connection was lost.Modified data types were not retained when switching to other tables in Import Wizard.Unable to connect using ssh agent in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 9 2024 Navicat for PostgreSQL (macOS) version 16.3.5 Bug-fixes:Crashed when closing Server Monitor.Crashed when switching tabs on Information Pane.The percentage values shown in the chart were incorrect.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 12 2023 Navicat for PostgreSQL (macOS) version 16.3.4 Bug-fixes:Crashed when opening Navicat on older macOS versions.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 7 2023 Navicat for PostgreSQL (macOS) version 16.3.3 Bug-fixes:Column widths were not retained when opening tables/views.Crashed when scheduling batch jobs in some cases.Primary keys were not displayed for PostgreSQL partitioned tables.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 7 2023 Navicat for PostgreSQL (macOS) version 16.3.2 Bug-fixes:COMMAND-F shortcut did not work in the main window.Refresh button did not work in Server Monitor.Text in the Search box was hidden in some cases.Advanced options in Structure Synchronization cannot be displayed.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 30 2023 Navicat for PostgreSQL (macOS) version 16.3.1 Bug-fixes:Minor bug fixes and improvements.To upgrade, please. 13 4 years ago () Ends in 8 months () 13.20 () 12 More information is available on the PostgreSQL website. Foxpro to PostgreSQL Migration: 4. Informix to PostgreSQL Migration: 5. InterSystems Cache to PostgreSQL Migration: 6. MS Access to PostgreSQL Migration: 7. MS Excel to PostgreSQL Migration: 8. MariaDB to PostgreSQL Migration: 9. Oracle to PostgreSQL Migration: 10. SQL Azure to PostgreSQL Migration: 11. SQL Server to PostgreSQL Migration: 12
PostgreSQL 12 - pgPedia - a PostgreSQL Encyclopedia
Instructions assume EL8 (EL7 should not be used for new installs)If PostgresSQL12: Download the PostgreSQL 12 RPM's for Red Hat Enterprise Linux or CentOS 8, please use the following command to install rpm -ivh postgresql12-12.3-5PGDG.rhel8.x86_64.rpm postgresql12-libs-12.3-5PGDG.rhel8.x86_64.rpm libicu-60.3-2.el8_1.x86_64.rpm libpq-13.3-1.el8_4.x86_64.rpm postgresql12-server-12.3-5PGDG.rhel8.x86_64.rpmOtherwise, install the PosgreSQL server by using yum or downloading directly. See instructions for yum install at: see RPMs at: (then use the yum tutorial for the initialization of the DB). If needed, PGSQL path change:Go to custom mount point (eg: /u01) and create a folder pgsqldata with postgres permissionscd /u01mkdir pgsqldatachown postgres:postgres pgsqldata Then, edit the postgresql servicesystemctl edit postgresql-12.serviceGo to the custom mount point that has the majority of the disk spacecopy and paste the following into that file:[Service]Environment=PGDATA=//pgsqldataOnce edited, run the following commands:systemctl daemon-reload/usr/pgsql-12/bin/postgresql-12-setup initdbsystemctl start postgresql-12.servicesystemctl enable postgresql-12.serviceModify the pg_hba.conf file in //pgsqldata/ to define what authentication method should be used from all networks to the PostgreSQL server and modify the localhost authentication method (change from indent to md5 and change from localhost to accept all incoming requests):From# IPv4 local connections:host all all 127.0.0.1/32 identto# IPv4 local connections:host all all 0.0.0.0/0 md5Modify the postgresql.conf (also in //pgsqldata/ ) file to allow connections from all hosts by uncommenting the following and adding an * instead of localhost:listen_addresses = '*'Restart the PostgreSQL service by typing "service postgresql-12 restart” (or the version that is installed)Create an empty database for JetPatch, and a user with full access to it:su -c "createuser --pwprompt " postgressu -c "createdb -O " postgresIn a production environment, you should also set up TLS-secured communication, and you should consider setting up data replication or snapshot-based backups. Consult the PostgreSQL online manual for these settings. Related articles PostgreSQL Installation using Dnf (EL8 Only) Installing JetPatch RPMs Move JetPatch application and database to new servers Hardware, Software, and Port Requirements PostgreSQL for high availability and replication with Hot StandbyPostgreSQL : Documentation: 12: PostgreSQL 12.22
Which chart: postgresql-ha 3.4.3Describe the bugpostgresql-0 and pgpool pod doesn't start after helm chart installedTo ReproduceSteps to reproduce the behavior:Download postgresql-ha chart and change default value.yaml from values-production.yaml$ helm fetch --untar bitnami/postgresql-ha$ cd postgresql-ha$ cp values.yaml values.yaml.bak$ cp values-production.yaml values.yamlInstall postgresql-ha helm chart with custom yaml.helm install charts/postgresql-ha --name postgresql-ha --namespace fed -f postgresql-values.yamlPod status going to 'CrashLoopbackoff"Log of Pod ** Starting PostgreSQL with Replication Manager setup **postgresql-repmgr 09:12:39.97 INFO ==> Validating settings in REPMGR_* env vars...postgresql-repmgr 09:12:39.97 INFO ==> Validating settings in POSTGRESQL_* env vars..postgresql-repmgr 09:12:39.98 INFO ==> Querying all partner nodes for common upstream node...postgresql-repmgr 09:12:40.06 INFO ==> There are no nodes with primary role. Assuming the primary role...postgresql-repmgr 09:12:40.07 INFO ==> Preparing PostgreSQL configuration...postgresql-repmgr 09:12:40.08 INFO ==> postgresql.conf file not detected. Generating it...postgresql-repmgr 09:12:40.21 INFO ==> Preparing repmgr configuration...postgresql-repmgr 09:12:40.22 INFO ==> Initializing Repmgr...postgresql-repmgr 09:12:40.22 INFO ==> Initializing PostgreSQL database...postgresql-repmgr 09:12:40.23 INFO ==> Cleaning stale /bitnami/postgresql/data/postmaster.pid filepostgresql-repmgr 09:12:40.24 INFO ==> Custom configuration /opt/bitnami/postgresql/conf/postgresql.conf detectedpostgresql-repmgr 09:12:40.25 INFO ==> Custom configuration /opt/bitnami/postgresql/conf/pg_hba.conf detectedpostgresql-repmgr 09:12:40.29 INFO ==> Deploying PostgreSQL with persisted data...postgresql-repmgr 09:12:40.32 INFO ==> Configuring replication parameterspostgresql-repmgr 09:12:40.38 INFO ==> Configuring fsyncpostgresql-repmgr 09:12:40.40 INFO ==> Stopping PostgreSQL...postgresql-repmgr 09:12:40.41 INFO ==> ** PostgreSQL with Replication Manager setup finished! **postgresql-repmgr 09:12:40.45 INFO ==> Starting PostgreSQL in background...postgresql-repmgr 09:12:40.91 INFO ==> ** Starting repmgrd **[2020-07-21 09:12:40] [NOTICE] repmgrd (repmgrd 5.1.0) starting up[2020-07-21 09:12:40] [ERROR] connection to database failed[2020-07-21 09:12:40] [DETAIL]could not translate host name "postgresql-ha-postgresql-0.postgresql-ha-postgresql-headless.fed.svc.cluster.local" to address: Name or service not known[2020-07-21 09:12:40] [DETAIL] attempted to connect using: user=repmgr password=9Vg72MGKkg connect_timeout=5 dbname=repmgr host=postgresql-ha-postgresql-0.postgresql-ha-postgresql-headless.fed.svc.cluster.local port=5432 fallback_application_">$ kubectl logs -n fed postgresql-ha-postgresql-0 postgresql -fpostgresql-repmgr 09:12:39.90postgresql-repmgr 09:12:39.90 Welcome to the Bitnami postgresql-repmgr containerpostgresql-repmgr 09:12:39.90 Subscribe to project updates by watching 09:12:39.91 Submit issues and feature requests at 09:12:39.91postgresql-repmgr 09:12:39.94 INFO ==> ** Starting PostgreSQL with Replication Manager setup **postgresql-repmgr 09:12:39.97 INFO ==> Validating settings in REPMGR_* env vars...postgresql-repmgr 09:12:39.97 INFO ==> Validating settings in POSTGRESQL_* env vars..postgresql-repmgr 09:12:39.98 INFO ==> Querying all partner nodes for common upstream node...postgresql-repmgr 09:12:40.06 INFO ==> There are no nodes with primary role. Assuming the primary role...postgresql-repmgr 09:12:40.07 INFO ==> Preparing PostgreSQL configuration...postgresql-repmgr 09:12:40.08 INFO ==> postgresql.conf file not detected. Generating it...postgresql-repmgr 09:12:40.21 INFO ==> Preparing repmgr configuration...postgresql-repmgr 09:12:40.22 INFO ==> Initializing Repmgr...postgresql-repmgr 09:12:40.22 INFO ==> Initializing PostgreSQL database...postgresql-repmgr 09:12:40.23 INFO ==> Cleaning stale /bitnami/postgresql/data/postmaster.pid filepostgresql-repmgr 09:12:40.24 INFO ==> Custom configuration /opt/bitnami/postgresql/conf/postgresql.conf detectedpostgresql-repmgr 09:12:40.25 INFO ==> Custom configuration /opt/bitnami/postgresql/conf/pg_hba.conf detectedpostgresql-repmgr 09:12:40.29 INFO ==> Deploying PostgreSQL with persisted data...postgresql-repmgr 09:12:40.32 INFO ==> Configuring replication parameterspostgresql-repmgr 09:12:40.38 INFO ==> Configuring fsyncpostgresql-repmgr 09:12:40.40 INFO ==> Stopping PostgreSQL...postgresql-repmgr 09:12:40.41 INFO ==> ** PostgreSQL with Replication Manager setup finished! **postgresql-repmgr 09:12:40.45 INFO ==> Starting PostgreSQL in background...postgresql-repmgr 09:12:40.91 INFO ==> ** Starting repmgrd **[2020-07-21 09:12:40] [NOTICE] repmgrd (repmgrd 5.1.0) starting up[2020-07-21 09:12:40] [ERROR] connection to database failed[2020-07-21 09:12:40] [DETAIL]could not translate host name "postgresql-ha-postgresql-0.postgresql-ha-postgresql-headless.fed.svc.cluster.local" to address: Name or service not known[2020-07-21 09:12:40] [DETAIL] attempted to connect using: user=repmgr password=9Vg72MGKkg connect_timeout=5 dbname=repmgr host=postgresql-ha-postgresql-0.postgresql-ha-postgresql-headless.fed.svc.cluster.local port=5432 fallback_application_Expected behaviorpostgresql pod start normally.Version of Helm and Kubernetes:Output of helm version:$ helm versionClient: &version.Version{SemVer:"v2.16.7", GitCommit:"5f2584fd3d35552c4af26036f0c464191287986b", GitTreeState:"clean"}Server: &version.Version{SemVer:"v2.16.7", GitCommit:"5f2584fd3d35552c4af26036f0c464191287986b", GitTreeState:"clean"}Output of kubectl. 13 4 years ago () Ends in 8 months () 13.20 () 12 More information is available on the PostgreSQL website.install postgresql-12 in CentOS-8 got No match for argument
Versionshinweise Wenn Sie unsere Produkte gekauft haben und die Downloadinformationen der neuesten Version abrufen möchten, dann klicken Sie bitte hier.Hinweis: Nur in Englisch verfügbar. Mar 13 2025 Navicat for PostgreSQL (Windows) version 17.2.2 Main New Features:Support AI AssistantData Modeling supports Data Vault and Dimensional modeling methodsBI data source supports data profilingFilter & Sort pane in Table Viewer supports Text modeSome minor bug fixes and usability improvementsTo upgrade, please visit our Customer Center. Feb 6 2025 Navicat for PostgreSQL (Windows) version 17.1.13 Bug-fixes:Error occurred when saving changes in PostgreSQL Function.Crashed when reversing PostgreSQL schema to model.Undoing changes in a function incorrectly cleared all code.Time values imported from Access database were incorrect.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 16 2024 Navicat for PostgreSQL (Windows) version 17.1.12 Bug-fixes:The "New Table" column was empty when dragging and dropping a file to import.Access Violation error occurred when copying procedure results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 10 2024 Navicat for PostgreSQL (Windows) version 16.3.12 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 28 2024 Navicat for PostgreSQL (Windows) version 16.3.11 Bug-fixes:PostgreSQL timestamp data were exported incorrectly.Crashed when backing up PostgreSQL schema in some cases."ERROR: more than one row returned by a subquery used as an expression" error occurred when opening PostgreSQL tables.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 20 2024 Navicat for PostgreSQL (Windows) version 17.1.11 Bug-fixes:Unable to backup with Automation.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 12 2024 Navicat for PostgreSQL (Windows) version 17.1.10 Bug-fixes:Multi-line editing did not work in Query Editor.Crashed when deleting "My Connections".Crashed when copying UPDATE statements from query results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 4 2024 Navicat for PostgreSQL (Windows) version 17.1.9 Bug-fixes:Crashed when sorting data.Incorrect database name assigned when using "Synchronize Database To Model"."Invalid Stored Procedure Syntax" error occurred when saving PostgreSQL functions.Unable to change primary key name.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 28 2024 Navicat for PostgreSQL (Windows) version 17.1.7 Bug-fixes:Unable to display Chinese characters in the bookmark outline of the data dictionary PDF file.Unable to import Access file when 32-bit Office installed.The Fields pane always displayed when opening table.Incorrect CREATE INDEX statement was displayed in the DDL pane.Column sizes did not persist when refreshing table.Crashed when using "Filter & Sort".Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 8 2024 Navicat for PostgreSQL (Windows) version 17.1.5 Bug-fixes:Response was slow when hovering over the menu bar.Crashed when starting Navicat in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 27 2024 Navicat for PostgreSQL (Windows)Comments
Computer HardwareMinimum Requirement: 64-bit Windows: Any Intel or AMD quad-core processor with 4GB of RAM. Mac: Almost any Mac that runs macOS 10.15 or later released in 2014+ with 4GB of RAM.Recommended: 64-bit Windows: Modern Intel or AMD quad-core processor with 8GB of RAM or greater. Mac: Any Mac that runs macOS 12 or later with 8GB of RAM and an SSD.Optimal: Windows: 64-bit Windows: Any 6+ core Intel or AMD with 16GB of RAM or greater. Mac: Any Apple Silicon MacNot Recommended: Less than four cores. Less than 8GB of RAM. A disk hard drive.Operating SystemMinimum Requirement: 64-bit Windows: Windows 7/8. Mac: macOS 10.15 CatalinaRecommended: 64-bit Windows: Windows 10+. Mac: macOS 12 Monterey (or newer)Optimal: 64-bit Windows: Windows 10/11 with 64-bit PostgreSQL 12.x manually installed. Mac: macOS 14 with PostgreSQL 64-bit 12.x manually installedPostgreSQLMinimum Requirement: PostgreSQL 9.3 or greaterRecommended: The latest version of 64-bit PostgreSQL 16Optimal: The latest version of 64-bit PostgreSQL 16 with 8 GB of RAM or better for optimal performance.Hard DriveThe number one factor for speed performance is hard drive speed, the PostgreSQL Server which powers the PokerTracker database commonly moves gigabytes of data to allow PokerTracker 4 to perform it's reporting duties. PokerTracker recommends at least a 7200RPM hard drive or faster, Solid State Drives (SSDs) are currently the fastest drives available for optimal performance. The optimal solution for Mac users are computers that contains a built in SSD drive.
2025-04-15Hi Postgress,I used to have a functioning PostgreSQL database, but upon reinstalling due to computer issues, I am now getting this error after launching:Traceback (most recent call last): File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 98, in app = create_app() File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app if not os.path.exists(SQLITE_PATH) or get_version() == -1: File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version return version.valueAttributeError: 'NoneType' object has no attribute 'value'I've tried everything from these stackoverflow forums ( and in order to fix it, however the error remains. I'm out of options, hopefully you know the answer.I tried it with both PostgreSQL 11, 12 and 13. I'm using a windows 64 bit with PgAdmin 4.Kind regards,Derek[ - pgadmin4 : postgresql application server could not be contacted. - Stack Overflow have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_distro.py, and delete the files in Roaming folder,i tried standalone pgadmin4 installation, but no success.However, in my local ...stackoverflow.com
2025-04-09Convert any data source to convert any data source5 MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. It includes the following utilities: (1) Access-to-MySQL - migrates MS Access database to MySQL server; (2) DB2-to-MySQL - migrates IBM DB2 databases to MySQL server;(3) DBF-to-MySQL - moves DBase (dbf) databases to MySQL server;(4) Excel-to-MySQL - converts MS Excel spreadsheet into MySQL database; (5) MSSQL-to-MySQL - migrates MS SQL database to MySQL server; (6) MySQL-to-Access - converts MySQL database into MS Access format; (7) MySQL-to-DB2 - migrates MySQL databases to IBM DB2 server;(8) MySQL-to-DBF - converts MySQL databases into DBase (dbf) format;(9) MySQL-to-Excel - converts MySQL database into MS Excel spreadsheet; (10) MySQL-to-MSSQL - migrates MySQL database to MS SQL server; (11) MySQL-to-Oracle - migrates MySQL database to Oracle server; (12) MySQL-to-PostgreSQL - migrates MySQL database to PostgreSQL server; (13) Oracle-to-MySQL - migrates Oracle database to MySQL server;(14) PostgreSQL-to-MySQL - migrates PostgreSQL database to MySQL server.
2025-04-16Download PostgreSQL 17.4 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 17.3 Date released: 14 Feb 2025 (4 weeks ago) Download PostgreSQL 17.2 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 17.1 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 17.0 Date released: 26 Sep 2024 (6 months ago) Download PostgreSQL 16.8 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 16.6 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 16.5 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 16.4 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 16.3 Date released: 10 May 2024 (10 months ago) Download PostgreSQL 16.1 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.12 Date released: 22 Feb 2025 (3 weeks ago) Download PostgreSQL 15.10 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 15.9 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 15.8 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 15.5 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.4 Date released: 11 Aug 2023 (one year ago) Download PostgreSQL 15.3 Date released: 12 May 2023 (one year ago) Download PostgreSQL 15.2 Date released: 10 Feb 2023 (2 years ago) Download PostgreSQL 15.1 Date released: 10 Nov 2022 (2 years ago)
2025-03-31Navicat for PostgreSQL (macOS) version 17.1.7 Bug-fixes:Unable to backup with Automation.Crashed when finding data in query results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 12 2024 Navicat for PostgreSQL (macOS) version 17.1.6 Bug-fixes:Time delay when reporting errors.Wrongly displayed German in UI.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 8 2024 Navicat for PostgreSQL (macOS) version 17.1.5 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 2 2024 Navicat for PostgreSQL (macOS) version 17.1.4 Bug-fixes:Unable to copy multiple columns in the data viewer.Lost focus when updating row value.Unable to open database connection after VPN disconnected/reconnected.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 10 2024 Navicat for PostgreSQL (macOS) version 17.1.3 Main New Features:All-New Model WorkspaceData ProfilingData DictionaryQuery Pinned ResultVisual Query ExplainTable ProfileNavicat URIManage ConnectionEnhanced BI FeatureFocus ModeSupport Alibaba Cloud PolarDB for PostgreSQLMany other new features and improvementsTo upgrade, please visit our Customer Center. May 9 2024 Navicat for PostgreSQL (macOS) version 16.3.9 Bug-fixes:Column headers were not aligned in the data grid.Cannot open PostgreSQL tables in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Apr 23 2024 Navicat for PostgreSQL (macOS) version 16.3.8 Bug-fixes:Crashed when transferring PostgreSQL data in some cases.The screen scrolled to the left after refreshing the data in Data Viewer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 4 2024 Navicat for PostgreSQL (macOS) version 16.3.7 Bug-fixes:Crashed when PostgreSQL connection was lost.Modified data types were not retained when switching to other tables in Import Wizard.Unable to connect using ssh agent in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 9 2024 Navicat for PostgreSQL (macOS) version 16.3.5 Bug-fixes:Crashed when closing Server Monitor.Crashed when switching tabs on Information Pane.The percentage values shown in the chart were incorrect.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 12 2023 Navicat for PostgreSQL (macOS) version 16.3.4 Bug-fixes:Crashed when opening Navicat on older macOS versions.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 7 2023 Navicat for PostgreSQL (macOS) version 16.3.3 Bug-fixes:Column widths were not retained when opening tables/views.Crashed when scheduling batch jobs in some cases.Primary keys were not displayed for PostgreSQL partitioned tables.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 7 2023 Navicat for PostgreSQL (macOS) version 16.3.2 Bug-fixes:COMMAND-F shortcut did not work in the main window.Refresh button did not work in Server Monitor.Text in the Search box was hidden in some cases.Advanced options in Structure Synchronization cannot be displayed.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 30 2023 Navicat for PostgreSQL (macOS) version 16.3.1 Bug-fixes:Minor bug fixes and improvements.To upgrade, please
2025-03-30Instructions assume EL8 (EL7 should not be used for new installs)If PostgresSQL12: Download the PostgreSQL 12 RPM's for Red Hat Enterprise Linux or CentOS 8, please use the following command to install rpm -ivh postgresql12-12.3-5PGDG.rhel8.x86_64.rpm postgresql12-libs-12.3-5PGDG.rhel8.x86_64.rpm libicu-60.3-2.el8_1.x86_64.rpm libpq-13.3-1.el8_4.x86_64.rpm postgresql12-server-12.3-5PGDG.rhel8.x86_64.rpmOtherwise, install the PosgreSQL server by using yum or downloading directly. See instructions for yum install at: see RPMs at: (then use the yum tutorial for the initialization of the DB). If needed, PGSQL path change:Go to custom mount point (eg: /u01) and create a folder pgsqldata with postgres permissionscd /u01mkdir pgsqldatachown postgres:postgres pgsqldata Then, edit the postgresql servicesystemctl edit postgresql-12.serviceGo to the custom mount point that has the majority of the disk spacecopy and paste the following into that file:[Service]Environment=PGDATA=//pgsqldataOnce edited, run the following commands:systemctl daemon-reload/usr/pgsql-12/bin/postgresql-12-setup initdbsystemctl start postgresql-12.servicesystemctl enable postgresql-12.serviceModify the pg_hba.conf file in //pgsqldata/ to define what authentication method should be used from all networks to the PostgreSQL server and modify the localhost authentication method (change from indent to md5 and change from localhost to accept all incoming requests):From# IPv4 local connections:host all all 127.0.0.1/32 identto# IPv4 local connections:host all all 0.0.0.0/0 md5Modify the postgresql.conf (also in //pgsqldata/ ) file to allow connections from all hosts by uncommenting the following and adding an * instead of localhost:listen_addresses = '*'Restart the PostgreSQL service by typing "service postgresql-12 restart” (or the version that is installed)Create an empty database for JetPatch, and a user with full access to it:su -c "createuser --pwprompt " postgressu -c "createdb -O " postgresIn a production environment, you should also set up TLS-secured communication, and you should consider setting up data replication or snapshot-based backups. Consult the PostgreSQL online manual for these settings. Related articles PostgreSQL Installation using Dnf (EL8 Only) Installing JetPatch RPMs Move JetPatch application and database to new servers Hardware, Software, and Port Requirements PostgreSQL for high availability and replication with Hot Standby
2025-04-14