Update pgroll.com docs versions on release
#737
Merged
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
There was a problem hiding this comment.
Pull Request Overview
This PR updates the release workflow to add a step that updates the pgroll.com/docs site with a new documentation version and updates the "latest" link.
- A step is added to set up the PostgreSQL client.
- A step is added to run psql commands that insert a new doc version and update the "latest" tag.
Comments suppressed due to low confidence (1)
.github/workflows/build.yml:322
- Consider adding the '-v ON_ERROR_STOP=1' flag here as well to ensure that the UPDATE command fails early on any SQL errors.
psql "$DATABASE_URL" -c "UPDATE doc_versions SET ref='${{ github.ref_name }}' WHERE version='latest'"
kvch
approved these changes
Mar 24, 2025
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Add a new step to the
releasejob to:pgroll.com/docssite.latestlink on thepgroll.com/docssite to point to the newly released version.The
PGROLL_COM_DATABASE_URLsecret uses a role with the minimum set of permissions to update thedoc_versionstable to perform these actions.