From: awalsh <aw...@me...> - 2009-10-29 02:14:30
|
Dear users, Something related about moving db, from our GN use. Yesterday we moved our GN-Oracle db from one server to another and all went fine. We copied the whole db schema to the new server using the Oracle sqldeveloper tool and then used GAST to point to the new server/db. Andrew ----- Original Message ----- From: "heikki" <tro...@gm...> To: "Nutsch, Bob D." <bn...@nd...> Cc: <geo...@li...> Sent: Thursday, October 29, 2009 4:22 AM Subject: Re: [GeoNetwork-users] Saving and restoring GeoNetwork > hi Doug, > > in the Dutch INSPIRE portal project www.nationaalgeoregister.nl we have > moved several times from one server to another. We've always dumped the DB > content, than imported that into the DB on the new server. Using GAST to > export all metadata records will give you only that, but you'll want the > complete DB contents, including your users, groups and harvesting settings > etc. > > After importing you may need to adjust some of the settings in the admin's > settings page, such as the server URL if you're not using a domain name. > > The procedure to export and import the complete DB depends on what brand > you're using, but in general it should be a simple operation. > > If you're also moving from one make of DB to another, the process may be > slightly more involved. For an example on how to move from a MySQL to a > Postgres DB, see the description at http://geonetwork.tv/postgres/. > > > Kind regards > Heikki Doeleman > > > > > > On Wed, Oct 28, 2009 at 5:56 PM, Nutsch, Bob D. <bn...@nd...> wrote: > >> Hi Doug, >> >> In general, as you indicated, I too would use GAST to export then import >> all metadata records. However, we've recently "moved" GeoNetwork from test >> to production using the following steps (the text is from our developer, >> Chris. H.): >> >> It's the database folks that make it easy here. I put in a service request >> to copy the entire schema from test to prod and it magically gets done. :) >> If one is using the McKoi database that comes default with GeoNetwork, there >> is some documentation for it here: http://www.mckoi.com. One should >> probably switch to something like MySQL, as some of the other users have >> done. Then, follow the backup/restore process for that database. The images >> are stored on the file system and need to be backed up separately. We >> haven't worried about copying the Lucene data, as rebuilding it hasn't taken >> very long. >> >> Our process for moving to production was: >> Copy everything in the database to a production server. Copy the images to >> the new server. Update various configuration settings and paths (I have an >> Ant script to manage these settings) >> Database connection info in GeoNetwork's config.xml to point to the >> new database >> GeoNetwork's host in the settings table (or in the ui) >> GeoServer url in intermap config >> Proxy base url in GeoServer's config >> GeoServer's log file location >> >> >> Regards, Bob >> >> >> Bob Nutsch >> GIS Coordinator >> State of North Dakota >> Phone: (701) 328-3212 >> bn...@nd... >> www.nd.gov/gis >> >> >> >> >> >> -----Original Message----- >> From: Doug Nebert [mailto:ddn...@us...] >> Sent: Tuesday, October 27, 2009 12:56 PM >> To: geo...@li... >> Subject: [GeoNetwork-users] Saving and restoring GeoNetwork >> >> It is not clear to me how one would backup and then restore a GeoNetwork >> instance, say to move it from a development to a production machine or >> to perform a restore in case of disk corruption. I see that certain >> metadata files through a query can be saved by GAST, but not all files. >> Moreover, one needs to save all configuration info for harvest and site >> administration -- essentially all the data in the database and Lucene. >> >> How have other users transferred full GeoNetwork instances from one host >> to another? >> >> Doug. >> >> -- >> Douglas D. Nebert >> Senior Advisor for Geospatial Technology, System-of-Systems Architect >> FGDC Secretariat T:703 648 4151 F:703 648-5755 C:703 459-5860 >> >> >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart your >> developing skills, take BlackBerry mobile applications to market and stay >> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >> http://p.sf.net/sfu/devconference >> _______________________________________________ >> GeoNetwork-users mailing list >> Geo...@li... >> https://lists.sourceforge.net/lists/listinfo/geonetwork-users >> GeoNetwork OpenSource is maintained at >> http://sourceforge.net/projects/geonetwork >> >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart your >> developing skills, take BlackBerry mobile applications to market and stay >> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >> http://p.sf.net/sfu/devconference >> _______________________________________________ >> GeoNetwork-users mailing list >> Geo...@li... >> https://lists.sourceforge.net/lists/listinfo/geonetwork-users >> GeoNetwork OpenSource is maintained at >> http://sourceforge.net/projects/geonetwork >> > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > GeoNetwork-users mailing list > Geo...@li... > https://lists.sourceforge.net/lists/listinfo/geonetwork-users > GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork > > |