----- "Fujii Masao" <masao.fu...@gmail.com> escreveu: > IMO, it's not so dangerous that postgres creates the directories, > which doesn't overwrite or remove any existing data. So, I thought > that it's worth writing the patch to create a tablespace directory > in recovery. Is this the right direction? Or, we should completely > forbid the auto-creation of directories outside $PGDATA?
I don't think it's a good idea to create directories automatically at all. Considering that the greatest benefit of using tablespaces is to move tables and indexes that have high concurrency to different disk partitions or controllers, creating directories (and mounting devices) for tablespaces should be a manual process. Flavio
