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

From wikieduonline
Jump to navigation Jump to search
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
[[wikipedia:Write-ahead logging]]
 
[[wikipedia:Write-ahead logging]]
  
* <code>pg_wal/</code>
+
* <code>[[/var/lib/postgresql/]]##/main[[/pg_wal/]]</code>
 
 
 
* <code>[[wal_level]]</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>
  
Prometheus logs:
+
== Errors ==
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>[[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 ==
* [[PITR]]
+
* [[Point-in-time recovery (PITR)]]
 
* [[ACID]]
 
* [[ACID]]
 
* [[ARIES]]
 
* [[ARIES]]
* [[PostgreSQL]]
 
 
* [[Amazon RDS Read Replicas]]
 
* [[Amazon RDS Read Replicas]]
 
* [[Data warehouse]]: [[Change Data Capture (CDC)]]
 
* [[Data warehouse]]: [[Change Data Capture (CDC)]]
* <code>[[/var/lib/postgresql/]]13/main/pg_wal/</code>
+
* <code>[[timescaledb-tune --help|timescaledb-tune -wal-disk-size]]</code>
  
 
== See also ==
 
== See also ==
 +
* {{WAL}}
 
* {{pg_dump}}
 
* {{pg_dump}}
 
* {{PostgreSQL replication}}
 
* {{PostgreSQL replication}}
* {{DBs}}
 
  
 
[[Category:Databases]]
 
[[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: