Bring back deleted rows in PostgreSQL

Who has never faced this?
If this is your case, STOP READING NOW and run this command to prevent the vacuum from running:
Lets go
Download the library and follow the steps below.
Download the Visual Studio Community(or another version).
Install VS with basic features and libraries. But don't forget to select C/C ++ compilers.
I hope that the pg_dirtyread project owner has validated my pull request with the changes when reading this file. If not, make minor changes to the source:
And save everything.
Select "All configurations" and the platform on which you want to generate your DLL. In my case 64-bit.
Select "All configurations" and the platform on which you want to generate your DLL. In my case 64-bit.
You’ll also need to set the library path. Under “Linker”->”General”, in Additional Library Directories. In my case that’s C:\Program Files\PostgreSQL\9.3\lib. While you’re there, set Link Library Dependencies to No.
At this point you must fish the DLL out of the project and copy it into PostgreSQL’s lib directory. In my case that means copying C:\Users\suporte\source\repos\pg_dirtyread_win\x64\Release\pg_dirtyread.dll to C:\Program Files\PostgreSQL\9.3\lib
Save everything.
If everything went well, you can now run the command: "create extension pg_dirtyread"
In my case:

My table contained bytea fields. Then it would be more difficult to just insert the information. So, I decided to export to binary files and then import the records.

Yes. It worked!

References and support material - Thanks everbody who took the time to share their experiences and help those who need a hand

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Roberto

Roberto

Programmer for over 20 years. Venturing into the most diverse areas: IP PBX, Database (SGDB, noSQL), Delphi, Java, PHP, Python, NodeJS, VueJS..and counting