pg_auto_failover icon indicating copy to clipboard operation
pg_auto_failover copied to clipboard
verified publisher icon hapostgres

Specify PGWAL directory

Open bagafoot opened this issue 3 years ago • 2 comments

Is it possible specify pgwal directory? I could not find any config about that.

bagafoot avatar Oct 31 '22 11:10 bagafoot

Hello,

At first glance, I thought it was also a requirement for me, but I don't feel it's fully needed. What I do :

  • I build the cluster as per my requirements. For example, pg_wal is actually a symlink to another filesystem
  • Then I stop the cluster
  • And I register it with with pg_autoctl create postgres --pgport 12345 --monitor 'postgres://....' with PGDATA correctly set After some testing, I observe that the pg_wal symlink is preserved as expected

It's a best practice to segregate the WAL from PGDATA and I think you can do it if you "bring" your own cluster and not allow pg_auto_failover to create it.

Happy to be contradicted if I miss anything

vadius45 avatar Dec 21 '22 11:12 vadius45

what if you perform a failover , I remember paf remove symlink and go on with default pg_wal dir?

bagafoot avatar Dec 22 '22 10:12 bagafoot