Commit022aea3

committed

pg_upgrade: preserve the timestamp epoch

This is useful for replication tools like Slony and Skytools. This is abackpatch ofa74a4aa.Report by Sergey KonoplevBackpatch through 9.3

1 parentb8b4124 commit022aea3Copy full SHA for 022aea3

File tree

+17

-8

lines changed

+17

-8

lines changed

Lines changed: 10 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -233,16 +233,20 @@ get_control_data(ClusterInfo *cluster, bool live_check)`
`233`	`233`	`}`
`234`	`234`	`elseif ((p=strstr(bufin,"Latest checkpoint's NextXID:"))!=NULL)`
`235`	`235`	`{`
`236`		`-char*op=strchr(p,'/');`
	`236`	`+p=strchr(p,':');`
	`237`	`+`
	`238`	`+if (p==NULL\|\|strlen(p) <=1)`
	`239`	`+pg_fatal("%d: controldata retrieval problem\n",__LINE__);`
`237`	`240`
`238`		`-if (op==NULL)`
`239`		`-op=strchr(p,':');`
	`241`	`+p++;/* removing ':' char */`
	`242`	`+cluster->controldata.chkpnt_nxtepoch=str2uint(p);`
`240`	`243`
`241`		`-if (op==NULL\|\|strlen(op) <=1)`
	`244`	`+p=strchr(p,'/');`
	`245`	`+if (p==NULL\|\|strlen(p) <=1)`
`242`	`246`	`pg_fatal("%d: controldata retrieval problem\n",__LINE__);`
`243`	`247`
`244`		`-op++;/* removing ':' char */`
`245`		`-cluster->controldata.chkpnt_nxtxid=str2uint(op);`
	`248`	`+p++;/* removing '/' char */`
	`249`	`+cluster->controldata.chkpnt_nxtxid=str2uint(p);`
`246`	`250`	`got_xid= true;`
`247`	`251`	`}`
`248`	`252`	`elseif ((p=strstr(bufin,"Latest checkpoint's NextOID:"))!=NULL)`

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -422,12 +422,16 @@ copy_clog_xlog_xid(void)`
`422`	`422`	`/* copy old commit logs to new data dir */`
`423`	`423`	`copy_subdir_files("pg_clog");`
`424`	`424`
`425`		`-/* set the next transaction id of the new cluster */`
`426`		`-prep_status("Setting next transaction ID for new cluster");`
	`425`	`+/* set the next transaction idand epochof the new cluster */`
	`426`	`+prep_status("Setting next transaction IDand epochfor new cluster");`
`427`	`427`	`exec_prog(UTILITY_LOG_FILE,NULL, true,`
`428`	`428`	`"\"%s/pg_resetxlog\" -f -x %u \"%s\"",`
`429`	`429`	`new_cluster.bindir,old_cluster.controldata.chkpnt_nxtxid,`
`430`	`430`	`new_cluster.pgdata);`
	`431`	`+exec_prog(UTILITY_LOG_FILE,NULL, true,`
	`432`	`+"\"%s/pg_resetxlog\" -f -e %u \"%s\"",`
	`433`	`+new_cluster.bindir,old_cluster.controldata.chkpnt_nxtepoch,`
	`434`	`+new_cluster.pgdata);`
`431`	`435`	`check_ok();`
`432`	`436`
`433`	`437`	`/*`

Lines changed: 1 addition & 0 deletions

Comments

(0)