Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

separate the Postgres WAL by schema?

I can't seem to find anything related to what I am trying to do. Is it possible to separate the Postgres WAL files by schema?

like image 661
TheTemplateBlog Avatar asked May 12 '26 17:05

TheTemplateBlog


1 Answers

No, it is not possible. Not only can't it be separated by schema, it also can't be separated by database either, within the same cluster/instance.

To get separate WAL streams, you would have to run different database instances listening on different ports, with either dblink or foreign data wrappers. And then you would have problems with atomicity of commits.

like image 87
jjanes Avatar answered May 14 '26 09:05

jjanes



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!