[makkesk8]

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.

[1] https://github.com/sqlcollaborative/dbaclone

[zimpenfish]

> redirects reads to the source db and writes to your clone.

Looks like you can do almost that kind of thing with pgpool[1] (although it does look like you'd need a weird replication setup first which might be a deal-breaker.)

[1] https://blog.pythian.com/comparing-pgpool-ii-and-pgbouncer/

"Because Pgpool can detect the master and slaves, it can automatically route traffic writes to the master and read traffic to both servers."