I want to understand how to take a consistent snapshot in PostgreSQL and perform CDC once the full load based on the snapshot is completed. Based on the documentation was going through replication interface protocol but the replication connection should be open until the full load is completed else snapshot is not valid and have to create a new snapshot.
Regards,
Aditya D