I would love to see something like dbaclone [1] but for postgres which in principle creates a new database and redirects reads to the source db and writes to your clone.
This works very well in unit testing for us but there are situations where we use postgres and not sql server.