On 05/16/2017 10:44 PM, reem wrote:
postgres 9.3 in ubuntu OS.
Yes I did this :
1- service postgresql stop
2- /usr/lib/postgresql/9.3/bin/postgres --single -D
/var/lib/postgresql/9.3/main -c
config_file=/etc/postgresql/9.3/main/postgresql.conf dbname
3-vacuum verbose
4- vacumming processed and it shows tables being vacuumed but then suddenly
stopped with the same error above.
Please note we didn't try to VACUUM FULL because it takes a lot of the
resources .
Have you looked at the other part of the original error message:
"You might also need to commit or roll back old prepared transactions."
Might want to take a look at what is in pg_prepared_xacts:
https://www.postgresql.org/docs/9.3/static/view-pg-prepared-xacts.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
