Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole thread)
Lists: pgsql-novice
Hi Everyone,


I’ve used the following script for my dump; pg_dump -h -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 -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.



Mohlomi Moloi 



pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group