[Kea-users] Memfile to Postgresql leases tool

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Kea-users] Memfile to Postgresql leases tool

Norberto Nuñez

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.: <a href="tel:&#43;595212199396">+595212199396, <a href="tel:&#43;595971577190">+595971577190

eMail: [hidden email]

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.

_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [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


_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] Memfile to Postgresql leases tool

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

-----Mensaje original-----
De: Alberto Garrido [mailto:[hidden email]]
Enviado el: viernes, 15 de enero de 2021 09:34 p.m.
Para: Norberto Nuñez <[hidden email]>; [hidden email]
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users