Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

Postgres Permissions

Open
  • Is something wrong?
#506 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
38/100
Issue type
Documentation
Clarity
Needs clarification
Activity status
Quiet
Tech stack
postgres
Domain
documentation

Research direction

The issue provides a PostgreSQL error log and an ALTER ROLE example, but names no documentation file or section. Start by locating the relevant database setup or troubleshooting page in this repository and verify the required role permission. Done means the docs clearly explain the CREATEROLE prerequisite and remediation, with the example checked for accuracy.

Written by the indexing model from the issue text.

Description

{"time":"2026-04-30T06:48:14.720500798Z","level":"INFO","msg":"Initialized DB: mission-control-cloud-sql-proxy.mission-control.svc.cluste
 r.local (9854 kB)"}
 {"time":"2026-04-30T06:48:14.902582552Z","level":"ERROR","msg":"error setting up db connection: failed to run scripts: failed to run scri
 pt postgrest.sql: ERROR: permission denied to create role (SQLSTATE 42501): detail: Only roles with the CREATEROLE attribute may create r
 oles."}

ALTER ROLE your_username CREATEROLE;
Dominant language
CSS
Stars
1
Forks
2
Avg merge
2d 14h
Merged PRs (30d)
2

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from flanksource/docs

All issues in flanksource/docs

Similar issues

More Documentation issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.