Blog

:PostgreSQL Experts

Enterprises are increasingly moving their mission-critical application databases to the cloud. A new white paper from dbInsight discusses this phenomenon and offers a guide to what to look for in a cloud database-as-a-service solution.

Data is the lifeblood of your business, which means that your database management solution is the single most important tech investment your organization will make. But enterprises face a major challenge when deciding how to handle their assets.

Open source and purely commercial databases have been living together for a long time, but the open source model continues to gain more and more momentum. The reasoning in favor of open-source is strong but varying, depending on the license model any ...

Back in the 1980s, the technology world experienced the first wave of open source software, thanks to platforms like Linux. Programmers, hobbyists and other open source proponents loved the nature of a software that could be constantly refined and tw ...

Enterprises are increasingly making the move from Oracle databases to open source Postgres. This complete guide to migration gives you everything you need to know about moving your database from Oracle to Postgres. For anyone on the fence or intim ...

Despite its reputation as one of the top commercial databases on the market, Enterprises are migrating off of Oracle in favor of open source. In fact, open source licenses now outpace legacy proprietary database licenses, and understandably so.

Over the last two days, EDB was thrilled to host thousands of attendees at Postgres Vision 2022. While we were all virtual for another year, the excitement and passion for Postgres and its future was palpable among both presenters and participants.

In order to modernize, government will need to invest in solutions that provide flexibility, agility, security and true control over the data and applications that undergird agencies’ most mission-critical processes.

More exciting news for mysql_fdw users! Previously we have talked about Join pushdown and Aggregate pushdown features in mysql_fdw. A recent mysql_fdw release, 2.8.0, now includes more pushdown features: ORDER BY and LIMIT OFFSET pushdown.

EDB recently hosted a webinar entitled “Why Postgres is Becoming the Standard in Financial Services.” We wanted to explore the reasons for this trend, why they matter to you and what you can do to take advantage of this sea change.

Included in the latest update release from the PostgreSQL Global Development group is a critical fix for a newly disclosed security vulnerability CVE-2022-1552.

In order to better understand how government organizations are currently using Postgres, EDB collaborated with GovLoop on their recent report “How to Future-Proof Your Data Initiatives.”

pgAdmin 4 introduced the Master Password in order to secure and later unlock saved server passwords. Any password that is saved in the SQLite DB file - used for storing user preferences and other data - through the save password or save SSH tunnel password option will be encrypted and decrypted using the master password.

High Availability is more than just choosing the right architecture, replication tools, and failover systems. Storage can play a surprisingly important role in server responsiveness, as can somewhat obscure operating system tuning parameters. This week in PG Phriday, we’re going to examine just how important storage behavior can be to Postgres High Availability.

Mastercard has used an array of database technologies, including Oracle, MySQL, Microsoft SQL Server, Cassandra, Hadoop, DB2 and PostgreSQL, for years. In my role as Lead BizOps Engineer, I support the payment gateway, which Mastercard acquired in 20 ...

The 64th Annual Grammy awards were a showcase for disruption. As an industry that once viewed technologies such as digitization and streaming as threats to creativity and profitability, the Awards demonstrated quite the opposite across the music industry.

Hot on the heels of our discussion on preventing Postgres XID wraparound using basic monitoring, let’s talk about arresting the risk almost entirely through Autovacuum. With a few relatively minor tweaks to our configuration and focusing on the occasional problematic table, we can both increase maintenance throughput, and also reduce impact on client queries. Let’s demystify the art of VACUUM and keep our cluster self-maintaining in the bargain.

In 2019, EDB collaborated with Veritas to help businesses secure their data and protect EDB Postgres Advanced Server via Veritas’ NetBackup™. Now, we’re pleased to announce  Veritas as the latest member of EDB’s growing partner program.

In pursuit of modernizing, many businesses have begun incorporating Postgres into their database infrastructures. As an open source relational database management system (RDBMS), Postgres has become synonymous with innovation since its inception in 1996.

은행 및 금융 서비스(BFSI) 산업은 핀테크가 주도하는 새로운 기술 혁신의 시대로 접어들면서 오픈 뱅킹의 경계를 확장했습니다. Revolut, Robin Hood, Progressive Insurance등의 기업은 해당 산업의 모델을 변경하며 혁신에 보조를 맞추기 위한 새로운 방법을 모색하고 있습니다. 결과적으로 디지털 혁신은 기업들의 피할수 없는 과제로 자리잡고 있습니다. 현대화를 추구하면서 많은 기업이 Postgres를 데이터베이스 ...