Re: Copy an existing installation to another machine

Posted by Verus Open Source Support on Aug 12, 2011; 4:25am
URL: http://ngl.70.s1.nabble.com/Copy-an-existing-installation-to-another-machine-tp6657034p6679155.html

Problem: Database restoration did not take place properly.
Solution:
On your System 1 (Which holds the actual installation)
1. Take a backup using pagmin3 (compressed backup)
2. Copy this backup file into your target system

On your system 2 (Target system)
1. Close all applications
2. Open PgAdmin. Select newgenlib database and right click and delete/drop it
3. Create a new database newgenlib (encoding UTF8, owner newgenlib...rest of all the parameters can be left as they are)
4. Select newgenlib database, right click and click on restore. Now point to the backupfile you have taken from your System 1.
5. Check the number of tables after the restoration process. They must be approximately 308.
Thats it

6. Start Tomcat server
7. Build Index