Skip to content

The timezone defenition used on the machine may not exist on machine where the report is generated, which can cause errors #56

@jobinau

Description

@jobinau

These are very edge cases. But happened once or twice.
For example, the User environment has the Timezone specified as "GB" (which stands for Great Briton), which exists in that environment.
However, when the analysis report was prepared on another region of the world , PostgreSQL couldn't know what "GB" meant, and it resulted in errors.
Another problem is pg_gather allows users to specify custom timezone specifications so that all timestamps will be displayed in the timezone they specify

export PG_GATHER_TIMEZONE='XYZ`

But if the user specifies a timezone which doesn't exist, PostgreSQL will error, and the report generation will fail.

In order to avoid both these cases, the pg_gather analysis and report generation should validate the timezone specified. if it is not a valid timezone, handle the situation without causing any failure.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions