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: L809CD21835EB4a338541989E7A3F0D57.1288954812.scalix.khulisa.com@MHS (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group