Restoring backup in NewGenLib303

[Sandesh]

Dear Siddhartha,

Greetings!

Installed latest version of NewGenLib (NGL303) application with Postgresql (version 8.3) based on the instructions provided at http://www.verussolutions.biz/kb/installationNew. Both OPAC and Application Interface are accessible. However, was unsuccessful in restoring old backup with command \i C:\InstallNGL303\DBbackup\backupinplain.sql. It says, "Permission denied".

Prior, I had also tried to restore using PGAdmin III interface, but after selecting the respective backup file, the proceeding "Ok" tab was not functional.

Appreciate if you could guide me to resolve this.


Regards
Sandesh S.

[Verus Open Source Support]

Step 2: Open your Command Prompt (Start->Run->Type command cmd-> Press Enter)
1. Type the following commands one after one
C:
cd \
cd "Program Files"
cd Postgresql
cd 8.3
cd bin
psql -d newgenlib -U postgres

The last command will prompt you to enter password. Enter newgenlib as password. This will connect you to newgenlib database using psql tool. Now type the following commands

\i C:/backupfile.sql
Note: copy the backup file in C drive and rename with "backupfile.sql"

Now Refresh your OPAC. I also hope you have run Indexer

Regards
NewGenLib Open Source Support Team

[Sandesh]

Dear Team,

I followed your instructions. Am able to connect and executed the command “psql -d newgenlib -U postgres” and then with password “newgenlib”. Perhaps still getting the below error.

After running the command \i C:\backupfile.sql
it says "Permission denied"

How to resolve this? Appreciate if you could guide me to the root of this error.


Regards
Sandesh S.

[Verus Open Source Support]

Send the screen shot of the error message.

[Dr Pawan Agrawal]

I think you need to run Command prompt as admin.

[Sandesh]

Hi,

I have successfully restored the backup. Perhaps, error popped up while adding digital attachments to the bibliographic.

Inserting screenshot for your perusal.

Kindly advise.


Regards
Sandesh S.