Posts

Showing posts from May, 2017

checking the control file information in the enterprisedb

How to check the control file information in the postgreql ? [enterprisedb@pgsqldb1 bin]$ ./pg_controldata -D /mnt/appln/edb/as9.6/data/ pg_control version number:            960 Catalog version number:               201608131 Database system identifier:           6415906308853348415 Database cluster state:               in archive recovery pg_control last modified:             Mon 08 May 2017 02:21:57 PM IST Latest checkpoint location:           2/9B3BB198 Prior checkpoint location:            2/9B3BB0B8 Latest checkpoint's REDO location:    2/9B3BB160 Latest checkpoint's REDO WAL file:    00000002000000020000009B Latest checkpoint's TimeLineID:       2 Latest checkpoint's PrevTimeLineID:   2 Latest checkpoint's full_page_wri...