I have a web application build on Django using PostgreSQL database. In a few tables, I have auto-generated-IDs being used as primary keys. Due to some unexpected circumstances, I had to uninstall everything on the Linux server and again setup them on a different Linux server. I want to use all the data which I had stored earlier and taken dumps in csv files for each table before uninstalling.
So, I've used copy function and and copied all columns data (including "id") into the new database. Now, when using the Django app which is trying to insert data into the tables, its throwing PRIMARY KEY ERROR saying that id already exists. So, what can I do now so that this Django+PSQL app uses id from some 1000 or 5000 rather than from 1 since the previous ones are already used? How to know this setup not to use 1 to 1000 as its already used.
I don't think any screenshots are required for this. Kindly let me know if I have to make myself more clear.
Thanks much in advance.
