天天看点

PG10的函数比PG9.6变化不少

 ---如下是9.6的:

https://www.postgresql.org/docs/9.6/static/functions-admin.html

pg_current_xlog_flush_location()	pg_lsn	Get current transaction log flush location
pg_current_xlog_insert_location()	pg_lsn	Get current transaction log insert location
pg_current_xlog_location()	pg_lsn	Get current transaction log write location
           

---如下是10的: https://www.postgresql.org/docs/10/static/functions-admin.html

pg_current_wal_flush_lsn()	pg_lsn	Get current write-ahead log flush location
pg_current_wal_insert_lsn()	pg_lsn	Get current write-ahead log insert location
pg_current_wal_lsn()	pg_lsn	Get current write-ahead log write location 
           

可以看到,名字都不一样了...

继续阅读