These are complete dumps of Repology database, created daily.

Notes:

- The dumps are generated with `pg_dump --clean --if-exists --no-owner` with
  extension related clauses commented out, and are intended to be applied to
  either empty database or existing Repology database (overwriting all data)
  from the database owner, given required extensions already set up by the
  superuser (see usage below).
- Dumps are compressed with zstandard compression algorithm.
- Note that dumps are only expected to be compatible with the same PostgreSQL
  versions they were generated with. May be compatible with later versions,
  definitely not compatible with earlier versions. PostgreSQL version used
  by Repology at time of dump is included into the dump file name.
- Expect more than 10 gigabytes of filesystem space to be used by PostgreSQL
  after the dump is applied.

Prerequisites:

- PostgreSQL
  https://www.postgresql.org/

- zstandard decompressor
  https://facebook.github.io/zstd/

- postgresql-libversion extension
  https://github.com/repology/postgresql-libversion

- postgresql-trgm extension
  https://www.postgresql.org/docs/14/pgtrgm.html
  (usually comes with postgresql-contrib package)

Usage:

- Create database, user and extensions as documented in 
  https://github.com/repology/repology-updater#creating-the-database

- Fetch, extract and apply the dump (note that existing Repology
  data will be erased):

    curl -s https://dumps.repology.org/repology-database-dump-latest.sql.zst | zstd -d | psql -U repology -v ON_ERROR_STOP=1