Re: Restaring a dumped database

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-08 12:19:32
Message-ID: 4CD7EAD4.5060306@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rob Richardson 2010-11-08 16:35:21 In PgAdmin, how can I see all of a long text field?
Previous Message Mohlomi Moloi 2010-11-08 07:52:32 Restaring a dumped database