0
When I restore a backup in Postgree’s "pgadmin", if the database tables contain records, it gives error.
Is there any possibility of me creating a backup and at the time of restoration, I inform that I want to erase the data from the tables and restore?
Can be by SQL script even.
To perform the Store in postgres, the indicated is that the base is droped, created a new reset and restored the backup then on it. If not done this way, duplication of data may occur
– Fernando Souza
Thanks for your help, Fernando. The problem is that in my company, the consultants install in the clients the standard base containing the records necessary for the functioning of the system. When we migrate the data and ask them to do the installation, some tables already contain the data, then it would be necessary to delete the previous records and save the migration data.
– Master JR