Comment Comment by eugercek If you use xfs (+`file_copy_method=CLONE`) you can do this with Postgres 18.`CREATE DATABASE clankerdb TEMPLATE sourcedb STRATEGY=FILE_COPY;`.But Ardent can be useful for many, because cloud providers uses heavily restricted Postgres. And many use Aurora, which doesn't event let configure the `log_line_prefix`.Though if cloud providers add file_copy_method=CLONE compatible managed pg ...ref: https://boringsql.com/posts/instant-database-clones/ parent eugercek 5 months ago
`CREATE DATABASE clankerdb TEMPLATE sourcedb STRATEGY=FILE_COPY;`.
But Ardent can be useful for many, because cloud providers uses heavily restricted Postgres. And many use Aurora, which doesn't event let configure the `log_line_prefix`.
Though if cloud providers add file_copy_method=CLONE compatible managed pg ...
ref: https://boringsql.com/posts/instant-database-clones/