Since PipelineDB objects are represented by standard PostgreSQL objects, backups can be taken using PostgreSQL’s pg_dump and pg_dumpall tools. Other PostgreSQL backup and restore tooling will work as well, since a PipelineDB database is just a regular PostgreSQL database.

Exporting Specific Continuous Views

To export a single continuous view, both the continuous view and its associated materialization table must be explicitly dumped, like so:

pipeline-dump -t <CV name> -t <CV name>_mrel # <-- Note the "_mrel" suffix

Restoring Continuous Views

To restore a backup taken with pg_dump, simply pass its output to the psql client:

pg_dump > backup.sql
psql -f backup.sql