May 2018
Intermediate to advanced
576 pages
30h 25m
English
You may seek advice about placing the pg_wal directory on a separate device for performance reasons. This sounds very similar to tablespaces, though there is no explicit command to do this once you have a running database, and files in pg_wal are frequently written. So you must perform the steps outlined in the following example:
[postgres@myhost ~]$ pg_ctl stop
[postgres@myhost ~]$ mv $PGDATA/pg_wal /mnt/newdisk/
[postgres@myhost ~]$ ln -s /mnt/newdisk/pg_wal $PGDATA/pg_wal
[postgres@myhost ~]$ pg_ctl start