Specifically truncate cascade the parent table "stock_in" which had foreign key to my "inventory" child of it. so I lost all data regarding my inventory.
I accidentally executed these are the following commands: "TRUNCATE TABLE public.stock_in RESTART IDENTITY CASCADE;" "ALTER SEQUENCE stock_in_id_seq RESTART WITH 1;"
I do not have a personal backup. PLEASE HELP ME I am new to this coding, but those were important for me.
At approximately 12:21 PM UTC +08:00 today (March 18, 2026),
We do not keep backups of postgres databases.
I read forum here where you were able to restore one person’s database. I am a paid user, please help me restore it.
We can only do it for MySQL.
I understand that automated restores are for MySQL, but as a paid subscriber, I am requesting a manual forensic intervention.
Because this was a TRUNCATE and not a DROP, the heap files for the inventory and stock_in tables likely still contain the 'dead tuples.' If a full PITR is not possible, could an admin please run a simple strings command or pg_filedump on the raw data files in my Postgres directory (/var/lib/postgresql/)?
If a full PITR is not possible, please provide me with a raw 'strings' dump of the heap files for the following tables:
public.inventory and public.stock_in
Even a raw text file of the strings inside those data blocks would allow me to manually rebuild my inventory. As a paid subscriber, I am asking for this one-time administrative intervention to prevent a total loss.
Please treat this as urgent.
That is not something that we provide
