Re: How can I restore my data in Postgres
Posted by
Verus Open Source Support on
Nov 25, 2011; 9:13am
URL: http://ngl.70.s1.nabble.com/How-can-I-restore-my-data-in-Postgres-tp7030389p7030461.html
If you have taken a backup as .sql then these are the commands
1. Open Command prompt
2. cd C:/"Program files"/Postgresql/8.3/bin (You need get into the
bin directory)
3. psql -d newgenlib -U postgres (psql is a tool. You are connecting
to newgenlib database using user postgres). You will be prompted for
password.
4. \i <path of your sql file>
On 11/25/2011 02:12 PM, NARONG [via NewGenLib] wrote:
Hi,
Could you tell me on how can I restore my data in Postgres 8.3
from Postgres 8.0?
Normally, I do backup in insert command as file sql (*.sql).
The reason is I need to update newGenLib to Version 3.0.3.
With Postgres 8.3, I do restore but it does not allow me to click
on OK button.
Mean, I got backup file in Postgres 8.0.
Please help me in this issue
NewGenLib Open Source Support
Verus Solutions Private Limited
www.verussolutions.biz