Re: Restaring a dumped database

Thanks for the help Frank!! However I'm now faced with a question - Why my database after the restore worked, all of a sudden grew bigger.

Thanks,

Mohlomi  Moloi

----- Original Message -----
From: "Frank Bax" 
Sent: Mon, 11/8/2010 2:19pm
To: "PostgreSQL List - Novice" 
Subject: Re: [NOVICE] Restaring a dumped database

Mohlomi Moloi wrote:
> 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.



If you are trying to restore over an existing database; then you should 
either:
1) use -c option on pg_dump.
2) manually drop all tables, indexes and database.

-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice