search

jackc / pglogrepl

PostgreSQL logical replication library for Go.
MIT License
339 stars 63 forks source link

can i get snapshot with this package ? #49

Open seyedmo30 opened 1 year ago

seyedmo30 commented 1 year ago

I read many articles but I don't understand how to get data with snapshot_name

CREATE_REPLICATION_SLOT my_slot LOGICAL pgoutput(SNAPSHOT 'export') ;

Should I use consistent_point ( 0/29172F0 ) or snapshot_name ( 0000000A-00000161-1 )?

Is the path I took correct?

genezhang commented 1 year ago

Just FYI some details: https://stackoverflow.com/questions/75852587/how-to-use-exported-snapshot-in-postgres-replication-slot

le-vlad commented 1 month ago

@genezhang The interesting thing here is that this link you shared works for PG14+ Since the command that created the replication slot with snapshot exporting is not available in earlier versions.

Do you have an idea what to do with older versions?