We migrated our domains from our old server to a new CentoOS6.2. machine in the same data center. First i want to thank you people for the dream machine that you have created and continue to support. Simply click backup on one domain. drop to terminal and scp -prv mydomain.com.tar.gz to the other machine and then use restore (note back ups in 3.75 create *.tar.gz files but restore in 3.9 requires .tgz files... fortunately all you have to do is rename them and restore works)
OK so we had some remaining PostGreSQL databases to migrate that were not connected with any domains so we dumped these manually using pg_dump on the old machine and copied to the new machine. On the old machine we had upgraded to PostGreSql 9.0, but when we use WebMin 3.90 on the new box i.e. the PostGreSQL module to restore the databases, he barked at us saying the current PostGreSQL version on the new machine was old 8.1... So we upgraded PostGreSQL on the new box and then used the WebMin PostGreSQL to load the new databases.
Then a funny thing happened:
1) The PostGreSQL module disappears from the servers list in the left hand navigation panel in Web Min. 2) But, oddly: the Webmin PostGreSQL module is there and works:
https://##.##.##.##:10000/postgresql/
Gets me into the WebMin PostGreSQL module. Everything works, I can view the databases, look at table lists, view data, add users, set passwords all via this Web Min interface.
But, PostGreSQL is not listed under the servers on the left.
And to make things spicier. The upgrade of PostGreSQL and the restore of some databases wiped out some existing PostGreSQL data bases. Fortunately these were empty databases generated automatically because the plans for these domains had "PostGreSQL Database Enabled" set to on... but they were not in fact using them, so the data bases had no tables/data. I suspect this was an effect of restoring the domains with PostGreSQL version 8.1 in play. Then the upgrade process wiped them out.
I ran /etc/init.d/webmin restart thinking that we just have to let Virtual/Webmin re-read the existing processes and that it would then pick up the new 9.1.3 PostGreSQL in the Servers Navigation list, but nope... still does not appear.
So I will just book mark the URL for now..
https://##.##.##.##:10000/postgresql/
Comments
Submitted by JamieCameron on Sat, 03/03/2012 - 15:59 Comment #1
This can happen if PostgreSQL was installed after Webmin / Virtualmin, which means the PostgreSQL module will still appear under the "un-used modules" category.
The fix is to click "Refresh modules" on the left frame.
Submitted by katir on Sat, 03/03/2012 - 20:50 Pro Licensee Comment #2
"Sweet" -- that worked
thanks and aloha!
Submitted by JamieCameron on Sat, 03/03/2012 - 21:23 Comment #3
Submitted by Issues on Sat, 03/17/2012 - 22:34 Comment #4
Automatically closed -- issue fixed for 2 weeks with no activity.