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

Latest revision as of 14:59, 3 July 2023

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

could not find WAL segment
2023-06-19 06:32:37.504 UTC [1440100] HINT: Consider increasing the configuration parameter "max_wal_size".

@@ Line 1: / Line 1: @@
 [[wikipedia:Write-ahead logging]]
-* <code>pg_wal/</code>
+* <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>
-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 ==
-* [[PITR]]
+* [[Point-in-time recovery (PITR)]]
 * [[ACID]]
 * [[ARIES]]
-* [[PostgreSQL]]
 * [[Amazon RDS Read Replicas]]
 * [[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 ==
+* {{WAL}}
 * {{pg_dump}}
 * {{PostgreSQL replication}}
-* {{DBs}}
 [[Category:Databases]]