Is it possible to access an old version of a string in Postgres that has not been cleared of evacuation?

Question

If the row was changed in Postgres but the table was not dusted, I assume that the old version of the row is still in the table. Can I access this version of the string?

Answer 1

This is usually not possible, but since deleting a line is not much larger than a flag, you can write a tool that resurrects deleted lines. Beware that indexes are not updated and should be recreated afterwards.

I am sure that the people on the PostgreSQL IRC channel have the tools they ask for - this is the fastest way to get here.

Answer 2

from postgres no, but smoothing data files is possible yes. since it is open source it should not be too difficult to read them. By the way, you should first close your database to prevent a vacuum.