[root@ ~]# systemctl stop postgresql-9.3.service
[root@ ~]# /usr/pgsql-9.3/bin/pg_controldata /var/lib/pgsql/9.3/data | grep Next | grep ID
Latest checkpoint's NextXID: 0/191689
Latest checkpoint's NextOID: 447596
[root@1 ~]# su -l postgres -c "/usr/pgsql-9.3/bin/pg_resetxlog -o 447596 -x 191689 /var/lib/pgsql/9.3/data"
Transaction log
(
Read more... )