Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| postgresql_enablewriteeaheadlog [2019/05/20 07:45] – created andonovj | postgresql_enablewriteeaheadlog [2019/11/13 16:51] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 9: | Line 9: | ||
| - Minimal | - Minimal | ||
| + | - Archive | ||
| - Replica | - Replica | ||
| - Logical | - Logical | ||
| Line 51: | Line 52: | ||
| May 20 03:44:44 localhost.localdomain systemd[1]: Started PostgreSQL 9.6 database server. | May 20 03:44:44 localhost.localdomain systemd[1]: Started PostgreSQL 9.6 database server. | ||
| </ | </ | ||
| + | |||
| + | ====Verify==== | ||
| + | Write Ahead Log (WAL) Enables us to make online base backup, so let's verify if the WAL works firstly: | ||
| + | |||
| + | <sxh bash> | ||
| + | [root@localhost archive]# ls -lart | ||
| + | total 81924 | ||
| + | drwx------. 5 postgres postgres | ||
| + | -rw-------. 1 postgres postgres 16777216 May 19 08:43 000000010000000000000001 | ||
| + | -rw-------. 1 postgres postgres 16777216 May 19 08:48 000000010000000000000002 | ||
| + | -rw-------. 1 postgres postgres 16777216 May 19 08:48 000000010000000000000003 | ||
| + | -rw-------. 1 postgres postgres 16777216 May 19 08:48 000000010000000000000004 | ||
| + | -rw-------. 1 postgres postgres | ||
| + | drwxr-xr-x. 2 postgres postgres | ||
| + | -rw-------. 1 postgres postgres 16777216 May 19 08:50 000000010000000000000005 | ||
| + | </ | ||
| + | |||
| + | |||
| + | Seems all is fine, now we can make a base backup, explained further in the wiki. | ||