Difference between revisions of "Write-ahead logging (WAL)"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(26 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
[[wikipedia:Write-ahead logging]]
 
[[wikipedia:Write-ahead logging]]
  
 +
* <code>[[/var/lib/postgresql/]]##/main[[/pg_wal/]]</code>
 +
* <code>[[wal_level]]</code>
 +
 +
[[Prometheus logs]]:
 +
* <code>ts=2023-02-17T01:00:03.414Z caller=head.go:1011 level=info component=[[tsdb]] msg="[[WAL checkpoint complete]]" first=1633 last=1634 duration=628.31117ms</code>
 +
 +
== Errors ==
 +
* <code>[[could not find WAL segment]]</code>
 +
* <code>2023-06-19 06:32:37.504 UTC [1440100] HINT:  Consider increasing the configuration parameter "[[max_wal_size]]".</code>
  
 
== Related terms ==
 
== Related terms ==
 +
* [[Point-in-time recovery (PITR)]]
 
* [[ACID]]
 
* [[ACID]]
 
* [[ARIES]]
 
* [[ARIES]]
 +
* [[Amazon RDS Read Replicas]]
 +
* [[Data warehouse]]: [[Change Data Capture (CDC)]]
 +
* <code>[[timescaledb-tune --help|timescaledb-tune -wal-disk-size]]</code>
  
 
== See also ==
 
== See also ==
* {{PostgreSQL}}
+
* {{WAL}}
 +
* {{pg_dump}}
 +
* {{PostgreSQL replication}}
 +
 
 +
[[Category:Databases]]

Latest revision as of 14:59, 3 July 2023

wikipedia:Write-ahead logging

Prometheus logs:

  • ts=2023-02-17T01:00:03.414Z caller=head.go:1011 level=info component=tsdb msg="WAL checkpoint complete" first=1633 last=1634 duration=628.31117ms

Errors[edit]

Related terms[edit]

See also[edit]

Advertising: