8/21/2023 0 Comments Fall out 3 data files![]() However, the existence of the log makes it possible to use a third strategy for backing up databases: we can combine a file-system-level backup with backup of the WAL files. This log exists primarily for crash-safety purposes: if the system crashes, the database can be restored to consistency by “ replaying” the log entries made since the last checkpoint. The log records every change made to the database's data files. CaveatsĪt all times, PostgreSQL maintains a write ahead log (WAL) in the pg_wal/ subdirectory of the cluster's data directory. ![]() Recovering Using a Continuous Archive Backup 25.3.5. Making a Base Backup Using the Low Level API 25.3.4.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |