Sample Header Ad - 728x90

How to (pg_)restore selected tables with all indexes?

2 votes
1 answer
522 views
I would like to restore selected (currently after -t) tables including all indexes without making a definition after -I - because indexes are changing, new ones are created, old ones may expire. What is the best way to perform the restore process in Postresql db? I have read that is possible to restore whole db, and then delete unnecessary tabels. I'm afraid that the process will be much longer and will load the database too much. -t - recreates only data -I - I have to define index by myself, I want it to happen automatically
Asked by Bartłomiej Kanabus
Dec 5, 2022, 09:46 AM
Last activity: Apr 11, 2025, 05:02 PM