Postgresql 10 15
Author: c | 2025-04-25
PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 Services
PostgreSQL 15 - pgPedia - a PostgreSQL Encyclopedia
The PostgreSQL database versions 14 and 15. While version 15 is the default, version 14 is still provided through the Legacy module for upgrades from earlier versions of SUSE Linux Enterprise Server. Because of the required migration work of the database, there is no automatic upgrade process. As such, the switch from one version to another needs to be performed manually. The migration process is conducted by the pg_upgrade command, which is an alternative method of the classic dump and reload. In comparison with the “dump and reload” method, pg_upgrade makes the migration less time-consuming. The program files for each PostgreSQL version are stored in different, version-dependent directories. For example, in /usr/lib/postgresql96/ for version 9.6, in /usr/lib/postgresql10/ for version 10, and in /usr/lib/postgres13/ for version 13. Note that the versioning policy of PostgreSQL has changed between the major versions 9.6 and 10. For details, see Important: Upgrading from SLE 11 When upgrading from SLE 11, postgresql94 will be uninstalled and cannot be used for the database migration to a higher PostgreSQL version. Therefore, in this case, make sure to migrate the PostgreSQL database before you upgrade your system. The procedure below describes the database migration from version 12 to 13. When using a different version as start or target, replace the version numbers accordingly. To perform the database migration, do the following: Make sure the following preconditions are fulfilled: If not already done, upgrade any package of the old PostgreSQL version to the latest release through a maintenance update. Create a backup of your existing database. Install the packages for the new PostgreSQL major version. For SLE 15 SP5, this means installing postgresql13-server and all the packages it depends on. Install the package postgresql13-contrib, which contains the command pg_upgrade. Make sure you have enough free space in your PostgreSQL data
PostgreSQL : Documentation: 10: E.15. Release 10.9
2022 Navicat for PostgreSQL (macOS) version 15.0.34 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 10 2022 Navicat for PostgreSQL (macOS) version 15.0.33 Bug-fixes:Missing zero padding in year when exporting data to CSV / TXT file.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 10 2021 Navicat for PostgreSQL (macOS) version 15.0.32 Bug-fixes:Crashed when running scripts in some cases.Crashed when copying records in some cases.The TEXT pane did not retain when running queries.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 19 2021 Navicat for PostgreSQL (macOS) version 15.0.30 Bug-fixes:Unable to show the cursor when editing TEXT data using Form View in Dark Mode.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 29 2021 Navicat for PostgreSQL (macOS) version 15.0.29 Bug-fixes:Crashed when running query in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. May 3 2021 Navicat for PostgreSQL (macOS) version 15.0.28 Bug-fixes:Crashed when adding a trigger to PostgreSQL model.Crashed when using Data Transfer in some cases.Cursor did not focus to the Search box after pressing CMD-F.Crashed when selecting the "Group by Object Type" in Structure Synchronization.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 8 2021 Navicat for PostgreSQL (macOS) version 15.0.26 Bug-fixes:Unable to read grid data in Dark mode.Unable to sort the last column by clicking the column header in Table Viewer.Duplicate entry error occurred when editing the pasted records.Unable to connect to server via SSH Tunnel in some cases.Hanged when starting Navicat in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 14 2021 Navicat for PostgreSQL (macOS) version 15.0.25 Bug-fixes:'Primary key needs to be integer' error occurred when synchronizing data.Unable to sort by clicking the column header in Table Viewer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 22 2020 Navicat for PostgreSQL (macOS) version 12.1.31 Bug-fixes:Crashed when modifying PostgreSQL permissions.Data Synchronization UX issue.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 15 2020 Navicat for PostgreSQL (macOS) version 15.0.24 Improvements:Set the values of a column to NULL.Bug-fixes:The modified dates of backup files were incorrect.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 12 2020 Navicat for PostgreSQL (macOS) version 15.0.22 Bug-fixes:Only the last selected table was printed when printing multiple tables.The SQL Editor was flickered and repainted when saving the query.Crashed when using Query Builder on Big Sur.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 15 2020 Navicat for PostgreSQL (macOS) version 15.0.21 Bug-fixes:The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.The field size was incorrect in FormHow to Install PostgreSQL 15 on Windows 10 - YouTube
Reading package lists... Donetimetrex@ubuntu-18-04-stock:~$ sudo apt-get install /var/cache/apt/archives/TimeTrex_Community_Edition.deb Reading package lists... DoneBuilding dependency tree Reading state information... DoneNote, selecting 'timetrex-community-edition' instead of '/var/cache/apt/archives/TimeTrex_Community_Edition.deb'The following additional packages will be installed: apache2 apache2-bin apache2-data apache2-utils aspell aspell-en dbconfig-common dbconfig-pgsql fontconfig-config fonts-dejavu-core libapache2-mod-php7.2 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libaspell15 libc-client2007e libcurl4 libfontconfig1 libgd3 libgdbm-compat4 libjbig0 libjpeg-turbo8 libjpeg8 liblua5.2-0 libnghttp2-14 libperl5.26 libpq5 librtmp1 libsensors4 libsodium23 libtiff5 libwebp6 libxpm4 libxslt1.1 libzip4 mlock perl perl-modules-5.26 php php-bcmath php-cgi php-common php-curl php-fpm php-gd php-gettext php-igbinary php-imap php-intl php-ldap php-mbstring php-pear php-pgsql php-php-gettext php-pspell php-redis php-soap php-xml php-zip php7.2 php7.2-bcmath php7.2-cgi php7.2-cli php7.2-common php7.2-curl php7.2-fpm php7.2-gd php7.2-imap php7.2-intl php7.2-json php7.2-ldap php7.2-mbstring php7.2-opcache php7.2-pgsql php7.2-pspell php7.2-readline php7.2-soap php7.2-xml php7.2-zip postgresql postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common ssl-cert sysstatSuggested packages: www-browser apache2-doc apache2-suexec-pristine | apache2-suexec-custom aspell-doc spellutils uw-mailutils libgd-tools lm-sensors perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make redis-server postgresql-doc locales-all postgresql-doc-10 libjson-perl openssl-blacklist isagThe following NEW packages will be installed: apache2 apache2-bin apache2-data apache2-utils aspell aspell-en dbconfig-common dbconfig-pgsql fontconfig-config fonts-dejavu-core libapache2-mod-php7.2 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libaspell15 libc-client2007e libcurl4 libfontconfig1 libgd3 libgdbm-compat4 libjbig0 libjpeg-turbo8 libjpeg8 liblua5.2-0 libnghttp2-14 libperl5.26 libpq5 librtmp1 libsensors4 libsodium23 libtiff5 libwebp6 libxpm4 libxslt1.1 libzip4 mlock perl perl-modules-5.26 php php-bcmath php-cgi php-common php-curl php-fpm php-gd php-gettext php-igbinary php-imap php-intl php-ldap php-mbstring php-pear php-pgsql php-php-gettext php-pspell php-redis php-soap php-xml php-zip php7.2 php7.2-bcmath php7.2-cgi php7.2-cli php7.2-common php7.2-curl php7.2-fpm php7.2-gd php7.2-imap php7.2-intl php7.2-json php7.2-ldap php7.2-mbstring php7.2-opcache php7.2-pgsql php7.2-pspell php7.2-readline php7.2-soap php7.2-xml php7.2-zip postgresql postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common ssl-cert sysstat timetrex-community-edition0 upgraded, 88 newly installed, 0 to remove and 4 not upgraded.Need to get 26.1 MB/37.7 MB of archives.After this operation, 122 MB of additional disk space will be used.Do you want to continue? [Y/n] yGet:1 bionic-updates/main amd64 perl-modules-5.26 all 5.26.1-6ubuntu0.2 [2,762 kB]Get:2 /var/cache/apt/archives/TimeTrex_Community_Edition.deb timetrex-community-edition all 11.2.6 [11.6 MB]Get:3 bionic/main amd64 libgdbm-compat4 amd64 1.14.1-6 [6,084 B]Setting up timetrex-community-edition (11.2.6) ...Configuring database...dbconfig-common: writing config to /etc/dbconfig-common/timetrex.confCreating config file /etc/dbconfig-common/timetrex.conf with new versionCreating config file /usr/share/timetrex/dbcommon-config/database.inc.sh with new versioncreating postgres user timetrex: success.verifying creation of user: success.creating database timetrex: success.verifying database timetrex exists: success.dbconfig-common: flushing administrative passwordAutomatic configuration using dbconfig-common successful!Setting up Apache...Using config for PHP Module: >7.0Configuring maintenance jobs with CRON...Configuring file permissions...###########################################################################################To finish the installation process and initialize the databasepoint your web browser to this servers URL and append '/timetrex/' to the end of it. For example: ###########################################################################################Setting up php (1:7.2+60ubuntu1) ... msquires Posts: 15 Joined: Tue Aug 21, 2018 6:08 pm Re: Ubuntu Server 18.04.1 error after installing the ZIP Option Post by msquires » Tue Aug. PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 ServicesPostgreSQL Guide: Getting Started with PostgreSQL 15
FxSQL - Node.js Functional SQL Query Builder & ORMEN | KRFeaturesTagged template literalNo models.Only need functions and javascript data types.Promise.No cost for converting to JSON.More freedom in using SQL syntax.Preventing SQL-injection attacks.Easy to use the latest operators provided in databases.Simple transaction API.No models for Associations.Designed to work well with PostgreSQL, MySQL.OverviewInstallationConnect (pool)PostgreSQLMySQLClosing all the connections in a poolSimple querySubquery, JoinReady to be usedHelper FunctionEQINNOT_INVALUESSETCOLUMN, CLTABLE, TBAssociationsCommon usePolymorphicTransactionMany to manyROW_NUMBER + PARTITIONHookASSOCIATE_MODULEOptionDEBUGInstallationConnect (pool)PostgreSQLconst { PostgreSQL } = require("fxsql");const { CONNECT } = PostgreSQL;const POOL = CONNECT({ host: 'localhost', user: 'username', password: '1234', database: 'dbname'});PostgreSQL Connection optionFxSQL is built on node-postgres. The parameter of CONNECT function is the same as node-postgres’. You can read the detail of connection pool or connecting to DB on node-postgres’ site.MySQLconst { MySQL } = require("fxsql");const { CONNECT } = MySQL;const POOL = CONNECT({ host: 'localhost', user: 'username', password: '1234', database: 'dbname'});MySQL Connection optionFxSQL is built on node-postgres. The parameter of CONNECT function is the same as the MySQL’. You can read the detail of connection pool or connecting to DB on MySQL's site.Closing all the connections in a poolPostgreSQL, MySQLSimple queryconst { QUERY } = POOL;const id = 10;const posts = await QUERY `SELECT * FROM posts WHERE id = ${id}`;// [{ id: 10, ... }]Subquery, Joinconst type = 'TYPE1';const limit = 10;QUERY ` SELECT * FROM table1 WHERE table2_id IN ( SELECT id FROM table2 WHERE type = ${type} ORDER BY id DESC LIMIT ${limit} )`;const status = 'STATUS1';QUERY ` SELECT * FROM table1 AS t1, table2 AS t2 WHERE t1.id = t2.table1_id AND t1.status = ${status} ORDER BY id DESC LIMIT 10`;QUERY achieved from CONNECT uses a connection pool.Ready to be usedconst POOL = CONNECT();const { VALUES, IN, NOT_IN, EQ, SET, COLUMN, CL, TABLE, TB, SQL, FxSQL_DEBUG, QUERY, ASSOCIATE, LJOIN, TRANSACTION, END} = POOL;Helper-FunctionEQconst users = await QUERY `SELECT * FROM users WHERE ${EQ({ email: 'dev@marpple.com', password: '1234'})}`;// [{ id: 15, email: 'dev@marpple.com', ... }]INconst users = await QUERY `SELECT * FROM users WHERE ${IN('id', [15, 19, 20, 40])}`;// [{ id: 15, ...}, { id: 19, ...} ...]NOT_INconst users = await QUERY `SELECT *PostgreSQL: Documentation: 15: 19.6. Upgrading a PostgreSQL
12.3 can be considered complete. However, because the initial upgrade attempt failed and left behind a partial PostgreSQL deployment, during the second upgrade attempt, the installer will have detected that PostgreSQL deployment and skipped installing PostgreSQL. This failure to install PostgreSQL leads to the issue described in KB4653, wherein the Microsoft Entra ID backup repository is left unconfigured. We recommend that you uninstall the partial PostgreSQL 15 deployment. You can verify it's a partial deployment of PostgreSQL 15 because the service postgresql-x64-15 will not be present. If you plan to use Microsoft Entra ID backup, you'll need to create a PostgreSQL 15 instance and configure the Microsoft Entra ID backup repository yourself. Keep in mind that you'll need to enable Windows Script Host to install PostgreSQL. Also, you can use the PostgreSQL installer included on the Veeam Backup & Replication ISO (D:\Redistr\x64\PostgreSQL\15.10-1). After you deploy a PostgreSQL 15 instance to act as the Microsoft Entra ID backup repository, remember to review the Adjusting PostgreSQL Instance Configuration for advice on ensuring the PostgreSQL instance is configured for optimal performance to handle the backup load. To submit feedback regarding this article, please click this link: Send Article FeedbackTo report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.PostgreSQL : Documentation: 15: PostgreSQL 15.12 Documentation
Its own set of tables. How Citus Works Learn how Citus works in this talk about Citus table types, the PostgreSQL extension APIs, the Citus query planner, and performance benchmarks comparing multi-node Citus clusters to a single node. Citus Deep Dive What’s New in Citus? Frequently Asked Questions Citus Version Compatible with PostgreSQL 5.2 9.5 only 6.x 9.5, 9.6 7.x 9.6, 10 8.x 10, 11 9.0-9.4 11, 12 9.5 11, 12, 13 10.0.x 11, 12, 13 10.1.x 12, 13 10.2.x 12, 13, 14 11.0.x 13, 14 11.1.x, 11.2.x, 11.3.x 13, 14, 15 12.0 14, 15 12.1 14, 15, 16 13.0 15, 16, 17 Citus achieves order-of-magnitude faster execution compared to vanilla PostgreSQL through a combination of parallelism, keeping more data in memory, and higher I/O bandwidth. Citus enables real-time interaction with large datasets that span billions of records—and is a good fit for customer-facing workloads that often require low-latency response times. Performance increases as you add nodes to a Citus database cluster. This 15-min performance demo from SIGMOD shows how Citus speeds up Postgres, using the HammerDB benchmark. Recently GigaOm published a benchmark performance report for Citus. Find out why benchmarking databases is so hard in this blog post by the lead engineer for Citus. Columnar storage can speed up analytics workloads that benefit from compression, too. The easiest way to start is by utilizing schema-based sharding, which assumes assigning each tenant to a separate schema. Citus then automatically distributes these among the nodes in your cluster and routes queries accordingly. The only change you will need to do in your application is to SET search_path when switching tenants. In some cases like with microservices, even that change may not be necessary if every microservice uses a separate user matching their schema name. If you want the best performance, row-based sharding, using a distribution column is the best approach. The first step in migrating an application from Postgres to Citus is to choose your distribution column (sometimes called a distribution key, or a sharding key.) You’ll want to understand your workload in order to pinpoint a “good” distribution column, e.g.,Postgresql installation on redhat 7 and Postgresql 15
The following is a list of tools that automatically expose a REST, GraphQL, or another kind of API for your database, as well as databases with a built-in HTTP API. Project name/link Database(s) supported API type Implementation language License GitHub stats Notes Apinizer API Creator Oracle, MySQL, PostgreSQL, MsSQL, IBM DB2, SAP Sybase ASE, Apache Impala, Apache Hive REST Java Proprietary (SaaS) n/a Generates OpenAPI Specifications. ArangoDB ArangoDB REST C++ Apache-2.0 13637 ★; 51753 commits, latest 2025-01-08 A database with a built-in REST API.Official Docker image. CouchDB CouchDB REST Erlang Apache-2.0 6346 ★; 13855 commits, latest 2025-01-07 A database with a built-in REST API.Official Docker image. Datasette SQLite 3 REST Python 3 Apache-2.0 9702 ★; 2664 commits, latest 2025-01-01 Read-only.Official Docker image. DB2Rest PostgreSQL, MySQL, MariaDB, Oracle, CockroachDB REST Java Apache-2.0 257 ★; 1363 commits, latest 2024-12-15 Official Docker image. Dgraph Dgraph GraphQL (since version 2.0.0-rc1) Go Apache-2.0 20571 ★; 6240 commits, latest 2025-01-08 A database with a built-in GraphQL API.Official Docker image. Directus PostgreSQL, MySQL, SQLite, OracleDB, CockroachDB, MariaDB, MS SQL REST and GraphQL TypeScript Propretary (BUSL-1.1), GPL-3.0 (after three years) 28616 ★; 12491 commits, latest 2025-01-08 Official Docker image. DreamFactory MySQL, PostgreSQL, SQLite, MongoDB, CouchDB, andothers. REST PHP 5 Apache-2.0, proprietary (optional extras) 1573 ★; 1140 commits, latest 2024-05-16 Official Docker image. EJDB2 EJDB2 REST C MIT 1447 ★; 2849 commits, latest 2024-12-02 A database with a built-in REST API.Official Docker image. Eve MongoDB; extensions for Elasticsearch, Neo4j, SQLAlchemy (SQL databases). REST Python 2/3 BSD-3-Clause 6711 ★; 3403 commits, latest 2024-10-15 The SQLAlchemy extension isn't automatic.It requires the user to write SQLAlchemy mappings. GraphJin Service PostgreSQL, MySQL, Yugabyte GraphQL Go Apache-2.0 2942 ★; 936 commits, latest 2024-09-06 Using GraphJin as a standlone service.Official Docker image. GraphQL Mesh PostgreSQL (PostGraphile), MongoDB (graphql-compose-mongoose), SQLite 3 (tuql), Neo4j (Neo4j GraphQL Library), MySQL GraphQL TypeScript (Node.js) MIT 3319 ★; 8054 commits, latest 2025-01-08 Provides a common GraphQL gateway for different APIs and databases. Hasura GraphQL Engine PostgreSQL, MS SQL, MySQL, Snowflake, and others GraphQL, REST Haskell Apache-2.0 31260 ★; 9148 commits, latest 2025-01-08 Official Docker image. HTSQL MySQL, PostgreSQL, SQLite (free); Oracle, MS SQL (proprietary) REST Python 3 Apache-2.0, proprietary (Oracle and MS SQL support) 25 ★; 1235 commits, latest 2020-08-11 InfluxDB InfluxDB REST Go MIT 29283 ★; 49443 commits, latest 2025-01-08 A timeseries database with a built-in REST API.Official Docker image. neo4j-graphql Neo4j GraphQL Kotlin Apache-2.0 449 ★; 164 commits, latest 2020-10-22 Can generate a GraphQL API from an existing databaseor derive a new database model from a GraphQL schema and auto-generate the resolvers. NocoDB MySQL, PostgreSQL, SQL Server, SQLite REST JavaScript (Node.js) MIT 50728 ★; 26350 commits, latest 2025-01-08 Official Docker image. OrientDB OrientDB REST Java Apache-2.0 4762 ★; 25944 commits, latest 2025-01-07 A database with a built-in REST API.Official Docker image. PHP-CRUD-API MySQL, PostgreSQL, MS SQL Server. REST PHP 7 MIT 3635 ★; 2154 commits, latest 2024-11-22 Supports GIS + automatic OpenAPI 3.0 docs. PostGraphile PostgreSQL GraphQL TypeScript (Node.js) MIT 12645 ★; 11461 commits, latest 2025-01-07 Formerly "PostGraphQL".Official Docker. PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 Services
PostgreSQL : Documentation: 15: PostgreSQL 15.10 Documentation
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)PostgreSQL: Documentation: 15: 1. What Is PostgreSQL?
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 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 15 ServicesPostgreSQL 15 - pgPedia - a PostgreSQL Encyclopedia
Version:$ kubectl versionClient Version: version.Info{Major:"1", Minor:"17", GitVersion:"v1.17.6", GitCommit:"d32e40e20d167e103faf894261614c5b45c44198", GitTreeState:"clean", BuildDate:"2020-05-20T13:16:24Z", GoVersion:"go1.13.9", Compiler:"gc", Platform:"linux/amd64"}Server Version: version.Info{Major:"1", Minor:"17", GitVersion:"v1.17.6", GitCommit:"d32e40e20d167e103faf894261614c5b45c44198", GitTreeState:"clean", BuildDate:"2020-05-20T13:08:34Z", GoVersion:"go1.13.9", Compiler:"gc", Platform:"linux/amd64"}Additional contextThis is my postgresql-values.yaml for configureglobal: storageClass: rbdpersistence: enabled: true accessModes: - ReadWriteOnce size: 20GipostgresqlPassword: passwordThis is status about postgresql-ha's resources. 5432/TCP 54mservice/postgresql-ha-postgresql ClusterIP 10.233.47.112 5432/TCP 54mservice/postgresql-ha-postgresql-headless ClusterIP None 5432/TCP 54mservice/postgresql-ha-postgresql-metrics ClusterIP 10.233.62.61 9187/TCP 54mNAME READY UP-TO-DATE AVAILABLE AGEdeployment.apps/postgresql-ha-pgpool 0/1 1 0 54mNAME DESIRED CURRENT READY AGEreplicaset.apps/postgresql-ha-pgpool-55b676799b 1 1 0 54mNAME READY AGEstatefulset.apps/postgresql-ha-postgresql 0/2 54m$ kubectl get pvc -n fedNAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS AGEdata-postgresql-ha-postgresql-0 Bound pvc-5ccf33a1-cfdb-4b68-b9c3-efdb68c30798 20Gi RWO rbd 54m">$ kubectl get all -n fedNAME READY STATUS RESTARTS AGEpod/postgresql-ha-pgpool-55b676799b-qqq64 0/1 Running 18 54mpod/postgresql-ha-postgresql-0 1/2 CrashLoopBackOff 15 54mNAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGEservice/postgresql-ha-pgpool ClusterIP 10.233.8.232 5432/TCP 54mservice/postgresql-ha-postgresql ClusterIP 10.233.47.112 5432/TCP 54mservice/postgresql-ha-postgresql-headless ClusterIP None 5432/TCP 54mservice/postgresql-ha-postgresql-metrics ClusterIP 10.233.62.61 9187/TCP 54mNAME READY UP-TO-DATE AVAILABLE AGEdeployment.apps/postgresql-ha-pgpool 0/1 1 0 54mNAME DESIRED CURRENT READY AGEreplicaset.apps/postgresql-ha-pgpool-55b676799b 1 1 0 54mNAME READY AGEstatefulset.apps/postgresql-ha-postgresql 0/2 54m$ kubectl get pvc -n fedNAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS AGEdata-postgresql-ha-postgresql-0 Bound pvc-5ccf33a1-cfdb-4b68-b9c3-efdb68c30798 20Gi RWO rbd 54mComments
The PostgreSQL database versions 14 and 15. While version 15 is the default, version 14 is still provided through the Legacy module for upgrades from earlier versions of SUSE Linux Enterprise Server. Because of the required migration work of the database, there is no automatic upgrade process. As such, the switch from one version to another needs to be performed manually. The migration process is conducted by the pg_upgrade command, which is an alternative method of the classic dump and reload. In comparison with the “dump and reload” method, pg_upgrade makes the migration less time-consuming. The program files for each PostgreSQL version are stored in different, version-dependent directories. For example, in /usr/lib/postgresql96/ for version 9.6, in /usr/lib/postgresql10/ for version 10, and in /usr/lib/postgres13/ for version 13. Note that the versioning policy of PostgreSQL has changed between the major versions 9.6 and 10. For details, see Important: Upgrading from SLE 11 When upgrading from SLE 11, postgresql94 will be uninstalled and cannot be used for the database migration to a higher PostgreSQL version. Therefore, in this case, make sure to migrate the PostgreSQL database before you upgrade your system. The procedure below describes the database migration from version 12 to 13. When using a different version as start or target, replace the version numbers accordingly. To perform the database migration, do the following: Make sure the following preconditions are fulfilled: If not already done, upgrade any package of the old PostgreSQL version to the latest release through a maintenance update. Create a backup of your existing database. Install the packages for the new PostgreSQL major version. For SLE 15 SP5, this means installing postgresql13-server and all the packages it depends on. Install the package postgresql13-contrib, which contains the command pg_upgrade. Make sure you have enough free space in your PostgreSQL data
2025-03-272022 Navicat for PostgreSQL (macOS) version 15.0.34 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 10 2022 Navicat for PostgreSQL (macOS) version 15.0.33 Bug-fixes:Missing zero padding in year when exporting data to CSV / TXT file.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 10 2021 Navicat for PostgreSQL (macOS) version 15.0.32 Bug-fixes:Crashed when running scripts in some cases.Crashed when copying records in some cases.The TEXT pane did not retain when running queries.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 19 2021 Navicat for PostgreSQL (macOS) version 15.0.30 Bug-fixes:Unable to show the cursor when editing TEXT data using Form View in Dark Mode.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 29 2021 Navicat for PostgreSQL (macOS) version 15.0.29 Bug-fixes:Crashed when running query in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. May 3 2021 Navicat for PostgreSQL (macOS) version 15.0.28 Bug-fixes:Crashed when adding a trigger to PostgreSQL model.Crashed when using Data Transfer in some cases.Cursor did not focus to the Search box after pressing CMD-F.Crashed when selecting the "Group by Object Type" in Structure Synchronization.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 8 2021 Navicat for PostgreSQL (macOS) version 15.0.26 Bug-fixes:Unable to read grid data in Dark mode.Unable to sort the last column by clicking the column header in Table Viewer.Duplicate entry error occurred when editing the pasted records.Unable to connect to server via SSH Tunnel in some cases.Hanged when starting Navicat in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 14 2021 Navicat for PostgreSQL (macOS) version 15.0.25 Bug-fixes:'Primary key needs to be integer' error occurred when synchronizing data.Unable to sort by clicking the column header in Table Viewer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 22 2020 Navicat for PostgreSQL (macOS) version 12.1.31 Bug-fixes:Crashed when modifying PostgreSQL permissions.Data Synchronization UX issue.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 15 2020 Navicat for PostgreSQL (macOS) version 15.0.24 Improvements:Set the values of a column to NULL.Bug-fixes:The modified dates of backup files were incorrect.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 12 2020 Navicat for PostgreSQL (macOS) version 15.0.22 Bug-fixes:Only the last selected table was printed when printing multiple tables.The SQL Editor was flickered and repainted when saving the query.Crashed when using Query Builder on Big Sur.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 15 2020 Navicat for PostgreSQL (macOS) version 15.0.21 Bug-fixes:The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.The field size was incorrect in Form
2025-04-08FxSQL - Node.js Functional SQL Query Builder & ORMEN | KRFeaturesTagged template literalNo models.Only need functions and javascript data types.Promise.No cost for converting to JSON.More freedom in using SQL syntax.Preventing SQL-injection attacks.Easy to use the latest operators provided in databases.Simple transaction API.No models for Associations.Designed to work well with PostgreSQL, MySQL.OverviewInstallationConnect (pool)PostgreSQLMySQLClosing all the connections in a poolSimple querySubquery, JoinReady to be usedHelper FunctionEQINNOT_INVALUESSETCOLUMN, CLTABLE, TBAssociationsCommon usePolymorphicTransactionMany to manyROW_NUMBER + PARTITIONHookASSOCIATE_MODULEOptionDEBUGInstallationConnect (pool)PostgreSQLconst { PostgreSQL } = require("fxsql");const { CONNECT } = PostgreSQL;const POOL = CONNECT({ host: 'localhost', user: 'username', password: '1234', database: 'dbname'});PostgreSQL Connection optionFxSQL is built on node-postgres. The parameter of CONNECT function is the same as node-postgres’. You can read the detail of connection pool or connecting to DB on node-postgres’ site.MySQLconst { MySQL } = require("fxsql");const { CONNECT } = MySQL;const POOL = CONNECT({ host: 'localhost', user: 'username', password: '1234', database: 'dbname'});MySQL Connection optionFxSQL is built on node-postgres. The parameter of CONNECT function is the same as the MySQL’. You can read the detail of connection pool or connecting to DB on MySQL's site.Closing all the connections in a poolPostgreSQL, MySQLSimple queryconst { QUERY } = POOL;const id = 10;const posts = await QUERY `SELECT * FROM posts WHERE id = ${id}`;// [{ id: 10, ... }]Subquery, Joinconst type = 'TYPE1';const limit = 10;QUERY ` SELECT * FROM table1 WHERE table2_id IN ( SELECT id FROM table2 WHERE type = ${type} ORDER BY id DESC LIMIT ${limit} )`;const status = 'STATUS1';QUERY ` SELECT * FROM table1 AS t1, table2 AS t2 WHERE t1.id = t2.table1_id AND t1.status = ${status} ORDER BY id DESC LIMIT 10`;QUERY achieved from CONNECT uses a connection pool.Ready to be usedconst POOL = CONNECT();const { VALUES, IN, NOT_IN, EQ, SET, COLUMN, CL, TABLE, TB, SQL, FxSQL_DEBUG, QUERY, ASSOCIATE, LJOIN, TRANSACTION, END} = POOL;Helper-FunctionEQconst users = await QUERY `SELECT * FROM users WHERE ${EQ({ email: 'dev@marpple.com', password: '1234'})}`;// [{ id: 15, email: 'dev@marpple.com', ... }]INconst users = await QUERY `SELECT * FROM users WHERE ${IN('id', [15, 19, 20, 40])}`;// [{ id: 15, ...}, { id: 19, ...} ...]NOT_INconst users = await QUERY `SELECT *
2025-04-1812.3 can be considered complete. However, because the initial upgrade attempt failed and left behind a partial PostgreSQL deployment, during the second upgrade attempt, the installer will have detected that PostgreSQL deployment and skipped installing PostgreSQL. This failure to install PostgreSQL leads to the issue described in KB4653, wherein the Microsoft Entra ID backup repository is left unconfigured. We recommend that you uninstall the partial PostgreSQL 15 deployment. You can verify it's a partial deployment of PostgreSQL 15 because the service postgresql-x64-15 will not be present. If you plan to use Microsoft Entra ID backup, you'll need to create a PostgreSQL 15 instance and configure the Microsoft Entra ID backup repository yourself. Keep in mind that you'll need to enable Windows Script Host to install PostgreSQL. Also, you can use the PostgreSQL installer included on the Veeam Backup & Replication ISO (D:\Redistr\x64\PostgreSQL\15.10-1). After you deploy a PostgreSQL 15 instance to act as the Microsoft Entra ID backup repository, remember to review the Adjusting PostgreSQL Instance Configuration for advice on ensuring the PostgreSQL instance is configured for optimal performance to handle the backup load. To submit feedback regarding this article, please click this link: Send Article FeedbackTo report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
2025-04-22