Skip to content

docs: distinguish SQL script and archive restores - #408

Open
Loyal-Young wants to merge 1 commit into
IvorySQL:masterfrom
Loyal-Young:contest/docs-logical-dump-restore
Open

Loyal-Young wants to merge 1 commit into
IvorySQL:masterfrom
Loyal-Young:contest/docs-logical-dump-restore

Conversation

@Loyal-Young

Copy link
Copy Markdown

Explain which tool reads the default pg_dumpall SQL script and which tool reads a database archive. Save the script before replaying it when running source and target clusters side by side.

Verification

Rendered both locale pages with Asciidoctor. Replayed a pg_dumpall script with psql and restored a custom pg_dump archive with pg_restore across two local clusters. Confirmed the expected role and table row in the target. The baseline dumper emitted existing package ACL warnings during export.

Explain which tool reads the default pg_dumpall SQL script and which tool reads a database archive. Save the script before replaying it when running source and target clusters side by side.

Assisted-by: Codex:GPT-6
Percentage of AI-generated code: 100%

Signed-off-by: 王泽浩 <266632325+Loyal-Young@users.noreply.github.com>
@github-actions
github-actions Bot temporarily deployed to pull request November 13, 2026 01:44 Inactive
@github-actions

Copy link
Copy Markdown

🚀 IvorySQL-Docs Preview Ready

@Loyal-Young

Copy link
Copy Markdown
Author

The documented paths were exercised on two local clusters, with psql replaying the SQL dump and pg_restore restoring the custom archive. Could a maintainer review and merge the guide update if it looks good?

@Loyal-Young

Copy link
Copy Markdown
Author

Following up on the dump/restore guide update. The examples were exercised with psql for the SQL script and pg_restore for the custom archive, and the preview checks are passing. Could a maintainer review and merge the update if it looks good?

This branch was previously deployed

1 inactive deployment
pull request — 76151cb1 Deployed Nov 13, 2026 by github-actions[bot]
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.

1 participant