In postgresql 9.2.1, database avoid accepting commands to prevent wraparound dataloss issue.I was running vacuum freeze verbose process in single user mode in the respective database. Suddenly, the vacuuming process got stuck in the half way through (just frozen while vacuuming some transactions) with the warning message,
WARNING: database "XXXX" must be vacuumed within 997218 transactions. HINT: To avoid a database shutdown, execute a full-database VACUUM in "XXXX".
- What would be the reasons for that vacuuming process can stuck in half way ?
- How can i prevent it ?
Please help me.