Re: How can i transfer Data from old NGL Server system to new servser system

Posted by manjucmr on Mar 24, 2018; 9:20am
URL: http://ngl.70.s1.nabble.com/How-can-i-transfer-Data-from-old-NGL-Server-system-to-new-servser-system-tp7577286p7577292.html

Backup & restore
1. Open pgAdmin III from start menu
 
2. Double click on PostgreSQL database server 8.3 (enter password if ask)
 
 
3. Double Click on Databases
 
4. Right click and select backup on newgenlib
 
5. Select Plain Option, and select saving location of backup file(file name should be ended by .sql) and click OK
 
6. You will get Process returned exit code 0. Click on DONE to complete backing up the database
 
7. Copy the backup file to new server system to C drive
 
Restore
1. Open pgAdmin III from start menu
 
2. Double click on PostgreSQL database server 8.3
 
 
3. Right Click on Databases and select NEW DATABASE
 
4. Fill the details as NAME: newgenlib, OWNER:newgenlib, ENCODING: utf8, TABLESPACE:pg_default, then click ok
 
5. Database has been created and displayed the created database under database
6. Close the pgAdmin III
7. Place the backup file in C drive
8. Open command prompt type CMD and press enter
9. CD C:\Program Files\PostgreSQL\8.3\bin (update it as per your installation folder)
10. psql -d newgenlib -U postgres
11. \i c:/backupfile.sql
 12. Restore success full
Start the nglserver and run indexer

if any doubts whatsapp me
9880678301