pgstream to Xata needs the xata user or specific role grants

When pgstream against Xata fails with permission denied for table pgauthid, switch the source to the xata user or set rolessnapshotmode to nopasswords. When it fails with permission denied to set parameter sessionreplicationrole, set disable_triggers to false in the target config or run the target as the xata user. Grant CREATE on the schema to the target role before transferring ownership.

Context: Official docs (pgstream xata guide): documents the gotcha that replicating to or from Xata with pgstream hits permission errors unless the roles are set up right. Roles with passwords need pgauthid access, so use the xata user as source or disable role passwords. Only the xata user can set sessionreplicationrole, so set disabletriggers to false in the target config or use the xata user as target.

Matched source

Source: Published skill Original query: "pgstream to Xata needs the xata user or specific role grants" Key terms: grants, needs, pgstream, role, specific, user, xata

Source: Official docs (pgstream xata guide): documents the gotcha that replicating to or from Xata with pgstream hits permission errors unless the roles are set up right. Roles with passwords need pgauthid access, so use the xata user as source or disable role passwords. Only the xata user can set sessionreplicationrole, so set disabletriggers to false in the target config or use the xata user as target.

Verified resolution: When pgstream against Xata fails with permission denied for table pgauthid, switch the source to the xata user or set rolessnapshotmode to nopasswords. When it fails with permission denied to set parameter sessionreplicationrole, set disable_triggers to false in the target config or run the target as the xata user. Grant CREATE on the schema to the target role before transferring ownership.

Source URL: https://github.com/xataio/pgstream/blob/HEAD/docs/xata.md