Skip to content

Correct the pg_cron metadata database default in v5.6 #467

Open

Description

@Hanabi9248

The English and Chinese pg_cron setup guides describe the default of cron.database_name as the current database, then ask readers to connect to “the database” for CREATE EXTENSION pg_cron. The extension defaults to postgres. For a normal installation, CREATE EXTENSION must run while connected to the database named in cron.database_name. A reader who omits the setting and connects to ivorysql will encounter the install script’s database check. English guide Chinese guide

The pg_cron v1.6.7 source registers cron.database_name with default postgres. Its installation SQL compares the active database with that setting before creating the metadata objects. The default branch of the upstream repository cloned by the guide has the same behavior. v1.6.7 default v1.6.7 install SQL

Update the configuration comment in both languages to name the postgres default, and clarify that readers should connect to the database selected by cron.database_name before running the examples. The worked configuration selects ivorysql.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions