Skip to content

Support for lsn capture to allow for custom replication setup #592

@tripti-singh

Description

@tripti-singh

I have a case where I am cloning the DB but need to retrieve the LSN on the cloned cluster to correctly setup the point of replication start.

It would be useful to be able to either run a generic query like https://registry.terraform.io/providers/ricochet1k/postgresql/latest/docs/data-sources/postgresql_query or have a custom LSN capture data source to get the latest LSN on a cloned cluster (either aurora_volume_logical_start_lsn or pg_current_wal_lsn or both)

Additionally, we could use the output to set pg_replication_origin_advance to the captured LSN.

Hopefully this is useful to others as well.

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