# standby

Published articles for standby.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Waiting for PostgreSQL 19 - psql: Add %i prompt escape to indicate hot standby status.

DevFeed: [Waiting for PostgreSQL 19 - psql: Add %i prompt escape to indicate hot standby status.](<https://devfeed.tech/articles/waiting-for-postgresql-19-psql-add-i-prompt-escape-to-indicate-hot-standby-status-33678.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/02/21/waiting-for-postgresql-19-psql-add-i-prompt-escape-to-indicate-hot-standby-status/>)

Author: depesz

Published: 2026-02-21T14:51:47Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [commit](<https://devfeed.tech/tags/commit.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [primary](<https://devfeed.tech/tags/primary.md>), [psql](<https://devfeed.tech/tags/psql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [standby](<https://devfeed.tech/tags/standby.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

### AI overview

The article explains a PostgreSQL 19 patch that adds the %i prompt escape to psql. The escape indicates whether the connected server is a primary or operating in hot standby mode, making replication status visible in the psql prompt.

### Source excerpt

On 3rd of February 2026, Fujii Masao committed patch: psql: Add %i prompt escape to indicate hot standby status. This commit introduces a new prompt escape %i for psql, which shows whether the connected server is operating in hot standby mode. It expands to standby if the server reports in_hot_standby = on, and primary ... Continue reading "Waiting for PostgreSQL 19 - psql: Add %i prompt escape to indicate hot standby status."

## Postgres HA: roles are dynamic

DevFeed: [Postgres HA: roles are dynamic](<https://devfeed.tech/articles/postgres-ha-roles-are-dynamic-34616.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2021/12/postgres-ha-roles-are-dynamic/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2021-12-14T21:36:36Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [rdbms](<https://devfeed.tech/topics/rdbms.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [Resilience](<https://devfeed.tech/topics/resilience.md>), [configuration](<https://devfeed.tech/topics/configuration.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [failover](<https://devfeed.tech/tags/failover.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [independent](<https://devfeed.tech/tags/independent.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [primary](<https://devfeed.tech/tags/primary.md>), [rdbms](<https://devfeed.tech/tags/rdbms.md>), [resilience](<https://devfeed.tech/tags/resilience.md>), [server](<https://devfeed.tech/tags/server.md>), [standby](<https://devfeed.tech/tags/standby.md>)

### AI overview

This article explains why PostgreSQL high-availability systems require dynamic node roles. Failover can promote a standby node to primary, so a node's current role should not be treated as a fixed architectural property. The article also discusses how PostgreSQL configuration and instance initialization affect role changes, and why separate failover-management software is needed.

### Source excerpt

High-Availability comes with some impact on your architecture choices, in particular when applied to RDBMS such as Postgres. One such impact is the idea of a failover. When implementing database HA, it is usually expected that both the service and the data are maintained available in the face of operational faults. The most common way to implement resilience includes automated (or manual) failover, where a new primary is elected among a list of standby nodes. In other words, as soon as Postgres High-Availability is implemented, the roles of your Postgres nodes are dynamic. The fact that a given node is a primary or a standby at any given point in time ceases to be relevant to understanding your architecture. In fact, the only thing that's now given about the role of a node is that it will change. Otherwise you don't have failover capability, and then, you probably don't have HA in the first place, right? In this article we are going to try and understand what having dynamic roles for Postgres nodes in a HA system means.

## PostgreSQL High Availability with Primary and Standby Servers

DevFeed: [PostgreSQL High Availability with Primary and Standby Servers](<https://devfeed.tech/articles/queen-princesses-and-workers-34574.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2017/12/queen-princesses-and-workers/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2017-12-11T09:19:24Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Database](<https://devfeed.tech/topics/database.md>), [Load Balancing](<https://devfeed.tech/topics/load-balancing.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [load-balancing](<https://devfeed.tech/tags/load-balancing.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [primary](<https://devfeed.tech/tags/primary.md>), [replication](<https://devfeed.tech/tags/replication.md>), [standby](<https://devfeed.tech/tags/standby.md>)

### AI overview

This article explains PostgreSQL high-availability architectures using primary and standby servers. It discusses replication, online backups, automated recovery, and promoting a standby server when the primary becomes unavailable.

### Source excerpt

The PostgreSQL community made the explicit choice some times ago that they would not use the infamous master and slave terminology. Instead, the documentation introduces the concepts of High Availability, Load Balancing, and Replication with the terms Primary and Standby, and the even more generic term Replica is used in contexts when only the data flow is considered, rather than the particular role of a node.

## Archiving data as fast as possible

DevFeed: [Archiving data as fast as possible](<https://devfeed.tech/articles/archiving-data-as-fast-as-possible-34504.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/07/archiving-data-as-fast-as-possible/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-07-05T13:30:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Common Lisp](<https://devfeed.tech/topics/common-lisp.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [lisp](<https://devfeed.tech/tags/lisp.md>), [pgq](<https://devfeed.tech/tags/pgq.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [standby](<https://devfeed.tech/tags/standby.md>)

### AI overview

The article describes archiving data from one PostgreSQL table to another using writable common table expressions and a single transaction. It also discusses handling foreign keys, remote archiving, and throttling the process by monitoring replication lag on a Hot Standby server.

### Source excerpt

In a recent article here we've been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I sometime read how Common Table Expressions changed the life of fellow DBAs and developers, and would say that Writable CTE are at least the same boost again.

## PostgreSQL à Amsterdam

DevFeed: [PostgreSQL à Amsterdam](<https://devfeed.tech/articles/postgresql-a-amsterdam-34452.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/09/postgresql-%C3%A0-amsterdam/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-09-27T09:10:00Z

Content type: opinion

Language: fr

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [version](<https://devfeed.tech/topics/version.md>), [business logic](<https://devfeed.tech/topics/business-logic.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [business-logic](<https://devfeed.tech/tags/business-logic.md>), [contributions](<https://devfeed.tech/tags/contributions.md>), [migration](<https://devfeed.tech/tags/migration.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [sql](<https://devfeed.tech/tags/sql.md>), [standby](<https://devfeed.tech/tags/standby.md>), [vacuum](<https://devfeed.tech/tags/vacuum.md>), [version](<https://devfeed.tech/tags/version.md>)

### AI overview

A French blog post previews the European PostgreSQL conference pgconf.eu in Amsterdam, highlighting 2ndQuadrant's training and presentations on PostgreSQL performance, migration, SQL window functions, synchronous replication, durability, VACUUM, and extensions.

### Source excerpt

Dans moins d'un mois se tient la conférence européenne PostgreSQL, pgconf.eu. Il s'agit de quatre jours consacrés à votre SGBD préféré, où vous pourrez rencontrer la communauté européenne, consituée d'utilisateurs, d'entreprises de toutes tailles, de développeurs, de participants en tout genre. C'est l'endroit où aller pour apprendre comment le projet fonctionne, comprendre les impacts des nouvelles versions sur votre architecture, avoir une discussion technique pointue sur cette fonctionalité que vous voudriez voir arriver dans la prochaine version, ou simplement vous rendre compte de l'énergie formidable qui est insuflée dans ce projet !

## Skytools3: walmgr

DevFeed: [Skytools3: walmgr](<https://devfeed.tech/articles/skytools3-walmgr-34455.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/09/skytools3-walmgr/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-09-21T15:21:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [Documentation](<https://devfeed.tech/topics/documentation.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>)

Tags: [backup](<https://devfeed.tech/tags/backup.md>), [debian](<https://devfeed.tech/tags/debian.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [replication](<https://devfeed.tech/tags/replication.md>), [setup](<https://devfeed.tech/tags/setup.md>), [standby](<https://devfeed.tech/tags/standby.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

### AI overview

This documentation article introduces Skytools 3 WalMgr, a component for managing PostgreSQL WAL shipping and archiving. It explains preparing a master and standby, taking a base backup, restoring from archives, and using Streaming Replication with PostgreSQL 9.0 and 9.1.

### Source excerpt

Let's begin the Skytools 3 documentation effort, which is long overdue. The code is waiting for you over at github, and is stable and working. Why is it still in release candidate status, I hear you asking? Well because it's missing updated documentation. WalMgr is the Skytools component that manages WAL shipping for you, and archiving too. It knows how to prepare your master and standby setup, how to take a base backup and push it to the standby's system, how to archive (at the satndby) master's WAL files as they are produced and have the standby restore from this archive.

## PostgreSQL replication solutions discussed at CHAR(11)

DevFeed: [PostgreSQL replication solutions discussed at CHAR(11)](<https://devfeed.tech/articles/de-retour-de-char-11-34424.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/07/de-retour-de-char11/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-07-13T15:30:00Z

Content type: opinion

Language: fr

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [failover](<https://devfeed.tech/tags/failover.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [standby](<https://devfeed.tech/tags/standby.md>), [streaming](<https://devfeed.tech/tags/streaming.md>)

### AI overview

A report from CHAR(11) discusses the history and evolution of PostgreSQL replication solutions, comparing Skytools, Slony, and PostgreSQL's integrated Streaming Replication and Hot Standby. It also describes synchronous replication in PostgreSQL 9.1 and repmgr features for cluster administration, read-load distribution, and automatic failover.

### Source excerpt

Quelle meilleure occupation dans le train du retour de CHAR(11) que de se faire reporteur pour l'occasion ? En réalité, dormir serait une idée tant les soirées se sont prolongées ! Nous avons eu le plaisir d'écouter Jan Wieck présenter un historique simplifié de la réplication avec PostgreSQL. Étant lui-même l'un des pionniers du domaine, son point de vue est des plus intéressants. Il a parlé de l'évolution des solutions de réplication, et je ne peux m'empêcher de penser que par bien des côtés Skytools est une évolution de Slony -- Jan, auteur de Slony, semblait d'accord avec cela.

## Synchronous Replication

DevFeed: [Synchronous Replication](<https://devfeed.tech/articles/synchronous-replication-34392.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/09/synchronous-replication/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-09-06T16:05:00Z

Content type: opinion

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Replication](<https://devfeed.tech/topics/replication.md>), [Database](<https://devfeed.tech/topics/database.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [async](<https://devfeed.tech/tags/async.md>), [connectivity](<https://devfeed.tech/tags/connectivity.md>), [database](<https://devfeed.tech/tags/database.md>), [failover](<https://devfeed.tech/tags/failover.md>), [replication](<https://devfeed.tech/tags/replication.md>), [server](<https://devfeed.tech/tags/server.md>), [standby](<https://devfeed.tech/tags/standby.md>), [timeout](<https://devfeed.tech/tags/timeout.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [version](<https://devfeed.tech/tags/version.md>)

### AI overview

The article discusses a proposed synchronous replication facility for a database, including service levels based on whether data is received, flushed, or applied on a standby before COMMIT is acknowledged. It considers configuring failover servers and choosing safety requirements per transaction, including behavior when a standby loses connectivity.

### Source excerpt

Although the new asynchronous replication facility that ships with 9.0 ain't released to the wide public yet, our hackers hero are already working on the synchronous version of it. A part of the facility is rather easy to design, we want something comparable to DRBD flexibility, but specific to our database world. So synchronous would either mean recv, fsync or apply, depending on what you need the standby to have already done when the master acknowledges the COMMIT. Let's call that the service level.