I am trying to restore a PostgreSQL database using the command below:
pg_restore --verbose --clean --no-acl --no-owner -h localhost -p 5432 -U postgres -w -d databaseName Backup.dump
The restoring is done successfully. But it displays below warning message in the end.
WARNING: errors ignored on restore: 97
Due to which my shell script is failing as the command returns exit 1 code.
Can anyone please guide on this?