patternsqlMinor
Write concern in PostgreSQL
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.