diff --git a/sql/anon-dump/anon-dump.sh b/sql/anon-dump/anon-dump.sh new file mode 100644 index 0000000..d21beb2 --- /dev/null +++ b/sql/anon-dump/anon-dump.sh @@ -0,0 +1,2 @@ +#!/bin/bash +psql -a service=swh-replica < anon-dump.sql > anon-dump.log diff --git a/sql/anon-dump/anon-dump.sql b/sql/anon-dump/anon-dump.sql index f5bfb31..152cf31 100644 --- a/sql/anon-dump/anon-dump.sql +++ b/sql/anon-dump/anon-dump.sql @@ -1,16 +1,16 @@ \timing on -set bytea_output='escape'; +set bytea_output='hex'; \copy content (sha1, sha1_git, sha256, blake2s256, length, ctime, status) to program 'pigz -c > content.csv.gz' (format csv); \copy skipped_content (sha1, sha1_git, sha256, blake2s256, length, ctime, status, reason) to program 'pigz -c > skipped_content.csv.gz' (format csv); \copy directory (id, dir_entries, file_entries, rev_entries) to program 'pigz -c > directory.csv.gz' (format csv); \copy directory_entry_dir (id, target, name, perms) to program 'pigz -c > directory_entry_dir.csv.gz' (format csv); \copy directory_entry_file (id, target, name, perms) to program 'pigz -c > directory_entry_file.csv.gz' (format csv); \copy directory_entry_rev (id, target, name, perms) to program 'pigz -c > directory_entry_rev.csv.gz' (format csv); \copy revision (id, date, date_offset, committer_date, committer_date_offset, type, directory, message, author, committer, synthetic, metadata, date_neg_utc_offset, committer_date_neg_utc_offset) to program 'pigz -c > revision.csv.gz' (format csv); \copy revision_history (id, parent_id, parent_rank) to program 'pigz -c > revision_history.csv.gz' (format csv); \copy release (id, target, date, date_offset, name, comment, author, synthetic, target_type, date_neg_utc_offset); to program 'pigz -c > release.csv.gz' (format csv); \copy person (id, name, email) to program './anonymize-email | pigz -c > person.csv.gz' (format csv);