I lost a lot of data in my postgresql database and do not have a dump file to restore backup from, but I heard that in /var/lib/postgresql/9.4/main there are pg_xlog and pg_clog and that those directories could be used to restore previous points in the db. Could someone clarify this and how to do it? The importance is major.
FYI everything is stopped. What happened is that there is only a very old dump from February since then a lot has changed in the database and in 3rd of July at 2PM executing a python script it changed a lot of the data in the database(data changed is the clients assigned to a specific shop). There is no data loss but it would be needed to revert those transactions. In the pg_xlog folder the transaction logs that have not been archived are from 2hours before that moment it all changed.
I desperately need to revert those changes. Is there any possible way to revert changes?
I have a system backup of that virtual machine that is moments few hours after and can try solutions many times.