Skip to content

Use the standby’s operating-system account for its base backup and startup #477

Open

Description

@Hanabi9248

Both v5.6 cluster guides run standby pg_basebackup with plain sudo. The English startup example also uses sudo pg_ctl. On Linux, the release pg_ctl rejects effective user ID 0, so the English command cannot start the standby under the usual sudo configuration. The backup can also create a data directory owned by root. The server requires that directory to belong to the account starting it, which affects the Chinese workflow too. English cluster guide Chinese cluster guide Root check Data directory ownership check

Run both commands as the same non-root operating-system account. Before the backup, that account needs to be able to create the target data directory or own an existing empty directory with write access. The -U ivorysql option continues to select the database role used for the replication connection. Backup target creation

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