Specify PGWAL directory

bagafoot commented 1 year ago

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

vadius45 commented 1 year ago

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

bagafoot commented 1 year ago

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

hapostgres / pg_auto_failover

Specify PGWAL directory #960