Skip to content

docs(admin): note PostgreSQL roles needed before restore - #15720

Open
whoalin1 wants to merge 1 commit into
nextcloud:masterfrom
whoalin1:docs/postgres-restore-roles
Open

whoalin1 wants to merge 1 commit into
nextcloud:masterfrom
whoalin1:docs/postgres-restore-roles

Conversation

@whoalin1

@whoalin1 whoalin1 commented Oct 7, 2026 •

Copy link
Copy Markdown

Summary

Document that PostgreSQL restores of a Nextcloud pg_dump often need the
source table-owner role(s) (typically oc_<username>) to exist on the target
before applying the dump. Adds a tip under database recreate and a note with
CREATE ROLE / pg_dumpall --roles-only examples under the restore command.

Closes #8001

Test plan


AI disclosure

This PR was drafted with the help of AI coding assistants (Cursor agents / LLM-based tools), including the description. I am responsible for it and happy to rework anything that doesn't fit.

All commits carry an Assisted-by: Cursor:grok-4.7 trailer.

Closes nextcloud#8001

Assisted-by: Cursor:grok-4.7
Signed-off-by: whoalin1 <[email protected]>
@whoalin1
whoalin1 force-pushed the docs/postgres-restore-roles branch from 42d4315 to e50af5c Compare October 9, 2026 14:11

This branch has not been deployed

No deployments
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Documentation - Postgres Backup/Restore Steps are incomplete

1 participant