## PostgreSQL database anonymization and synthetic data generation tool ## Greenmask Overview
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. ### Is perfect for: * **Backup and Restoration**: Streamline daily tasks like logical backups, table restoration after truncation, or replacing pg_dump and pg_restore with ease. * **Anonymization and Data Masking**: Simplify staging environment setup and analytical tasks by anonymizing and transforming backups, ensuring consistent, secure data for faster Greenmasks has **[Database subset](https://docs.greenmask.io/latest/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**. ## Changes * Support `postgres://` schema connection URLs [#263](https://github.com/GreenmaskIO/greenmask/pull/263) * Implemented `--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](https://github.com/GreenmaskIO/greenmask/pull/266) * Implemented the `--no-blobs` flag for greenmask restore. If there are any large objects in your database, this will create an empty placeholder instead. [#265](https://github.com/GreenmaskIO/greenmask/pull/266) * Enabled support for all textual data types in all transformers that have a text type [#267](https://github.com/GreenmaskIO/greenmask/pull/267). Closes [#260](https://github.com/GreenmaskIO/greenmask/issues/260) * Fixed numerous introspection queries that have out of range errors caused by casting OID types to int4 values [#264](https://github.com/GreenmaskIO/greenmask/pull/266). Closes [#265](https://github.com/GreenmaskIO/greenmask/issues/265) * Refactored the logic of restorers and added test coverage to improve maintainability and stability [#268](https://github.com/GreenmaskIO/greenmask/pull/266) * Fixed domain constraint introspection query [#266](https://github.com/GreenmaskIO/greenmask/pull/266) * Revised documentation according to the latest changes [#267](https://github.com/GreenmaskIO/greenmask/pull/267) * Fixed brew build [homebrew-core #206868](https://github.com/Homebrew/homebrew-core/pull/206868) Closes [#261](https://github.com/GreenmaskIO/greenmask/issues/261) * Fixed a case when converted directory dump into single file using `pg_restore --file=1738263512345.sql` is corrupted due to lost semicolon [#255](https://github.com/GreenmaskIO/greenmask/issues/255) * Updated go dependencies [#256](https://github.com/GreenmaskIO/greenmask/issues/256) * Introduces `--disable-trigers`, `--use-session-replication-role-replica` and `--superuser` options for restore command. It allows to disable triggers during data section restore [#252](https://github.com/GreenmaskIO/greenmask/pull/252). Closes feature request [#228](https://github.com/GreenmaskIO/greenmask/issues/228) * Fix skipping unknown type when silent is true [#251](https://github.com/GreenmaskIO/greenmask/pull/251) ## Releases list: * [v0.2.6](https://github.com/GreenmaskIO/greenmask/releases/tag/v0.2.6) * [v0.2.7](https://github.com/GreenmaskIO/greenmask/releases/tag/v0.2.7) * [v0.2.8](https://github.com/GreenmaskIO/greenmask/releases/tag/v0.2.6) ## Links Feel free to reach out to us if you have any questions or need assistance: * [Greenmask repository](https://github.com/GreenmaskIO/greenmask) * [Documentation](https://docs.greenmask.io/latest/) * [Discord](https://discord.gg/tAJegUKSTB) * [Telegram](https://t.me/greenmask_community) * [Email](mailto:supp...@greenmask.io) * [Twitter](https://twitter.com/GreenmaskIO) * [DockerHub](https://hub.docker.com/r/greenmask/greenmask)
