PostgreSQL Replication on a daily basis With PostgreSQL, I want to replicate a subset of all tables from Database A to B, but only once a day. Since I do not know what to search for: is there a technical term for such a scenario? Does e.g. Slony-I support this?
You can achieve this by stopping the replication, which is the slon daemon. By stopping the daemon, sync event get accumulated on sl_log tables on master. When slon get started again, this accumulated logs will get synced to slave.

Hope it helps.