HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Write concern in PostgreSQL

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlconcernwrite

Problem

In MongoDB it is called write concern, that is the number of the servers in a replica set, that the data should be committed before the cluster acknowledges the write request. How is it called in the Postgres?

Solution

PostgreSQL works differently. As soon as the data are committed on the single primary database, the write is effective. If you use synchronous replication, that commit waits until the required standby servers (configured by synchronous_standby_names) have received the information.

Context

StackExchange Database Administrators Q#267400, answer score: 4

Revisions (0)

No revisions yet.