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