< Back to blog home Fujitsu PostgreSQL blog

Fujitsu PostgreSQL Blog listing page

|

The latest PostgreSQL 15 release brings significant improvements to logical replication, which fortifies CREATE/ ALTER PUBLICATION capabilities, and benefits by enhancing security, improving ease of use, and reducing network traffic.

PostgreSQL 15 introduced a crucial change regarding permission checks in logical replication, to avoid a potential security violation. Let me show you how this improvement works.

The latest version of the popular open-source database management system, PostgreSQL 15, has made significant changes to its statistics collector. The new changes aim to improve its accuracy and efficiency, making it easier for database administrators to monitor and optimize their PostgreSQL databases.

In this post, I would like to highlight the OSS enhancements to pg_basebackup inherited by Fujitsu Enterprise Postgres 15 that enrich the native backup utility and how the new --target and --compress options can be leveraged for database administration and operations.

Fujitsu Enterprise Postgres was a proud sponsor of PG Conf India this past month, where over 400 attendees, representing 60 cities, across 10 countries travelled to Bangalore in India. Over three days, guests engaged in training workshops,  Lightning Talks, and presentations encapsulating the latest contributions, knowledge sharing, updates, and hot topics in the wider open-source PostgreSQL...

Earlier this week, we announced the launch of Fujitsu Enterprise Postgres 15, with enhanced capabilities to manage enterprise data across multiple environments with security, agility, and flexibility. In this post, I will highlight some of the new features available in this release, with examples comparing it with the previous release.

Fujitsu continues to keep in step with the needs of enterprise-level environments with the proud launch of Fujitsu Enterprise Postgres 15. The highly anticipated release boasts additional features developed with the end user in mind, ensuring clients are provided with a hybrid multi-cloud solution that meets their business critical requirements head on.

A new feature introduced in PostgreSQL 15 allows tuning the name of the application used by postgres_fdw. In this post, I will talk about the background of this feature and how you can use it to better identify which application executed each SQL statement on a foreign server.

Last month, I was proud to talk about the internals of logical replication to a room full of PostgreSQL enthusiasts at PGConf India 2023. In case you missed it, let's go through it together.

PostgreSQL 15 builds upon the enhancements of earlier versions and takes them to the next level, with several improvements to logical replication, increased sorting  performance, and the introduction of the MERGE command. I would like to talk about these features as well as what is under discussion for PostgreSQL 16.

PostgreSQL 15 doesn’t disappoint. Upon arrival of the new release, the long-awaited MERGE feature will be delivered. It may not have been with the speed of light, but right on time like a door dash delivery.

New features introduced in PostgreSQL 15 allow selective publication of tables' contents within logical replication publications, through the ability to specify column lists and row filter conditions. Let's see how they affect performance.

After a long season of no in-person events due the pandemic, I can say with certainty that attending the Open Source Summit event in Dublin along with my fellow Fujitsu representatives was not only thoroughly enjoyable, but also a great opportunity to catch up with the community. Here are my thoughts.

PostgreSQL 15 introduces a new feature that allows specifying column lists in publications, to restrict the amount of data replicated. Let's see what are the advantages of this feature and how to use it.

Together, Fujitsu and IBM are helping clients build a modern environment that is designed to improve business agility and reduce overall costs by leveraging the next generation of IBM LinuxONE’s highly secured and sustainable platform. Read more here.

Fujitsu has worked with PostgreSQL community to make some improvements to the communication of logical replication in PostgreSQL 15. Let me show you some details. 

The planet has been warming at a steady pace and it's projected to keep doing so. While technology has played a part in this situation, it can become part of the solution.

Fujitsu has worked with the PostgreSQL community to add a new feature that filters rows for logical replication. This allows users to create customized logical replication solutions that replicate row data only when it matches a specified filter expression.

In this blog post I conclude my discussion on the new mechanisms available in PostgreSQL to handle logical replication conflicts by explaining how to use the ALTER SUBSCRIPTION SKIP command.

Logical replication is widely used as an easy and flexible way to replicate data. And now PostgreSQL makes it even easier by providing some mechanisms to handle replication conflicts. Let me show you how.

The concept of data portability is relevant not only as part of the regulatory framework governing customer data privacy - it is also important for organizations moving data across applications and hybrid cloud. Let me show you how.

We are pleased to announce that Fujitsu Enterprise Postgres is now available on IBM Power^®, the platform that makes it easier to adopt the hybrid cloud and modernize your applications.

The upcoming PostgreSQL 15 introduces a new feature added by the Fujitsu OSS team in collaboration with the PostgreSQL open source community that allows supporting of two-phase commits in logical replication using publications/subscriptions. Let's take a look at how to use it.

In this post I would like to discuss the new feature added to the upcoming PostgreSQL 15 by the Fujitsu OSS team in collaboration with the PostgreSQL open source community, to enable logical replication of tables in a schema.

In this blog post I will explain the new system view pg_stat_replication_slots introduced in PostgreSQL, and how you can use it to obtain information on logical replication in your system.

I would like to talk about the key features in PostgreSQL 14, and what is being discussed in the community for PostgreSQL 15 and beyond.

The new column compression option LZ4 introduced in PostgreSQL 14 provides faster compression. How can I use it, and how much faster is it? 

The Fujitsu OSS team, in collaboration with other OSS community members, has been contributing code to enhance Logical Replication for PostgreSQL.

Several factors have traditionally been prohibitive for the rapid adoption of a hybrid cloud strategy in the Financial Services Industry. That should no longer be the case, and I want to explain why.

Agility is a key element for success. This is why I am excited to introduce the newest option for your next agile data platform, featuring Fujitsu Enterprise Postgres with SUSE Linux Enterprise on IBM Z / LinuxONE systems.

The Fujitsu OSS team in collaboration with the PostgreSQL open source community has added support in PostgreSQL 14 to enable decoding of two-phase commits in logical replication. Let's take a look at what it can do.

The usability of the libpq feature to trace application's server/client communications has been enhanced in PostgreSQL 14, with an improved format and an option to control output.

Fujitsu announces that Fujitsu Enterprise Postgres for Kubernetes is now available through Red Hat Marketplace.

Almost every financial services institution claims to have implemented DevOps in some way, shape or form - but only a few seem to have achieved a true DevOps model.

In this post, I will discuss the enhancements that will be added to the database connection setting target_session_attrs in PostgreSQL 14, explain the history behind this feature, how it can be used, and the various benefits it provides.

Currently, the global PostgreSQL development team, led by Amit Kapila, continues to contribute to the community as part of Fujitsu's work on PostgreSQL.

Currently, the global PostgreSQL development team, led by Amit Kapila, continues to contribute to the community as part of Fujitsu's work on PostgreSQL.

Our global PostgreSQL Development Team, now headed by Amit Kapila, is making continuous contributions in the community, as part of Fujitsu's commitment to PostgreSQL. 

PostgreSQL users are no longer limited to a single type of access to tables, thanks to table access methods. But what is this feature and how can you benefit from it?

In my previous post, I discussed the new features in PostgreSQL 13 and what's in the pipeline for PostgreSQL 14. Today I would like to set my sights further, and discuss longer-term development.

PostgreSQL has recently released version 13, with new features and enhancements. Let me share my views on this release, and what is to come next.

Fujitsu is excited to welcome PostgreSQL Committer and Major Contributor Amit Kapila, now leading our PostgreSQL team as Senior Director at Fujitsu Limited since August 2020.

Fujitsu Enterprise Postgres on IBM LinuxONE delivers maximum data security for your organization, and CryptoCards are big part of the reason why. But what are CryptoCards, and how do I protect my organization's data with them?

Fastest. Most secure. Most reliable.

We are happy to announce that we are releasing PostgreSQL Insider - a new section on our site with a series of technical articles and how-to's on Postgres.

We are pleased to announce Fujitsu Enterprise Postgres on IBM LinuxONE

The value of data has increased exponentially in the last few years, to the point that it is now called the oil of the new industry. But so has the risk of data breaches.

This year PGDay Down Under (PGDU) will happen in Sydney, gathering leading experts and enthusiasts, and also people curious about PostgreSQL.

See how Fujitsu Enterprise Postgres can run C and COBOL legacy systems so you can have your data and a more agile system too.

A few weeks back, I discussed how Transparent Data Encryption safeguards your data even in case an attacker gets hold of your files. So this week I would like to talk about how PostgreSQL maps database objects into actual files. Let's dive in. 

The pace of new digital technology is quickly changing the way authorities collect and use data. How might this change society in the near future?

Information Technology security is getting more complex each time I visit the subject. This just makes it harder for Security Specialists, whose role is to ensure that all potential threats are mitigated across the myriad of hardware, firmware, and software that make up a modern Enterprise Infrastructure. 

The PostgreSQL community gathered again in Ottawa for PGCon 2019 to discuss all things PostgreSQL, and I had the opportunity to talk about our work with pluggable table access methods.

Servers these days are pretty reliable and can go long periods of time between restarts — but when a restart of several machines does occur, we don't want to find out that services haven't started up by hearing it from our customers.

Customers are increasingly aware that their data is highly valued by organisations. Progressive IT teams are taking action to respond.

Ensure your data load process makes the best use of available resources without the need to pre-configure and tune your environment. Fujitsu Enterprise Postgres can help.

With dedicated audit logging you can have an open source database strategy and still deliver compliance. 

As the risk of data breaches continues to grow, it is important to re-evaluate how to better secure customer data.

In today’s IT world, the need for both the flexibility of Cloud and DevOps is in stark contrast with the increasing need for data security and consumer data protection.

The Open Banking conference, sponsored by Fujitsu, aims to help financial sector executives ready their organisations for the new open banking era starting July 2020.

Open banking is already a reality in many countries, bringing innovation for customers and opportunities for banks and financial institutions.

Micro-services bring with them a range of benefits for your organisation - make sure that you take full advantage by choosing the right type of data persistence.

Your business’ ability to unlock ideas and use them to create opportunities is perhaps the most vital factor for staying relevant in our fast-changing digital economy.

See how the Mirroring Controller in Fujitsu Enterprise Postgres works to ensure business continuity when an abnormality is detected.

Open source database technology can help a DevOps approach deliver apps and software faster than ever before. Here's why.

PGDay Down Under (PGDU) is on in Melbourne for data professionals and enthusiasts whether experienced in PostgreSQL or considering it for future applications.

PostgreSQL could change the database market just as Linux did operating systems. 

Increasingly, in-house and enterprise-packaged applications are being built with PostgreSQL.

PGCon 'unconferences' are now a critical part of the PostgreSQL development process. Here's why. 

Database management systems often fall short when it comes to delivering high performance across both business transactions and analytical queries. Fujitsu has a solution. 

Consider Fujitsu Enterprise Postgres when you're required to deliver both new solutions and services plus operational efficiencies. Here's why. 

Here are six specific things you can do to save faith with your customers should your organisation incur a data breach. 

Get 10 tips for data administrators and risk managers to ensure they are ready for the new Notifiable Data Breaches (NDB) scheme in Australia.

Here are three ways your data can become vulnerable to attack, and what you could do about it.

PGConf APAC in Singapore brought the PostgreSQL community together. Here are the tips I presented to tune PostgreSQL for better data protection. 

Attend PGConf APAC 2018 and hear my outline of the PostgreSQL features that can help you comply with new data breach laws.

There has been a significant change in Australian privacy laws that every enterprise and executive needs to be aware of.

Fujitsu is proud to be a Platinum Partner of PGConf APAC in Singapore, 22-23 March 2018. Register now. 

New data breach laws in Australia and Europe are making Data Masking critical for organisations that retain personal data, such as those in government, health and financial sectors.

There is always a bit of mystery around the different memory components of a PostgreSQL instance.

Spectre and Meltdown are unlikely to exploit the operating system through PostgreSQL. However, the hardware patch can slow down performance. 

Data migration can be a lot more complicated than you expect. Here's why, and what to do about it. 

There are many aspects to the ongoing performance of PostgreSQL that your internal Dev team may not know.

PostgreSQL achieves significant gain in popularity to win Database Management System of the Year for 2017, according to DB-Engines.

Digital transformation demands the type of database migrations that have become increasingly more complex. You need to minimise the risk. 

Your organisation’s ability to create a new idea and develop it into a business opportunity is the key driver of success in today’s digital economy. 

PGDay Australia successfully ignited the PostgreSQL community across our region, and saw the launch of PostgreSQL Down Under Inc.

Open source is perhaps the best way to develop software.

Here's why converging open source database platforms with commercial software can create an optimum world.

Fujitsu Australia Software Technology supports Camp Quality and Australian Golf. 

Here's how to resolve the problem of the pg_wal location (once known as pg_xlog) running out of disk space.

I've recently come to appreciate the advantages of centralising authentication and authorisation when it comes to databases.

Join me at PGDay Australia 2017 to see how easy it is to contribute to the PostgreSQL community.

Need is the mother of all Inventions!! This is very true for PostgreSQL 10 Logical Replication.

By using a BRIN index instead of a BTREE index for certain queries, I can get huge index size savings with very similar performance.

Congratulations to the PostgreSQL Global Development Group for the significant release of PostgreSQL 10.

Fujitsu Australia Software Technology is a platinum sponsor and co-organiser of PGDay Australia. Register Today!

Reduced operating costs, impressive scalability and the inherent transparency of open source software are just the beginning.

I was recently asked where PostgreSQL actually stores data on disk. So it's time to share this...

Knowing the difference between Developer skills and Support skills is crucial when faced with mission-critical situations.

Fujitsu World Tour 2017 arrived in Auckland and Melbourne with PostgreSQL-based solutions on show.

Some of the world’s finest PostgreSQL minds recently met in Canada for PGCon 2017. Fujitsu’s Haribabu Kommi provides a look inside this event.

Haribabu Kommi, Senior Software Development Engineer at FAST, shares his insights into the PostgreSQL community and what he hopes to achieve at PGCon 2017.

Couldn’t make it to Singapore for this exciting PostgreSQL event? Fujitsu’s Gary Evans shares his experience as guest lecturer.

When your key developer is too busy solving database queries to do any developing, it’s time to take a closer look at the real cost of running PostgreSQL support internally.

This year’s pgDay Asia conference is in Singapore on March 17-18, 2017, and Fujitsu is proud to be a Platinum sponsor.

Tired of constantly running checks on your PostgreSQL activity as it happens? Save time and energy with \watch.

Bring the strength of Elasticsearch to your next PostgreSQL project – it’s surprisingly easy.

Extensions are a great way to broaden the functionality of PostgreSQL. One of the most popular is PostGIS.

Protecting clients' data has long been an immediate concern of mine as it probably is for you. Which is why I'm excited by Data Masking.

Keeping a step ahead of data thieves is an ongoing battle. Thankfully we have an impressive weapon on our side – encrypted tablespaces.

Your PostgreSQL database is almost certainly reliable and doing the job well. However, there’s always room for improved performance. Here are five great places to start.

According to IDC, less than 5% of the $27 billion spent on security products directly addresses the issue of data centre security.

PostgreSQL, or Postgres as it is often known, is an advanced open source database with a long development history. Fujitsu has been one of the key contributors to its success.