From d0eff9da5d0c286fc387dc3e11fba0d3cc81561f Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Wed, 25 Mar 2020 20:47:53 +0000 Subject: Use the --no-comments option to pg_dump Hopefully this will help with the pg_restore in the create-small-backup script: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 2875; 0 0 COMMENT EXTENSION plpgsql pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; --- scripts/guix-data-service-backup-database | 1 + 1 file changed, 1 insertion(+) (limited to 'scripts/guix-data-service-backup-database') diff --git a/scripts/guix-data-service-backup-database b/scripts/guix-data-service-backup-database index 3988a49..77fda89 100755 --- a/scripts/guix-data-service-backup-database +++ b/scripts/guix-data-service-backup-database @@ -16,6 +16,7 @@ renice 19 -p $$ || true ionice -p $$ -c 3 || true pg_dump --format=custom --compress=9 --serializable-deferrable \ + --no-comments \ --username=guix_data_service \ --file="$TEMPORARY_FILE_NAME" \ "$DATABASE_NAME" -- cgit v1.2.3