From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Restaring a dumped database |
Date: | 2010-11-10 12:41:48 |
Message-ID: | 4CDA930C.70407@sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
How did you measure "bigger"?
Mohlomi Moloi wrote:
> 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" <fbax(at)sympatico(dot)ca>
> Sent: Mon, 11/8/2010 2:19pm
> To: "PostgreSQL List - Novice" <pgsql-novice(at)postgresql(dot)org>
> 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mohlomi Moloi | 2010-11-10 13:34:28 | Re: Restaring a dumped database |
Previous Message | Mohlomi Moloi | 2010-11-10 08:51:48 | Re: Restaring a dumped database |