Thank you so much because of your reply i did it a gain but for some tables,
and it works now .!
--
View this message in context:
http://www.postgresql-archive.org/database-is-not-accepting-commands-tp5961831p5962745.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com
It works finally.!
I did vacuum FULL for some tables and Then it just works .!
Maybe as you said this is related to the second part which is commit old
prepared transaction .!
--
View this message in context:
http://www.postgresql-archive.org/database-is-not-accepting-commands-tp5961831p596
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
The version is 9.3 in ubuntu.
yes i did it in standalone mode by using this command :
//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/
--
View this message in context:
http://www.postgresql-archive.o
We have 1.5 TB database that's shown an error and block all commands.
The error is :
"ERROR: database is not accepting commands to avoid wraparound data loss in
database "dbname"
HINT: Stop the postmaster and use a standalone backend to vacuum that
database.
You might also need to commit or roll
