Hi Hackers -- I am searching for a way to make a contribution to Postgres and I came across this TODO item (I realize there has been some controversy around the TODO list [1], and I hope that my use of it doesn't spark another discussion about removing it altogether):
"Allow WAL replay of CREATE TABLESPACE to work when the directory structure on the recovery computer is different from the original" Currently it looks like tablespaces have to live inside the data directory on the replica, notwithstanding administrator intervention by manipulating the tablespace directory with symlinks after (or even before?) it has been created via replay. Is the idea behind this task to allow the master to instruct the replica where to put the tablespace on its filesystem, so as to allow it to live outside of the data directory without direct manipulation of the filesystem? If this task is a worthwhile endeavor, I would be happy to take it on. If not, I am open to other ideas :) Thanks, Patrick [1] https://www.postgresql.org/message-id/CA+TgmoZC3CyzZDY1fWChRNOY-5SBjUkB1w=c6y6jmqhtavu...@mail.gmail.com