Hi Everyone,
I’ve used the following script for my dump; pg_dump -h 127.0.0.1 -p 5432 -U mohlomi -F p teleform > "teleform_Backup.dump" – and it worked fine.
After my dump, I dropped the database teleform - My nightmare starts when I try to restore and I get error massages that the database dropped already exist etc...
I used the script psql -h 127.0.0.1 -p 5432 -U mohlomi -d teleform < "teleform_Backup.dump" for restoring the database.
Funny enough the above scripts works at a table level!!!
Any assistance will be welcomed.
Thanks,
Mohlomi Moloi