Re: Moving from 1.12.5 to 1.16.03
David S Hustace <[email protected]> Thu, 3 Dec 2015 01:09:37 -0500
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
--===============1073559516782605787== Content-Type: multipart/signed; boundary="Apple-Mail=_01565862-A262-4A86-B9AB-FBD2E8C73409"; protocol="application/pgp-signature"; micalg=pgp-sha256 --Apple-Mail=_01565862-A262-4A86-B9AB-FBD2E8C73409 Content-Type: multipart/alternative; boundary="Apple-Mail=_9EF45B2C-C513-49A7-BB28-3B0C464378C2" --Apple-Mail=_9EF45B2C-C513-49A7-BB28-3B0C464378C2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Oct 29, 2015, at 3:12 PM, John Hala <[email protected]> = wrote: >=20 > I'd like to know if anyone has a procedure to just export the list of = nodes and monitors that I already have defined in the existing system = and then import them into the new system. Some variant of this should work... So, *before* you upgrade: $ pg_dump --username=3Dopennms --format=3Dc \ --table=3Dnodenxtid --table=3Dnode \ --table=3Dassets \ --table=3Dopennmsnxtid --table=3Dipinterface \ --table=3Dservicenxtid --table=3Dservice \ --table=3Difservices --table=3Dsnmpinterface \ --table=3Dcatnxtid --table=3Dcategories --table=3Dcategory_node \ --verbose --file=3Dopennms_nodes.pgsql opennms $ dropdb --username=3Dopennms opennms $ createdb --username=3Dopennms opennms $ sudo /opt/opennms/bin/install -dis $ pg_restore --user=3Dopennms --dbname=3Dopennms --format=3Dc --verbose = opennms_nodes.pgsql Now, you should be able to uninstall 1.12.5 and reinstall a clean = Horizon 16.0.3 (note that your version syntax is off a bit) and you=E2=80=99= ll have your nodes in the DB. David Hustace The OpenNMS Group, Inc. --Apple-Mail=_9EF45B2C-C513-49A7-BB28-3B0C464378C2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; = -webkit-line-break: after-white-space;" class=3D""><br = class=3D""><blockquote type=3D"cite" class=3D"">On Oct 29, 2015, at 3:12 = PM, John Hala <<a href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> wrote:<br class=3D""><br = class=3D"">I'd like to know if anyone has a procedure to just export the = list of nodes and monitors that I already have defined in the existing = system and then import them into the new system.<br = class=3D""></blockquote><br class=3D"">Some variant of this should = work...<div class=3D""><br class=3D""></div><div class=3D"">So, *before* = you upgrade:<br class=3D""><br class=3D""></div><blockquote = style=3D"margin: 0 0 0 40px; border: none; padding: 0px;" class=3D""><div = class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D"">$ pg_dump --username=3Dopennms --format=3Dc = \</font></div><div class=3D""><font face=3D"Courier New" = style=3D"font-size: 14px;" class=3D"">--table=3Dnodenxtid --table=3Dnode = \</font></div><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D"">--table=3Dassets \<br class=3D""></font><font face=3D"Courier = New" style=3D"font-size: 14px;" class=3D"">--table=3Dopennmsnxtid = --table=3Dipinterface \</font><div class=3D""><font face=3D"Courier New" = style=3D"font-size: 14px;" class=3D"">--table=3Dservicenxtid = --table=3Dservice \</font></div><div class=3D""><font face=3D"Courier = New" style=3D"font-size: 14px;" class=3D"">--table=3Difservices = --table=3Dsnmpinterface \</font></div><div class=3D""><font = face=3D"Courier New" style=3D"font-size: 14px;" = class=3D"">--table=3Dcatnxtid --table=3Dcategories --table=3Dcategory_node= \</font></div><div class=3D""><font face=3D"Courier New" = style=3D"font-size: 14px;" class=3D"">--verbose = --file=3Dopennms_nodes.pgsql opennms</font></div><div class=3D""><div= class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D""><br class=3D""></font></div></div><div class=3D""><div = class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D""><br class=3D""></font></div></div><div class=3D""><div = class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D"">$ dropdb --username=3Dopennms opennms</font></div></div><div = class=3D""><div class=3D""><font face=3D"Courier New" style=3D"font-size: = 14px;" class=3D"">$ createdb --username=3Dopennms = opennms</font></div></div><div class=3D""><div class=3D""><font = face=3D"Courier New" style=3D"font-size: 14px;" class=3D""><br = class=3D""></font></div></div><div class=3D""><div class=3D""><font = face=3D"Courier New" style=3D"font-size: 14px;" class=3D"">$ sudo = /opt/opennms/bin/install -dis</font></div></div><div class=3D""><div = class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D""><br class=3D""></font></div></div><div class=3D""><div = class=3D""><font face=3D"Courier New" style=3D"font-size: 14px;" = class=3D"">$ pg_restore --user=3Dopennms --dbname=3Dopennms = --format=3Dc = --verbose opennms_nodes.pgsql</font></div></div></blockquote><div = class=3D""><div class=3D""><div class=3D""><br class=3D""></div><div = class=3D""><br class=3D""></div><div class=3D"">Now, you should be able = to uninstall 1.12.5 and reinstall a clean Horizon 16.0.3 (note that your = version syntax is off a bit) and you=E2=80=99ll have your nodes in the = DB.</div><div class=3D""><br class=3D""></div><div class=3D""><br = class=3D""></div><div class=3D"">David Hustace</div><div class=3D"">The = OpenNMS Group, Inc.</div><div class=3D""><br = class=3D""></div></div></div></body></html>= --Apple-Mail=_9EF45B2C-C513-49A7-BB28-3B0C464378C2-- --Apple-Mail=_01565862-A262-4A86-B9AB-FBD2E8C73409 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org iQIcBAEBCAAGBQJWX9yhAAoJEJsqxtS6QvjCKRIP/R4meqpZ7WVKMxaMGaoPwNfs UzXHA6RWjzId05IBpEZ76wHqKJ49IrcgRSGsHr09oqPDiNv4xATmmMV4WCGJcti3 RnE+7nxvdXosnYJ1uEb+R7ZPHgdtrJoea+EZB54kn8He22rtXnR/OqgSc40oMwZB PzrhIHs6+zd4vAOJbKHveYvBcET/0gxim9AaHlD78zbWkP2u8y3tFmKz15Iqqmt4 XwnSIrV1XhbswdiCjOKFBGEVB/RWE08vofAM4PsMHtoaGkSGinpdDr4rLzaLeuGY XxrFQ8paWM4PO1MrNZyUEcMK+6QralxGEw+lbNI34g0N6kli7slCWPjpH7nsv3j9 a2HuPlNRtRL7VDGqKExMQwGaod8GQeyBe4BVmvewZBM3cr3+C7K9dGCKANhqrhCX KOVnR7VXoZBy69tYk/L1uX4uKpaZoEoc7U8kaZBPkcSLoJg5HVEXBnJSrRvFLqPf B45+XHsDDTcoWwaoCVCcwNdZRYCLxMBNseajvXdCSn4hGNX2EBy+8thuN1gOmxea 5Rp7V8jGZ1LWooqcPozQcxaS/AVRhmJGUTC4ztn0fFaAmdUwcISq8L56QI8cXmvX 1AOBN3mtM5KMQXia00na4gIWOLbD1Tl2OFfh4YtK8NCGAtMrb+whOQkWkq40nnu/ rMtRMfGaH9EPJ8S+MUHr =1yhZ -----END PGP SIGNATURE----- --Apple-Mail=_01565862-A262-4A86-B9AB-FBD2E8C73409-- --===============1073559516782605787== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 --===============1073559516782605787== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-install mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-install --===============1073559516782605787==--