Skip to content

pg_repack causes backup restore to fail #1100

@matthew-white

Description

@matthew-white

The pg_repack extension can be helpful. Yet adding it to the Central database can cause backup restore to fail. We've discussed a couple different ideas about how to resolve this:

  1. Run pg_restore with --no-acl and/or --no-owner
    a. We've confirmed that --no-acl by itself allows the restore to go through.
    b. Maybe we always include this in the pg_restore command that we run, or maybe we add it as an option to Central's backup restore CLI.
  2. Only back up the public schema and/or only restore the public schema

Metadata

Metadata

Assignees

Labels

backendRequires a change to the API server

Type

No type

Projects

Status

✅ done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions