Re: backup & Restore Newgenlib

Posted by verussolutions on Nov 15, 2010; 9:37am
URL: http://ngl.70.s1.nabble.com/backup-Restore-Newgenlib-tp5739218p5739352.html

If you are taking a backup in plain sql format, then you cannot restore it using pgadmin3. Restoration can be done using the compressed format only.

Using your command prompt go to C:/Program files/postgresql/8.0/bin directory.
1. Type this command psql -d newgenlib -U postgres
2. You will get a prompt newgenlib-# or something like this
3. Now enter \i <path of the plain sql format>

If you have a database that is working fine; do not use above commands
However if you have a database that is blank (with out newgenlib schema) then you can use the above commands