Postgresql如何清理pg_xlog

sudo /etc/init.d/postgresql stopdu -sh /var/lib/postgresql/8.4/main/pg_xlog/985M     /var/lib/postgresql/8.4/main/pg_xlog//usr/lib/postgresql/8.4/bin/pg_controldata /var/lib/postgresql/8.4/main/...Latest checkpoint's NextXID:          1/2718420992Latest checkpoint's NextOID:          496696...sudo -u postgres /usr/lib/postgresql/8.4/bin/pg_resetxlog -o 496696-x 2718420992-f /var/lib/postgresql/8.4/main/Transaction log resetdu -sh /var/lib/postgresql/8.4/main/pg_xlog/17M     /var/lib/postgresql/8.4/main/pg_xlog/sudo /etc/init.d/postgresql start

[via]