Dear Alberto.
Thank you very much. I am going to try that.
Kind regards.
Norberto Nuñez

-----Mensaje original-----
De: Alberto Garrido [mailto:[email protected]]
Enviado el: viernes, 15 de enero de 2021 09:34 p.m.
Para: Norberto Nuñez <[email protected]>; [email protected]
Asunto: Re: [Kea-users] Memfile to Postgresql leases tool

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/11e7d9
> 04/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



________________________________

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.
_______________________________________________
ISC funds the development of this software with paid support subscriptions. 
Contact us at https://www.isc.org/contact/ for more information.

To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.

Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to