Re: How can I restore my data in Postgres

Posted by Verus Open Source Support on Dec 15, 2011; 5:25am
URL: http://ngl.70.s1.nabble.com/How-can-I-restore-my-data-in-Postgres-tp7030389p7096158.html

Hi,
From the screen shot, we can say that the NewGenLib Application is unable to connect to database. Make the following checks
Check 1: C:/NewGenLibFiles/HibernateConfig/dbconnection.xml: This file must be pointing to the right IP address and database. Please check this.

Check 2: Start->Programs->Postgresql{Version}->Configuration files->postgresql.conf file
listen_addresses='*'
port=5432
There must be no hashes in from of these lines

Check 3: Start->Programs->Postgresql{Version}->Configuration files->pg_hba.conf file
Go to the bottom of the file, you will find a line
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

replace it with
# IPv4 local connections:
host    all         all         0.0.0.0/0          trust

After all these 3 checks
1. Go to Control panel->Administrative tools->Services. Here restart Postgresql database service. This service must restart smoothly without a problem.
2. Start Apache tomcat server

Regards
NewGenLib Open Source Team



On 12/14/2011 06:18 PM, rsgiri [via NewGenLib] wrote:

Dear NGL Team,
I have updated newgenlib2.1 to 3.03U2. The system is working fine. I have then backup through pgadmin3 in plain format with insert commands as .sql file.
Then deleted the newgenlib database. then again created newgenlib and then resotred the backup .sql file. Then, I started the NGL server. But the following problem is shown in OPAC.

Please help us.

---

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

http://newgenlib.2944635.n2.nabble.com/How-can-I-restore-my-data-in-Postgres-tp7030389p7093402.html

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