Skip to content
This repository was archived by the owner on May 12, 2026. It is now read-only.
This repository was archived by the owner on May 12, 2026. It is now read-only.

Dependency on 'postgres' User for Table Insertion and Permissions #43

Description

@pahbloo

Currently, the code relies heavily on the ‘postgres’ user for table creation and permission handling. In my tests, installing Giswater on databases without a ‘postgres’ user leads to errors.

I would like to suggest that if using the ‘postgres’ user is truly necessary, checks are added to ensure it exists. Where possible, consider replacing ‘postgres’ with a system user (e.g., role_system) or using the ‘current_user’ instead.

This would improve compatibility, especially for managed or hardened PostgreSQL installations where the default superuser may not be named ‘postgres’. My suggestion is set role_system as owner of every object in a Giswater schema. What do you think? May I work in this?

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Fields

    No fields configured for Bug.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions