Backup Problem

[Venkatesham]

Sir/Madam,
We are Vaageswari Institute of Pharmaceutical sciences Karimnagar. Problem was ngl Backup Not comming. please soluation the problem.

[Manju Channappa]

Below is the backup and restore procedure in NGL. let me know where u r getting error or if u following different method let me know




1. Open pgAdmin III from start menu
2. Double click on PostgreSQL database server 8.3
3. Double Click on Databases
4. Right click and select backup on newgenlib(database connected to NGL software, to Check this open using wordpad dbconnection.xml file located in C:\NewGenLibFiles\HibernateConfig.  See 9th or 10 line i.e. jdbc:postgresql://localhost:5432/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

Restore
• Place the backup file in C drive
• Open command prompt type CMD and press enter
• CD C:\Program Files\PostgreSQL\8.3\bin
• psql -d newgenlib -U postgres
• \i c:/plain.sql

[K.Ramakrishnan]

[John Alex]

Sir,
This Backup Problem is Solved... Ok..alex

[Davenof]

Hello Manju,

Thank you for the instruction. However, I have followed your instructions carefully but restoring backup still did not work. I keep getting lots of 'ERROR' while the command is running. I have attached two images for better understanding.

I look forward to getting this problem resolved.

Thank you

[manjucmr]

then try the below method

1. Open pgAdmin III from start menu
2. Double click on PostgreSQL database server 8.3
3. Double Click on Databases
4.     Right click on newgenlib database-->Delete/crop-->YES
5.     Right Click on databases NEW DATABASE add below values
         Name: newgenlib
         Owner: newgenlib
         Encoding: UTF8
         Table Space: pg_default
Then Hit OK

then

• CD C:\Program Files\PostgreSQL\8.3\bin (Path may be different folder in your system)
• psql -d newgenlib -U postgres
• \i c:/plain.sql

[Davenof]

Hello Manju,

Thank you a million times.
I followed your instruction and everything is working perfectly.
At first, the OPAC search was not working, but then I figured it out and fixed it.
Now everything is in perfect shape.

Thank you my friend

NB:
I have another challenge which I started a thread for here http://forums.newgenlib.org/RunNGL3Server-Not-Working-td7577334.html. After fresh installation of NGL 3.1.1, I discovered NGL batch (.bat) files don't run, hence, I cannot start the NGL server. I have seen several articles and videos on how to fix Windows batch files, but none has worked for me so far. Any help from you please?

Looking forward to your help.

Thank you