I took a cold backup - shutdown the database and copy all the data dir.
בתאריך יום ג׳, 28 באוג׳ 2018 ב-22:34 מאת Asim R P <apraveen@pivotal.io>:
On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote: > Afterwards I vacuumed all the databases but nothing helped. I tried to > reindex the databases but I got the next error : > > 2018-08-28 21:50:03 +08 db2 24360 ERROR: could not access status of > transaction 32212695 > 2018-08-28 21:50:03 +08 db2 24360 DETAIL: Could not open file > "pg_subtrans/01EB": No such file or directory. >
Are you sure you created a checkpoint before copying the data directory over to your PC?
