Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssHN5-007KhV-PF for pgsql-announce@arkaria.postgresql.org; Sun, 22 Sep 2024 07:51:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ssHN3-001mFF-Rl for pgsql-announce@arkaria.postgresql.org; Sun, 22 Sep 2024 07:51:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssHIH-001NV9-CC for pgsql-announce@lists.postgresql.org; Sun, 22 Sep 2024 07:46:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssHIE-000Tag-6N for pgsql-announce@lists.postgresql.org; Sun, 22 Sep 2024 07:46:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=aNYwjsrbXVvdqz8Ujmax+FidC/mtjLqpSzrPj7z6eeA=; b=ef6czocO5qi2ZYT2n3ELoUtb33 iLxGhADlHVKVlxIyCz34N3bI1DL7drUl1AC/2HBdUvH6E+jqNBPcHvu4sK+WeVspHg5aBAH9UdjMq Z4XbTp8bdOruO+5AKUqvy9usXBCGaVnJrfSbfgygTLQmAsH8sfWHw455G8U1OFVau2Y1PTt5XAvmK cZc3jaldB32vlSLxwawVR0HXk+vGnqpOd4ii3VQ/LIk0WItpKLUgEnkdYKFh2iZE6nedJjLvu6PJr 0Hw+dr/A3cx4kcjdCqqwmCPEP0UdW3ZbBlYFhiUuHfsWee7IH8OddKAZCDVU9xWmXz+ynM0Eyd7Cs SU2huqAg==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssHID-001QCj-MT for pgsql-announce@lists.postgresql.org; Sun, 22 Sep 2024 07:46:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ssHIA-002R6Z-Mw for pgsql-announce@lists.postgresql.org; Sun, 22 Sep 2024 07:46:02 +0000 Content-Type: multipart/mixed; boundary="===============4034100122888561175==" MIME-Version: 1.0 Subject: =?utf-8?q?pgEdge_Distributed_PostgreSQL=3A_The_Next_Generation_=E2=80=94_Introducing_pgEdge_Platform_v24=2E7=2C_Constellation_Release?= To: PostgreSQL Announce From: "pgEdge, Inc. via PostgreSQL Announce" Reply-To: cto@pgedge.com Date: Sun, 22 Sep 2024 07:46:02 +0000 Message-ID: <172699116221.694.16510648631457275357@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: proprietary X-pglister-tagsig: b641af4b3021c5ce84e72db16183732eb8972fe07f76bb8c92b09ed036f40262 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4034100122888561175== Content-Type: multipart/alternative; boundary="===============4514286747849629381==" MIME-Version: 1.0 --===============4514286747849629381== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgEdge has just released the latest version of its flagship product, pgEdge= Platform v24.7, known as the Constellation Release. This update brings a h= ost of new features designed to enhance the capabilities of distributed Pos= tgreSQL databases. Building on its foundation as the only fully distributed= PostgreSQL that is open (source code available) and based on standard Post= greSQL, pgEdge continues to lead the way in providing ultra-high availabili= ty and reduced latency across geographic regions. The Constellation Release= introduces significant improvements, including advanced logical replicatio= n features, large object support, and enhanced error handling. These enhanc= ements make pgEdge an even more powerful alternative for legacy multi-maste= r replication technologies, offering greater throughput, flexibility, and c= ontrol for users. Key Enhancements in the Constellation Release 1. Large Object Logical Replication (LOLOR): With the new Large Object Logi= cal Replication (LOLOR) feature, pgEdge ensures seamless integration for ap= plications that store media assets and large files in PostgreSQL databases.= This extension allows large objects to be compatible with logical replicat= ion, facilitating smoother transitions from legacy databases to PostgreSQL = without requiring application modifications. See blog for more details. 2. Replication Exception Handling and Logging: The latest update includes a= n advanced error handling and logging mechanism. Replication errors are log= ged into a new exception table, preventing disruptions in replication proce= sses. This enhancement ensures a robust user experience, offering greater v= isibility and control over replication errors and making troubleshooting mo= re straightforward.=20 3. Replication Repair Mode: pgEdge now allows users to enable or disable "r= epair mode," providing the flexibility to manage replication processes with= out affecting the entire database cluster. This feature is particularly use= ful for controlling replication changes during error resolution or node-spe= cific modifications. 4. Automatic Replication of DDL Commands: Updating the database schema has = never been easier. With the automatic replication of DDL commands, any chan= ges made to a single node are propagated across all nodes in the cluster. T= his feature simplifies the management of distributed PostgreSQL application= s, especially during active development or maintenance. See blog for more = details. 5. Snowflake Sequence in Postgres Extension: To enhance sequence management= in multi-master replication scenarios, pgEdge integrates Snowflake sequenc= es within PostgreSQL. This extension ensures unique sequence numbers across= different regions without needing application code or schema modifications= , streamlining sequence management and improving scalability. See blog for= details and examples. Looking Ahead: High Performance Parallel Replication pgEdge is set to introduce Parallel Replication in Q4 of this year. This fe= ature will leverage multiple replication slots to enable parallel processin= g within distributed PostgreSQL clusters, significantly boosting replicatio= n throughput. It promises to reduce replication lag, ensuring timely data s= ynchronization across nodes and maintaining data consistency even in high-d= emand environments. Availability and Support The pgEdge Platform can be self-hosted on-premise or self-managed in the cl= oud with providers like AWS, Microsoft Azure, and Google Cloud Platform. T= he new Constellation Release is available for download at [https://www.pged= ge.com/get-started/platform](https://www.pgedge.com/get-started/platform) o= r can be accessed via GitHub. pgEdge also offers enterprise-class support.= Additionally, pgEdge Cloud, a fully managed service based on the pgEdge Pl= atform, is available in beta and will be generally available in Q3. View the full press release here: [https://www.pgedge.com/press-releases/pg= edge-announces-pgedge-platform-constellation-release-v24-7](https://www.pge= dge.com/press-releases/pgedge-announces-pgedge-platform-constellation-relea= se-v24-7), or visit [www.pgedge.com](https://www.pgedge.com) for more infor= mation about pgEdge distributed PostgreSQL. --===============4514286747849629381== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgEdge Distributed PostgreSQL: The Next Generation =E2=80=94 Int= roducing pgEdge Platform v24.7, Constellation Release
 

pgEdge Distributed PostgreSQL: The Next Generation =E2=80=94 Introduc= ing pgEdge Platform v24.7, Constellation Release

pgEdge has just released the latest version= of its flagship product, pgEdge Platform v24.7, known as the Constellation= Release. This update brings a host of new features designed to enhance the= capabilities of distributed PostgreSQL databases. Building on its foundati= on as the only fully distributed PostgreSQL that is open (source code avail= able) and based on standard PostgreSQL, pgEdge continues to lead the way in= providing ultra-high availability and reduced latency across geographic re= gions. The Constellation Release introduces significant improvements, inclu= ding advanced logical replication features, large object support, and enhan= ced error handling. These enhancements make pgEdge an even more powerful al= ternative for legacy multi-master replication technologies, offering greate= r throughput, flexibility, and control for users.

Key Enhancements in the Constellation Relea= se 1. Large Object Logical Replication (LOLOR): With the new Large Object Logi= cal Replication (LOLOR) feature, pgEdge ensures seamless integration for ap= plications that store media assets and large files in PostgreSQL databases.= This extension allows large objects to be compatible with logical replicat= ion, facilitating smoother transitions from legacy databases to PostgreSQL = without requiring application modifications. See blog for more details.

  1. Replication Exception Handling and Logging:= The latest update includes an advanced error handling and logging mechanis= m. Replication errors are logged into a new exception table, preventing dis= ruptions in replication processes. This enhancement ensures a robust user e= xperience, offering greater visibility and control over replication errors = and making troubleshooting more straightforward.

  2. Replication Repair Mode: pgEdge now allows = users to enable or disable "repair mode," providing the flexibility to mana= ge replication processes without affecting the entire database cluster. Thi= s feature is particularly useful for controlling replication changes during= error resolution or node-specific modifications.

  3. Automatic Replication of DDL Commands: Upda= ting the database schema has never been easier. With the automatic replicat= ion of DDL commands, any changes made to a single node are propagated acros= s all nodes in the cluster. This feature simplifies the management of distr= ibuted PostgreSQL applications, especially during active development or mai= ntenance. See blog for more details.

  4. Snowflake Sequence in Postgres Extension: T= o enhance sequence management in multi-master replication scenarios, pgEdge= integrates Snowflake sequences within PostgreSQL. This extension ensures u= nique sequence numbers across different regions without needing application= code or schema modifications, streamlining sequence management and improvi= ng scalability. See blog for details and examples.

Looking Ahead: High Performance Parallel Re= plication pgEdge is set to introduce Parallel Replication in Q4 of this year. This fe= ature will leverage multiple replication slots to enable parallel processin= g within distributed PostgreSQL clusters, significantly boosting replicatio= n throughput. It promises to reduce replication lag, ensuring timely data s= ynchronization across nodes and maintaining data consistency even in high-d= emand environments.

Availability and Support The pgEdge Platform can be self-hosted on-premise or self-managed in the cl= oud with providers like AWS, Microsoft Azure, and Google Cloud Platform. T= he new Constellation Release is available for download at https://www.pgedge.com/get-started/platform or can be = accessed via GitHub. pgEdge also offers enterprise-class support. Addition= ally, pgEdge Cloud, a fully managed service based on the pgEdge Platform, i= s available in beta and will be generally available in Q3.

View the full press release here: https://www.pgedge.com/press-releases/pgedge-announces-pgedge-platfo= rm-constellation-release-v24-7, or visit www.pgedge.com for more information about pgEdge distributed PostgreSQL.
This email was sent to you from pgEdge, Inc.. It was delivered on their beh= alf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to pgEdge, Inc..

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Proprietary. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============4514286747849629381==-- --===============4034100122888561175==--