Starting after April 26, 2020, all deployments of IBM Cloud Databases for PostgreSQL will have a minor change in the format of PostgreSQL logs emitted into Log Analysis with LogDNA. 

All PostgreSQL logs will now include PostgreSQL error codes as a prefix to the existing log line. This change does not impact performance or increase log verbosity. It will, however, allow customers to trap and alert on log lines based on documented error codes.

An example error code might be the following, where [53100] represents the standard code for “disk_full”: 

2019-11-29 11:09:06 CET dbtest 5de0ed48.25f [53100] disk_full ERROR: could not extend file "pg_tblspc/25193/PG_11_201809051/16387/25194": wrote only 4096 of 8192 bytes at block 14007

Keep in mind that alerting for “Insufficient Resources” error codes should be done with our Monitoring with Sysdig integration or mostly avoided by using autoscaling. 

Learn more about IBM Cloud Databases for PostgreSQL.

Categories

More from Announcements

IBM TechXchange underscores the importance of AI skilling and partner innovation

3 min read - Generative AI and large language models are poised to impact how we all access and use information. But as organizations race to adopt these new technologies for business, it requires a global ecosystem of partners with industry expertise to identify the right enterprise use-cases for AI and the technical skills to implement the technology. During TechXchange, IBM's premier technical learning event in Las Vegas last week, IBM Partner Plus members including our Strategic Partners, resellers, software vendors, distributors and service…

Introducing Inspiring Voices, a podcast exploring the impactful journeys of great leaders

< 1 min read - Learning about other people's careers, life challenges, and successes is a true source of inspiration that can impact our own ambitions as well as life and business choices in great ways. Brought to you by the Executive Search and Integration team at IBM, the Inspiring Voices podcast will showcase great leaders, taking you inside their personal stories about life, career choices and how to make an impact. In this first episode, host David Jones, Executive Search Lead at IBM, brings…

IBM watsonx Assistant and NICE CXone combine capabilities for a new chapter in CCaaS

5 min read - In an age of instant everything, ensuring a positive customer experience has become a top priority for enterprises. When one third of customers (32%) say they will walk away from a brand they love after just one bad experience (source: PWC), organizations are now applying massive investments to this experience, particularly with their live agents and contact centers.  For many enterprises, that investment includes modernizing their call centers by moving to cloud-based Contact Center as a Service (CCaaS) platforms. CCaaS solutions…

See what’s new in SingleStoreDB with IBM 8.0

3 min read - Despite decades of progress in database systems, builders have compromised on at least one of the following: speed, reliability, or ease. They have two options: one, they could get a document database that is fast and easy, but can’t be relied on for mission-critical transactional applications. Or two, they could rely on a cloud data warehouse that is easy to set up, but only allows lagging analytics. Even then, each solution lacks something, forcing builders to deploy other databases for…