Postgres Pro
Downloads
Home   >   mailing lists

Restaring a dumped database - Mailing list pgsql-novice

From Mohlomi Moloi
Subject Restaring a dumped database
Date
Msg-id L809CD21835EB4a338541989E7A3F0D57.1288954812.scalix.khulisa.com@MHS
Whole thread Raw
Responses Re: Restaring a dumped database
List pgsql-novice
Tree view

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

 

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Function to spell out a number
Next
From: Frank Bax
Date:
Subject: Re: Restaring a dumped database