Mr. Green Posted May 27, 2009 Share Posted May 27, 2009 I have been searching for threads the entire day and cannot seem to find the answers I'm looking for. Please help. I have an approx. 30 MB database called losa that I have exported using the inbuild feature in phppgadmin. The dump is called dump.sql. I have created a test environment on my windows where I want to import the dump to my postgres 8.3 (localhost). I don't want to link directly to the live database. The test environment db is also called losa and it is created with the same usernames etc. I just need it to be filled out with tables and relations from the dump. The dump path is: C:\Documents and Settings\dump.sql. Sounds simple enough but (&%€(! Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted May 28, 2009 Share Posted May 28, 2009 I just use the pgAdmin III interface to perform such tasks. Right click on the db and search through the pop-up menu for the option that allows you to restore. Or you can probably do it from the command prompt. Did you read the postgre manual?!? Quote Link to comment Share on other sites More sharing options...
Mr. Green Posted July 24, 2009 Author Share Posted July 24, 2009 It is solved now, I made a dump of the sql and then i used the command prompt with this line: psql -1 -f dump.sql DB_name postgres (first i located the dump file in command prompt). Once you know it's simple but damn it has taken me long time. I hope you guys with similar problem will find this post quickly. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.