By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Restoring dump files completely

P: 1
Hi all,

im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D

i have these dump files and i've been working on restoring everything in it.
i've tried this command :
psql -U postgres dbname < data.dump :
the tables were restored wihout any data inside it.

does anyone know how I could fix this? :D
thanks a lot for any help.

.: need help here. :.
Nov 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: 2
cam
I assume that when you are dumping your database it does include data in the tables?

When I dump my database I usually use this command try this it might work

pg_dump -U postgres -D dbname > filename.dmp

Once the data has been dumped to this file check if the inserted data actually exists in the filename.dmp file.

;) have fun!!!!!!

Hi all,

im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D

i have these dump files and i've been working on restoring everything in it.
i've tried this command :
psql -U postgres dbname < data.dump :
the tables were restored wihout any data inside it.

does anyone know how I could fix this? :D
thanks a lot for any help.

.: need help here. :.
Nov 23 '06 #2

P: 4
I assume that when you are dumping your database it does include data in the tables?

When I dump my database I usually use this command try this it might work

pg_dump -U postgres -D dbname > filename.dmp

Once the data has been dumped to this file check if the inserted data actually exists in the filename.dmp file.

;) have fun!!!!!!

Try this if you have pure sql dump file to restore

psql -U postgres dbname -f filename.dmp

It works,
Dec 15 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.