About #1: I don't think you're going to see it again: https://www.postgresql.org/docs/6.3/c0503.htm https://www.postgresql.org/docs/6.3/c0503.htm The closest i

About #1: I don't think you're going to see it again: https://www.postgresql.org/docs/6.3/c0503.htm https://www.postgresql.org/docs/6.3/c0503.htm The closest is this, but maybe not helpful in your scenario: https://news.ycombinator.com/item?id=26748096 https://news.ycombinator.com/item?id=26748096 I think a practical alternative is to CREATE DATABASE .. TEMPLATE foo. Maybe it could be boosted up by supporting reflink copies many filesystems nowadays support. In fact reflink in context of PostgreSQL has been discussed earlier, I wonder whatever happened to it: https://www.postgresql-archive.org/file-cloning-in-pg-upgrade-and-CREATE-DATABASE-td6006663.html#a6029349 https://www.postgresql-archive.org/file-cloning-in-pg-upgrad...