statement_only BOOLEAN NOT NULL);
Now this table contains 50 GB of data , But when taking its backup using
pg_dump and after restoring , it show that it has zero row.
How to see the restored data?
--
With Regards!
Shailesh Singh
33011
DETAIL: could not open file "pg_clog/": No such file or directory
exit
After this i am able to stop /start my db server but i am not able to
connect to my databases (it tells to run vacuum full first on patnadbold
databases)
1)I am using postgres 8.4 version.
2) I had t
To avoid a database shutdown, execute a full-database VACUUM in
"debug".
WARNING: database "debug" must be vacuumed within 84 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"debug".
WARNING: database "debug" must be vacuumed within 83 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"debug".
ERROR: could not access status of transaction 449971277
DETAIL: could not open file "pg_clog/01AD": No such file or directory
Now what?
Thanks in advance.
Shailesh Singh