Problem of Installation with backup file

[rsgiri]

We have a problem to upgrade with the existing backup.
System Description:

OS – WindowsXP
Java - jdk1.6.0_24
Postgresql: postgresql-8.3.15-1
Newgenlib version: InstallNGL303 (114306 kb)
Our backup data of Newgenlib 2.0.1 version is about 172 mbps (.sql file with insert command). The earlier version of newgenlib was in postgresql is in 8.0
The Screenshot of the problem is


We have also tried in a different way. After installing the Postgresql 8.3, we mounted the backup file(i,e. .sql file with insert command). Then upgraded the batch file in INSTALL303.
In this method, the installation was successful. We see the data in circulation. How many and which documents are issued on whose name but search catalog function is not functioning or the search in OPAC is not functioning.

[Verus Open Source Support]

The errors are not be worried about.
You are unable to "Search catalogue" because you have not Indexed the database.
I am assuming you have followed installation notes as in http://www.verussolutions.biz/kb/installwithdbbackup
Please see step 3 under "Check if the installation is working" section
I have pasted the instruction for your convenience

"3. Now the Installation is running, we will now have to create a Solr Index of Bibliographic and Authority data. Please note that unless you execute this step you will not be able to make searches.
Go D:/InstallNGL3.0 directory you will find a file BuildIndex batch file. Double click on this file. This will create Bibliographic and Authority data Index."

Regards
NewGenLib Open Source Team

On 09/28/2011 04:19 PM, rsgiri [via NewGenLib] wrote:

We have a problem to upgrade with the existing backup.
System Description:

OS – WindowsXP
Java - jdk1.6.0_24
Postgresql: postgresql-8.3.15-1
Newgenlib version: InstallNGL303 (114306 kb)
Our backup data of Newgenlib 2.0.1 version is about 172 mbps (.sql file with insert command). The earlier version of newgenlib was in postgresql is in 8.0
The Screenshot of the problem is


We have also tried in a different way. After installing the Postgresql 8.3, we mounted the backup file(i,e. .sql file with insert command). Then upgraded the batch file in INSTALL303.
In this method, the installation was successful. We see the data in circulation. How many and which documents are issued on whose name but search catalog function is not functioning or the search in OPAC is not functioning.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Problem-of-Installation-with-backup-file-tp6839706p6839706.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.

[rsgiri]

Dear Open Source Team,

Thanks for your immediate and positive reply. The problem has been solved.

We installed it as following way.
1. Installed Java and setting up of JAVA_Home
2. Installed Postgresql 8.3 as per installation instruction
3. Then in Postgresql we created a newdatabase newgenlib as
CREATE DATABASE newgenlib
  WITH OWNER = postgres
       ENCODING = 'UTF8';
then mounted the backupfile (in .sql with insert command)
4. Then changed in the :/InstallNGL303/apache-ant-1.8.1/bin/config.ini
as restore.database=original.
5. Double Clicked on install batch file.
After installation double clicked on upgrade batch file
then indexed Solr index.
It is then working fine.

I have tried several times by follwing the instrucion for 'installwithdbbackup' (i.e., putting our backupfile in DBBackup folder). But it did not work. The problem as mentioned in the screenshot arises.
Kindly let me know, whether my process is right else what problems can arise in future?

I have another query? when we freshly install NGL3.0.3, we see that the database newgenlib with owner newgenlib, as a superuser newgenlib is being created.
Will there be a problem as in my process owner is postgresfor the newgenlib database
Kindly clarify it.
Regards