This projects implements "Materialized Views"(SNAPSHOT) on Postgresql. It also implements a simple "Database Link" (DBLINK). It supports: CREATE DBLINK DROP DBLINK CREATE SNAPSHOT DROP SNAPSHOT REFRESH SNAPSHOT
The DBLink and Materialized Viewsproject is a PostgreSQL Community project that is a part of the pgFoundry.
The pgFoundry page for the project is at http://pgfoundry.org/projects/snapshot, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.