PG PACK

(This is a volunteer project associated with the Database Systems course taught by Dr. Mehrdad Ahmadzadeh Raji at Shahid Beheshti University)

Pack your PostgreSQL databases quicker and more efficient with pg_pack. Compared to pg_dump, It performs up to 3x faster and uses brotli compression to provide up to 20x lighter data packages.

Precautions

• pg_pack does not support the following SQL interfaces:
  • Types (except for enums)
  • Aggregate Functions
  • Views
• Restoring files compressed by pg_pack to the database is only possible via pg_pack itself and not other tools like pg_restore or psql.

Comparison

Comparison charts TBD.

TODO

• Implement brotli compression
• Setup GitHub Actions to release binaries
• Fix compressed output filename template
• Pack SEQUENCES
• Pack FUNCTIONS
• Pack DOMAINS
• Pack TYPES
• Pack AGGREGATE FUNCTIONS
• Pack VIEWS
• Data-only mode
• Schema-only mode
• Implement restore compressed
• Comparison charts (vs pg_dump) for README

License

Distributed under the MIT License. See LICENSE for more information.

Contact

Soroush Taheri

• Email: soroushtgh@gmail.com