{"_id":"@ben_lubar/nodebb-postgres-converter","_rev":"10-a0179edf24e90dd5b09534d0f838533b","name":"@ben_lubar/nodebb-postgres-converter","dist-tags":{"latest":"0.1.1"},"versions":{"0.0.0":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.0","description":"","main":"index.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"bluebird":"^3.5.0","command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"c6d600ca32e45bf0b590494f89189fc91c1a8be0","_id":"@ben_lubar/nodebb-postgres-converter@0.0.0","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-0PuAq2pgcLLTDi0mPl/JXc+T52ARm1IlJCPwfF1FHYThTbjXn3V35mbODHPqPRifPDKw+9z3HDbupVn3wiq5Mg==","shasum":"a5c9b3c0361e9ad19b9b8099dca4183d4692f5e3","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.0.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHtK3gOc5YG7iiCtO6GfISQd9ucTTq9vgc6f5pa0cqNcAiBRBn6TJkCtUaokEK5iKdySQlT/kGoiU8/61OxWEtZp8g=="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.0.tgz_1504571663759_0.7541532388422638"},"directories":{}},"0.0.1":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.1","description":"","main":"index.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"bluebird":"^3.5.0","command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"dc60fdc1dc5380c5f060cc331ae10c5a30d4d435","_id":"@ben_lubar/nodebb-postgres-converter@0.0.1","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-3YK7AaKkMa0iKDkXXmj0QawVA/5tBYzxnn3oLqOEpaEUTvJtFYmgGK/J4ob0Q2DQTvmLqaQqiy2R/H/Ao3TpHQ==","shasum":"77203ac5bffb8981dfa23ff11b7f75147f44bfb1","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.1.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFvTdRVI3q59pqxaUFwrZS4cK4oPw2DznLB6cetg4q/XAiEAnWv7gTFpAUcsqMmgdT+k3NJ+PMm1KEmxwn7bQlrTm7Y="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.1.tgz_1504628819277_0.47325003263540566"},"directories":{}},"0.0.2":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.2","description":"","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"bluebird":"^3.5.0","command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"ae559a074b03810aa91f8597ae182886b559103c","_id":"@ben_lubar/nodebb-postgres-converter@0.0.2","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-eAtE1SeU2ABPly6OTriSrLP61tQ75DYyJCwqluUHS2yKrbLZpdOKAjst6i9PJfVr24m6X3wzUtdFncUjMNSjoQ==","shasum":"6326c5595bd3d9ccfba5646202abe69805c47f56","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.2.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFTTYHHHu0l3qCQpzoWKsdV65OttasYbdTXRe8GxbS/eAiEAuBT1LKBB3V6HgVZBskuy8q8mJZd708hCTrLozrJc/oI="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.2.tgz_1504632297053_0.07009340426884592"},"directories":{}},"0.0.3":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.3","description":"","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"bluebird":"^3.5.0","command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"474a8d6d5f215ee1b4beab327bd587cef4c24089","_id":"@ben_lubar/nodebb-postgres-converter@0.0.3","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-sp7p7gL5SfZptR37ruP96dtjHyXWG7z0vCIgAmG4R0HBLGa37dy5cT6HZAzJFdny1SoOp9n/ZKmkMvzYAGMDdg==","shasum":"ac8bc43fd87fc6ebe48d734faaf7f9fd6ef6a25c","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.3.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC8uTWXkxbOvZi+0HsCPHAr6qwTurzjzHpzbGpjVWAS2AIhANCGTLkxDpr3kgHXIfYAzgK/TwjA/P3U7pLD1VElBdzJ"}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.3.tgz_1504813235474_0.7536370409652591"},"directories":{}},"0.0.4":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.4","description":"","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"bluebird":"^3.5.0","command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"ab7a8286bdde9ac6cdb69ac476aa0bf66bd09caa","_id":"@ben_lubar/nodebb-postgres-converter@0.0.4","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-6FX0eyZeUZbv1ldAZ4GjWnsUowTfm6WftmK2g4z0iU1h0y4apdk4NJAgCfAKqzJn1vgJ73Zd7rQtJqOD4hqsQw==","shasum":"52982760ef739af2ca7174c5239a1d2087af3308","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.4.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAaJH5DefzTbr+QsWdLVGfKD2RVlwZ908ZofSbHSfF+rAiA/o5paY8yXe23GovbmOM/6k2nwkx/8yfTIkwRPbhEMoQ=="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.4.tgz_1504972302307_0.01849621976725757"},"directories":{}},"0.0.5":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.5","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database.","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"09e7a06e0761541c2c160074022bda3da59a3d29","_id":"@ben_lubar/nodebb-postgres-converter@0.0.5","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-OewxK3sj6Ugh0lspI5L031KtUY1vX/gqe3XEAheUihhP0ihHnd+Sq0sksRreL/NDL0KYZt+lJu+yK2w4Od/XtA==","shasum":"e9cbdc273696c0d710dbaf0afb26a85996f4ff1d","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.5.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGHQ5D4JUjZGuTXV/mz8l4JoHDO1NPwaxmYVZAbR5rZgAiEAwrxfkeBoua6tLOoWknoqcRObZMXlpHIy+YDDSSlkspk="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.5.tgz_1505138252463_0.613151942845434"},"directories":{}},"0.0.6":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.6","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database.","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"7320b000bd68c42d98afa55e4900111c7de89f70","_id":"@ben_lubar/nodebb-postgres-converter@0.0.6","_npmVersion":"5.3.0","_nodeVersion":"8.4.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-BCn+uMiZCs7uYFdSxx0RaZnWq+QoX+CtAltsOtmn0VvVz0GCWDXI0lJ1+CzHYdqGYivSx3dPuf/9yUzA7cOwvw==","shasum":"4556ad75ce4b89da54a7c9d67b6b8971cb591fdf","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.6.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD3bmXsfqR7P26pGxXEJif9soNWGJrK5pRg6EN+QNGPbgIgMGUj/HyGr+NhMtIRoOUa7RpA5QGDBHBqEn2eXv0vAE0="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.6.tgz_1505259999354_0.341506265103817"},"directories":{}},"0.0.7":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.0.7","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database.","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"command-line-args":"^4.0.7","command-line-usage":"^4.0.1","console-stamp":"^0.2.5","mongodb":"^2.2.31","pg":"^7.3.0","pg-copy-streams":"^1.2.0","pg-query-stream":"^1.1.1","redis":"^2.8.0"},"gitHead":"9495258a130dbfceb9545d350c3506035831bdde","_id":"@ben_lubar/nodebb-postgres-converter@0.0.7","_npmVersion":"5.3.0","_nodeVersion":"8.5.0","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-2Nq6o96bB2m2bARTh/jS9eeWISIbSow7T8JINy3pcIBwlGcr8P6lVlkMzQf+WhpO/fsvuw42u9LFomezrEufCg==","shasum":"fa6c62df86e57a1de1c41852f9a0cdeb481b07b0","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.0.7.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCxKcBqAZgJfTfE1TpRQSadh+fljA4kmNAW9RF4xm8SWwIgWX40tnWJxnTdGRCFE05BiQUnlKhDbRVRHOVMu2ValkY="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.0.7.tgz_1505607983309_0.9986863057129085"},"directories":{}},"0.1.0":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.1.0","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database.","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"command-line-args":"^4.0.7","command-line-usage":"^4.1.0","console-stamp":"^0.2.6","mongodb":"^2.2.34","pg":"^7.4.1","pg-copy-streams":"^1.2.0","pg-cursor":"^1.3.0","redis":"^2.8.0"},"gitHead":"5efb7bc4dccf3d29637992a079206ae9d239cdf9","_id":"@ben_lubar/nodebb-postgres-converter@0.1.0","_npmVersion":"5.6.0","_nodeVersion":"8.9.4","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-QSt/hGaJuBKD3QcixfdR5pmAa4QyEcwLi+uy4K7yVrgLUIGNQoeTKQvYTeX65eAeHCjLDb344C231PIpTiceMw==","shasum":"dc6e7473284802d828b8c336ec0907c8f1e149ec","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.1.0.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGUyiVoaWdHYhID76q3hDSUbbNNT5XR314+FtiXCVaknAiBQPnIuo7sLNiD7h15Hjw22ySsMKim9O2kLKUqmNCZiSA=="}]},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter-0.1.0.tgz_1516486481984_0.3586940031964332"},"directories":{}},"0.1.1":{"name":"@ben_lubar/nodebb-postgres-converter","version":"0.1.1","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database.","main":"main.js","bin":{"nodebb-postgres-converter":"bin/converter.js"},"repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"license":"MIT","bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","dependencies":{"command-line-args":"^4.0.7","command-line-usage":"^4.1.0","console-stamp":"^0.2.6","mongodb":"^2.2.35","pg":"^7.4.3","pg-copy-streams":"^1.2.0","pg-cursor":"^1.3.0","redis":"^2.8.0"},"gitHead":"28e19c27405b4bcf91b4724b6f80ed5918ad245e","_id":"@ben_lubar/nodebb-postgres-converter@0.1.1","_npmVersion":"5.6.0","_nodeVersion":"8.11.3","_npmUser":{"name":"ben_lubar","email":"ben.lubar@gmail.com"},"maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"dist":{"integrity":"sha512-4r8PwTd+oLf8Z/iqHMSGMnkd0dLXCJnf8qCrzZwMNRzPhMtF+H7JRGsO18Nf5PihqhSp140xhvYLRBrOj849UQ==","shasum":"fedb51ffa108c1f4b28ff83ce199262f32f5ceda","tarball":"https://registry.npmjs.org/@ben_lubar/nodebb-postgres-converter/-/nodebb-postgres-converter-0.1.1.tgz","fileCount":20,"unpackedSize":42083,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbMSZiCRA9TVsSAnZWagAAEQgP/1/m1o/duvHmsnKq0ogh\nnj74UfKnLoWL8BZM5Z5EkGpBURSIj4aGZAZxvcQlJnRafjiIwe2e8ghSV/fw\ny1dbRmhYJft40eG4JEyK+PpPfidXBYulm45BsotkTV9aeMRf21+l3118AGJO\np5aJ8Chf5IdX0JeNfVed28FnNVh0h5Me/zQNSyVj07J1XSIkJtYiBkFuqvw+\nb008n8HM5UVT9gKFnJoAZEf6VCmPGE7vQ/5dVx4D7dXF++AlwbOGc0YuDrJ9\nXQUJrJ/qoZ5JnauPt5wUQmpolwdleIRNm9XEUuRxGNhfyuSezuiT8gn8EkBN\n8gZFR07fplGS11ARiBHTWUnhc7r5K8jgy8z2U35CvwzAXeLMMDUoG1PSPJIe\nRIva0KeirLs9FYeTSvSkvAV7cYa5sSyJORLtMuMIRr+Yj++tS96kOIf5L28G\nR25oXrmLU7D8JjCH/MLMZhDKeCByftvoo2IIjxs5ZiuRf281vrCeghAK0bYi\nCsVeY+TfbQ7tGLGu9CKqC+BdoXCCxmrLiCoIUHOvv+NakGXCxZOaEC/T4YuY\n009BTiTSpEiWhpe74V2Qywb7/XW9ggSFQtfr54OHFoa+fBCZTIo6u/pXJuol\nhzVT3FTQM+ZnK2WfZDjLCIClYv2Q3XTER/qwaVuBSGLh8V1uBtD+p/7ju2fI\n+OEi\r\n=6XQh\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC7ChnuwYX4rNbNle3YZFtyLEcT1l+WhSpnEXe1YkSljgIhAOx6O11/makDseAPwenQkPAro1/ni3nb76/EQYL9Ny0r"}]},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/nodebb-postgres-converter_0.1.1_1529947745391_0.4379281005300657"},"_hasShrinkwrap":false}},"readme":"nodebb-postgres-converter\n=========================\n\nConverts an existing NodeBB NoSQL database to a relational PostgreSQL database.\n\nSee also: <https://gist.github.com/BenLubar/dd816c736a9a1cbd70e3469828b96e5d>\n\nSupported database types\n========================\n\n- **Redis** 2.8.9+\n- **MongoDB** 3.2+\n- **PostgreSQL** 9.5+\n\nInstructions\n============\n\nDownload nodebb-postgres-converter, either by cloning this repository and\nrunning `npm install` or by installing globally with the command\n`npm install -g @ben_lubar/nodebb-postgres-converter`\n\nMake a backup of your NodeBB database and decide whether you'd prefer downtime\nor the loss of data more recent than your backup. In the future, there will be\na plugin that will record changes made to the live database and then play them\nback on the converted database.\n\nSet up your destination database. This can be any of the supported database\ntypes listed above. If you decided to keep the forum running during this\nprocess, set up another copy of your source database(s) from the backup.\n\nDatabase connection URLs\n------------------------\n\nDatabase connection URLs follow the same format no matter which database you're\nusing: `type://username:password@ip:port/database`\n\n- **type**: `redis`, `mongodb`, or `postgresql`\n- **username:password@**: The username and password for the source/destination\n  databases. If you're doing this process on a server where the database cannot\n  be accessed externally and you don't have a username or password set up for\n  the database, you can skip the `:password` part or the entire authentication\n  section of the URL.\n- **ip**: The IP address or hostname of the database server.\n- **:port**: The port number the database server is listening on. This can be\n  skipped if you are using the default port for that database type:\n  - **Redis** 6379\n  - **MongoDB** 27017\n  - **PostgreSQL** 5432\n- **database**: The database name (or number for Redis). Common examples\n  include `0` for Redis and `nodebb` for MongoDB and PostgreSQL. For a\n  PostgreSQL destination, the database must already be created.\n\nPostgreSQL performance tips\n---------------------------\n\nDisabling certain safety features in a PostgreSQL destination database will\nimprove performance. Just remember to turn them back on before going live.\n\nTry running these commands:\n\n```\nALTER SYSTEM SET wal_level = 'minimal';\nALTER SYSTEM SET archive_mode = 'off';\nALTER SYSTEM SET max_wal_senders = 0;\nALTER SYSTEM SET autovacuum = 'off';\n```\n\nFollowed by restarting the PostgreSQL database before the conversion. After the\nconversion, run `ALTER SYSTEM RESET ALL` and restart the database again.\n\nDisabling these features would normally make your database vulnerable to data\nloss during a power failure or a crash, but if the conversion process is\ninterrupted, you can just start over from the backup.\n\nRunning the command\n-------------------\n\nNow that you're ready, run the command:\n\n- The command starts with `bin/converter.js` if you cloned the repository or\n  `nodebb-postgres-converter` if you installed globally.\n- Next, add the databases. You always need an output database (`--outputType`,\n  `--output`), and you need the object database (`--type`, `--input`) or the\n  session database (`--sessionType`, `--sessionInput`) or both.\n  - The type is `redis`, `mongo`, or `postgres`, following NodeBB's database\n    naming convention.\n  - The input or output parameter is a database URL as described above.\n- If you're converting to PostgreSQL, adding an argument like `--memory 4GB`\n  will make the conversion go faster by temporarily allowing PostgreSQL to use\n  up to 4GB of memory for maintenance tasks. PostgreSQL allows 64MB of memory\n  by default, so for a large forum, creating indexes and clustering the data\n  will take a long time without increasing the memory limit.\n\nIf you are running the command remotely (such as over SSH), I suggest using a\nprogram like `screen` to separate the conversion process from your SSH session,\nso that the conversion process can continue if your SSH connection is lost.\n\nA complete command looks like this:\n\n```bash\nnodebb-postgres-converter \\\n\t--type mongo --input 'mongodb://localhost/nodebb-copy' \\\n\t--sessionType redis --input 'redis://localhost/0' \\\n\t--outputType postgres --output 'postgresql://localhost/nodebb' \\\n\t--memory 12GB\n```\n","maintainers":[{"name":"ben_lubar","email":"ben.lubar@gmail.com"}],"time":{"modified":"2022-04-04T18:21:37.809Z","created":"2017-09-05T00:34:24.699Z","0.0.0":"2017-09-05T00:34:24.699Z","0.0.1":"2017-09-05T16:27:00.190Z","0.0.2":"2017-09-05T17:24:58.033Z","0.0.3":"2017-09-07T19:40:37.262Z","0.0.4":"2017-09-09T15:51:43.310Z","0.0.5":"2017-09-11T13:57:33.469Z","0.0.6":"2017-09-12T23:46:40.414Z","0.0.7":"2017-09-17T00:26:24.447Z","0.1.0":"2018-01-20T22:14:42.923Z","0.1.1":"2018-06-25T17:29:06.346Z"},"homepage":"https://github.com/BenLubar/nodebb-postgres-converter#readme","repository":{"type":"git","url":"git+https://github.com/BenLubar/nodebb-postgres-converter.git"},"author":{"name":"Ben Lubar","email":"ben.lubar@gmail.com"},"bugs":{"url":"https://github.com/BenLubar/nodebb-postgres-converter/issues"},"license":"MIT","readmeFilename":"README.md","description":"Converts an existing NodeBB NoSQL database to a relational PostgreSQL database."}