0

Using Postgres 13 on Ubuntu 21.10. I'm trying to move my pg_wal contents to a new disk, as the current one is full. I've moved the contents to a new disk, then created a symbolic link in the main postgres data directory. It shows up when listing the directory contents. However, trying to start postgresql results in "FATAL: required WAL directory "pg_wal" does not exist". It looks like Postgres isn't accepting the symbolic link as a folder, although the documentation specifies that is should work. Solutions?

output of "ls -la" in data dir:

...
drwx------  2 postgres uuidd    4096 Nov 16  2021 pg_twophase
lrwxrwxrwx  1 postgres postgres   17 Jun 28 13:09 pg_wal -> /data/pg_wal_move
drwx------  2 postgres uuidd    4096 Nov 16  2021 pg_xact
...
m.nicolau
  • 47
  • 5

1 Answers1

0

That will work just fine, as long as you shutdown the database while you move the WAL and create the symbolic link.

Of course, you have to make sure that the moved pg_wal still belongs to postgres, and that user postgres has "execute" permissions on all containing directories (in this case /data). But a permission error should cause a different error message. Perhaps /data/pg_wal_move doesn't exist?

Laurenz Albe
  • 209,280
  • 17
  • 206
  • 263
  • 1
    Thank you, I only made sure postgres had execute rights on /data/pg_wal_move, but they were missing for /data! So the solution was granting execute rights on the parent /data directory. – m.nicolau Jun 28 '22 at 11:57