[Kea-users] Memfile to Postgresql leases tool

[Alberto Garrido]

On 12/1/21 13:44, Norberto.Nunez at personal.com.py (Norberto Nuñez) wrote:
> Dears.
> Is there some tool for migrate leases DB from memfile to PostgreSQL?
> We are running Kea DHCP6 1.9.1 under Centos7.
> Kind regards.
>                         Norberto Isaac N??ez
> Ingenier?a de servicios de valor agregado, N?cleo S.A.
> M?ximo Lira n? 522, Asunci?n.
> Tel.: +595212199396<tel:+595212199396>, +595971577190<tel:+595971577190>
> eMail: Norberto.Nunez at personal.com.py<mailto:norberto.nunez at personal.com.py>
> Web: https://www.personal.com.py
>
>
>
> ________________________________
>
> AVISO LEGAL: Esta informaci?n es privada y confidencial y est? dirigida ?nicamente a su destinatario. Si usted no es el destinatario original de este mensaje y por este medio pudo acceder a dicha informaci?n por favor elimine el mensaje. La distribuci?n o copia de este mensaje est? estrictamente prohibida. Esta comunicaci?n es s?lo para prop?sitos de informaci?n y no debe ser considerada como propuesta, aceptaci?n ni como una declaraci?n de voluntad oficial de NUCLEO S.A. La transmisi?n de e-mails no garantiza que el correo electr?nico sea seguro o libre de error. Por consiguiente, no manifestamos que esta informaci?n sea completa o precisa. Toda informaci?n est? sujeta a alterarse sin previo aviso.
>
> This information is private and confidential and intended for the recipient only. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and shall not be regarded neither as a proposal, acceptance nor as a statement of will or official statement from NUCLEO S.A. . Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://lists.isc.org/pipermail/kea-users/attachments/20210112/11e7d904/attachment.htm>

Hi Norberto,

Check out this file: 
https://gist.github.com/agrrd/287446084bab09a6628a7624f394a642

In line 31 you'll have to update the input file to your Kea memfile, 
then invoke as:

$ psql -U db_user -h db_host db_name < memfile2pg.sql