Greenmask is a powerful open-source utility that is designed for logical database backup dumping, anonymization, synthetic data generation and restoration. It is stateless and does not require any changes to your database schema. It is designed to be highly customizable and backward-compatible with existing PostgreSQL utilities, fast and reliable.
Greenmasks has Database subset feature - One of the most advanced subset systems on the market. It supports virtual references, nullable columns, polymorphic references, and can subset even the most complex schemas with cyclic references.
postgres:// schema connection URLs #263--blobs and --no-blobs flags for the greenmask dump command. These flags allow inclusion or exclusion of large objects in the dump file. By default, --blobs is enabled. If --no-blobs is specified, large object data will be skipped, and only large object creation commands and ACLs will be included in the dump. #265--no-blobs flag for greenmask restore. If there are any large objects in your database, this will create an empty placeholder instead. #265pg_restore --file=1738263512345.sql is corrupted due to lost semicolon #255--disable-trigers, --use-session-replication-role-replica and --superuser options for restore command. It allows to disable triggers during data section restore #252. Closes feature request #228Feel free to reach out to us if you have any questions or need assistance: