diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-03-25 20:47:53 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-03-25 20:47:53 +0000 |
| commit | d0eff9da5d0c286fc387dc3e11fba0d3cc81561f (patch) | |
| tree | 6b6b66644f35e4d3fdf32272588c44e0fca101ec /scripts/guix-data-service-create-small-backup | |
| parent | 0c4e6a2fe49d13a65f836a2b8a5dade720aa7e6b (diff) | |
| download | data-service-d0eff9da5d0c286fc387dc3e11fba0d3cc81561f.tar data-service-d0eff9da5d0c286fc387dc3e11fba0d3cc81561f.tar.gz | |
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';
Diffstat (limited to 'scripts/guix-data-service-create-small-backup')
| -rwxr-xr-x | scripts/guix-data-service-create-small-backup | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/scripts/guix-data-service-create-small-backup b/scripts/guix-data-service-create-small-backup index 57ee5ef..562735f 100755 --- a/scripts/guix-data-service-create-small-backup +++ b/scripts/guix-data-service-create-small-backup @@ -289,6 +289,7 @@ TEMPORARY_FILE_NAME="${TMPDIR:-/tmp}/guix_data_service_small-$DATE.dump.tmp" pg_dump --username=guix_data_service \ --format=custom --compress=9 --serializable-deferrable \ + --no-comments \ --username=guix_data_service \ --file="$TEMPORARY_FILE_NAME" \ "$URI_FOR_DATABASE" |