Restaring a dumped database - Mailing list pgsql-novice

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