How to handle "database is not accepting commands"
I'll explain how to handle the dreaded error message "database is not accepting commands" and alert you to the responses you should avoid.
Debian 13, Postgres, and the US/* time zones
Preparing for the worst: Our core database failover test
On July 24, 2025, we successfully performed a full production failover of our core control-plane database from Azure West US to East US 2 with zero customer impact.
Exploration: Migration to CNPG
This article explains how to migrate a database instance from anywhere to CNPG using pg_basebackup and its limitations for it.
From Rainfall to Rows - The Butterfly Effect in PostgreSQL
Have you ever wondered if the butterfly effect is real? This blogs showcases on a real life example with PostgreSQL at core. Enjoy reading!
Exploration: PostgreSQL Cluster Bootstrapping with initdb(CNPG)
This post explains how to bootstrap custom PostgreSQL databases using CNPG and how connect CNPG databases from outside of the cluster.
Setting Sail: Installing Cloud Native PostgreSQL (CNPG)
This post is an introduction for CNPG(Cloud Native PG) and describes how to create a single instance cluster.
How TimescaleDB helped us scale analytics and reporting
Cloudflare chose TimescaleDB to power its Digital Experience Monitoring and Zero Trust Analytics products. TimescaleDB is a PostgreSQL extension designed for real-time analytics and time series data, and it helped us reduce query latency by 5–35x and cut storage footprint by 33x.
Swiss PGDay 2025 - New experiences, Postgres and Karl!
This blog describes the experience related to Swiss PGday 2025. Dive in and checkout some captivating moments from the event.
The Fun of Open Source: Roman Numerals in PostgreSQL
This article talks about the new support for converting Roman numerals to numbers in PostgreSQL v18, as well as fun in general.
When The Dead Won't Die
How do PostgreSQL's VACUUM optimizations affect dead tuple metrics? Find out why they might persist or reappear when using VACUUM.
From VACUUM to Deutsche Bahn: The Most Unexpected Moments at PGConf.DE 2025
Discover PGCONF.DE VACUUM talk highlights, community moments, and PostgreSQL insights from Christoph Berg’s 2025 conference recap in Berlin.
CYBERTEC at PGConf.DE: Talks, Booth Buzz & PostgreSQL’s New Education Alliance
Discover what CYBERTEC was up to at PGConf.DE 2025, Berlin. Watch out for the launch of the Open Alliance for PostgreSQL Education.
PostgreSQL Trusted Extensions for Beginners
Especially beginners are often having problems concerning the concept of Trusted Extensions. Let's fix that!
Type alignment and padding bytes: how to not waste space in PostgreSQL tables
Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
Indexing vectors in PostgreSQL
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.
Just landed: streaming ingestion on Cloudflare with Arroyo and Pipelines
We’ve just shipped our new streaming ingestion service, Pipelines — and we’ve acquired Arroyo, enabling us to bring new SQL-based, stateful transformations to Pipelines and R2.
Sequential consistency without borders: How D1 implements global read replication
D1, Cloudflare’s managed SQL database, announces read replication beta. In this post, we do a technical deep dive of the read replication implementation and how your queries can remain consistent across all regions.
Your frontend, backend, and database — now in one Cloudflare Worker
You can now deploy static sites and full-stack applications on Cloudflare Workers – the primitives are all here. Framework support for React Router v7, Astro, Vue, and more are generally available today, as is the Cloudflare Vite plugin. Connect to Postgres and MySQL databases with Hyperdrive.
Pools across the sea: how Hyperdrive speeds up access to databases and why we’re making it free
Hyperdrive, Cloudflare's global connection pooler, relies on some key innovations to make your database connections work. We go deep into the details of what that looks like, in celebration of announcing its availability for Free Plan customers.
Cloudflare acquires Outerbase to expand database and agent developer experience capabilities
Cloudflare has acquired Outerbase, expanding our database and agent developer experience capabilities.
Using pgvector for timeseries data
pgvector is a popular PostgreSQL extension for semantic search, facilitating discussions on AI and related topics.
Semantic Search in PostgreSQL: An Overview
PostgreSQL enhances search capabilities with extensions like pgvector, enabling advanced semantic search. Find out more in this blog posting.
Debugging PostgreSQL more easily
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.
PostgreSQL: 1 trillion rows in Citus
"PostgreSQL scales" - what does it mean? Find out what 1 trillion rows in Citus is all about in this blog post.
How To Prevent WordPress SQL Injection Attacks — Smashing Magazine
Have you thought about the security risks WordPress websites face? Anders Johansson explores why they are frequent hacker targets and shares how WordPress SQL injection attacks work and how to remove and prevent them.
stats_fetch_consistency: caching PostgreSQL monitoring statistics?
This article describes the little known parameter stats_fetch_consistency and its potential applications for statistics collection.
PostgreSQL: To normalize or not to normalize?
In this blog posting you can read more about one of the fundamental principles in the realm of databases: "Normalization".
Train the Trainer
PostgreSQL courses are an integral part of all our endeavors. Benefit from our long training experience and become a certified trainer.
End of the road for PostgreSQL streaming replication?
In this blog posting you can read more about PostgreSQL streaming replication. It tells you about how to deal with it and how it works.
AI enhancements to Adaptive Acceptance
Stripe’s AI-powered Adaptive Acceptance increases payment acceptance by recovering false declines. Recent AI upgrades improved transaction retry accuracy, leading to a record $6 billion recovered in 2024—a 60% year-over-year increase.
PostgreSQL Development Introduction
Learn about PostgreSQL development for beginners. Prerequisites: basic C, Git, GNU Make and SQL, and familiarity with the Linux terminal.
Online Training
CYBERTEC offers a broad range of online training. From PostgreSQL beginner to advanced levels, as well as Data Science or Spatial Data:
Quick start: How to build your first PostgreSQL container
Learn to build your first PostgreSQL container and optimize it effectively in our Docker and Kubernetes series.
CYPEX Online Academy - Application Database Section
Learn all about how to use the CYPEX model builder - PostgreSQL database section - queries, permissions, workflows, trigger functions & more.
The Slonik's Gambit
Learn about the technical background of the chess tournament at PG Conf EU 2024 and how to join future tournaments at Postgres conferences.
PostgreSQL for Enterprises
PostgreSQL at an enterprise-level enables professional database management. Comply your enterprise requirements with matching tools.
Migrating billions of records: moving our active DNS database while it’s in use
According to a survey done by W3Techs, as of October 2024, Cloudflare is used as an authoritative DNS provider by 14.5% of all websites
Elephants in tunnels: how Hyperdrive connects to databases inside your VPC networks
Hyperdrive (Cloudflare’s globally distributed SQL connection pooler and cache) recently added support for directing database traffic from Workers across Cloudflare Tunnels. We dive deep on what it took to add this feature.
Building Vectorize, a distributed vector database, on Cloudflare’s Developer Platform
Vectorize was recently upgraded and made generally available, now supporting indexes of up to 5 million vectors, delivering faster responses, with lower pricing and a free tier. This post dives deep into how we built Vectorize to enable these improvements.
Easy guide to writing PostgreSQL extensions
In this blog I will tell you more about PostgreSQL extensions. You will learn how to write your own PostgreSQL extensions from scratch.
What's so great about PostgreSQL v17?
PostgreSQL v17 has been released. If the list of new features does not inspire you, this article will try to change your mind.
Zero-latency SQLite storage in every Durable Object
Traditional cloud storage is inherently slow because it is accessed over a network and must synchronize many clients. But what if we could instead put your application code deep into the storage layer, such that your code runs where the data is stored? Durable Objects with SQLite do just that.
Cloudflare’s bigger, better, faster AI platform
Whether you want the fastest inference at the edge, optimized AI workflows, or vector database-powered RAG, we’re excited to help you harness the full potential of AI and get started on building with Cloudflare.
PGDay Hyderabad 2024 Reflections
In this blog, I would like to tell you more about PGDay Hyderabad 2024. It was my first PostgreSQL conference in India. Find out more...
VACUUM: Managing and detecting bloat
We will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective vacuuming strategies.
Introducing the Vercel Marketplace
The Vercel Marketplace adds support for EdgeDB, Redis, and Supabase with unified billing and simpler installations.
Mitigating Deadlocks in high concurrency environments - Shopify
The problem In order to guarantee data integrity, MySQL requires locks prior to updating existing records. If multiple processes update data in the same table in parallel, deadlocks can occur depending on how the data is stored in disk and managed by MySQL. That can happen even if the different processes target different records. This blog post explores the problem of deadlocks in MySQL while upda
Database industry: The Rise and Rise of PostgreSQL
In this blog I will tell you more about the database industry in general. How did the rise of PostgreSQL come about?
Remote Sinks in pgwatch3 by Akshat Jaimini
I have the pleasure of working on an project that aims to enhance PostgreSQL monitoring through the development of RPC sinks for pgwatch3.
What you should know about Linux memory overcommit in PostgreSQL
Understand why and how to disable memory overcommit to make PostgreSQL run reliably on Linux, including implications for containerization.
Speeding up index creation in PostgreSQL
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.
Using AI to generate data structures for PostgreSQL
In this blog I decided to show some insights into what can be done by using AI to generate data structures for PostgreSQL.
Swiss PGDay 2024 and PG conferences in general
Read about my impressions from the Swiss PGDay 2024 and learn why you should attend PostgreSQL conferences yourself.
Supporting Postgres Named Prepared Statements in Hyperdrive
Hyperdrive (Cloudflare’s globally distributed SQL connection pooler and cache) recently added support for Postgres protocol-level named prepared statements across pooled connections. We dive deep on what it took to add this feature
Making the PostgreSQL visibility map visible
This article explains how to examine the PostgreSQL visibility map and showcases performance improvements added in recent releases.
Foreign keys in PostgreSQL: Circular dependencies
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".
Why do I have a slow COMMIT in PostgreSQL?
This article describes the possible reasons for a slow COMMIT in PostgreSQL and discusses what you can to against that.
Patroni Contributors Meeting 2024 in Munich
Before the pgconf.de, a few contributors to the Patroni project met to discuss the past, present and future of this framework for PostgreSQL HA. Find out more.
Announcing Pages support for monorepos, wrangler.toml, database integrations and more!
Today, we’re launching four improvements to Pages that bring functionality previously restricted to Workers, with the goal of unifying the development experience between the two. Support for monorepos, wrangler.toml, new additions to Next.js support and database integrations
