Restaring a dumped database

From: "Mohlomi Moloi" <mmoloi(at)khulisa(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Restaring a dumped database
Date: 2010-11-08 07:52:32
Message-ID: L809CD21835EB4a338541989E7A3F0D57.1288954812.scalix.khulisa.com@MHS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2010-11-08 12:19:32 Re: Restaring a dumped database
Previous Message Jasen Betts 2010-11-07 12:10:39 Re: Function to spell out a number