| ▲ | tee-es-gee 6 days ago | |
> You don’t need anything but vanilla pg and a supported file system to do it anymore; just clone the database using a template and a newish version of Postgres. Are you referring to `file_copy_method = clone` from Postgres 18? For example: https://boringsql.com/posts/instant-database-clones/ I think the key limitation is: > The source database can't have any active connections during cloning. This is a PostgreSQL limitation, not a filesystem one. | ||
| ▲ | sastraxi 6 days ago | parent [-] | |
Yeah, that's the one. My use case is largely for local development, so the active connections thing isn't a limiter for me. | ||