jackc / jackc/pglogrepl

Please add support for new CREATE_REPLICATION_SLOT statement format

Open
#67 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
546
Forks
83
Avg merge
2d 21h
Merged PRs (30d)
1

Description

In PostgreSQL 15, a new format for the CREATE_REPLICATION_SLOT statement was introduced, supporting arbitrary options. In PostgreSQL 17, a great new option, FAILOVER, was added for synchronizing replication slots between servers.

Support for these changes seems to break backward compatibility, but that would be great. It would also be great if all variants of the CREATE_REPLICATION_SLOT statement from different PostgreSQL versions were supported.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the CREATE_REPLICATION_SLOT statement parsing and its tests. Compare the PostgreSQL 15 and 17 syntax, including arbitrary options and FAILOVER, then add coverage for the supported version variants and run the existing test suite to verify backward compatibility.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.