Send Lava-users mailing list submissions to
        lava-users@lists.lavasoftware.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.lavasoftware.org/mailman/listinfo/lava-users
or, via email, send a message with subject or body 'help' to
        lava-users-request@lists.lavasoftware.org

You can reach the person managing the list at
        lava-users-owner@lists.lavasoftware.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Lava-users digest..."


Today's Topics:

   1. LAVA master backup/restore (Philippe Mazet (OSS))


----------------------------------------------------------------------

Message: 1
Date: Thu, 18 Mar 2021 15:22:20 +0000
From: "Philippe Mazet (OSS)" <philippe.mazet@oss.nxp.com>
To: "lava-users@lists.lavasoftware.org" <lava-users@lavasoftware.org>
Subject: [Lava-users] LAVA master backup/restore
Message-ID:
        <PR3PR04MB7244B9C1456CAD918574F1218B699@PR3PR04MB7244.eurprd04.prod.outlook.com>

Content-Type: text/plain; charset="us-ascii"

Hi all,

I am using the docker-compose solution to run a master: https://git.lavasoftware.org/lava/pkg/docker-compose
I was wondering how to extract a backup of the DB, and re-inject it in a different instance.

I found that postgres image has its own "restore" mechanism, based on initdb.d folder, as mentioned in the documentation:
https://registry.hub.docker.com/_/postgres/

The entrypoint.sh script (https://github.com/docker-library/postgres/blob/master/docker-entrypoint.sh) handles the restore whenever the folder is /docker-entrypoint-initdb.d/ contains a .sql file.

But when we store a backup in the container's  /docker-entrypoint-initdb.d/ folder, and remove both the postgres image and its db-data volume, we get this error on next start:
ERROR:  database "lavaserver" already exists
Full startup log attached.

Questions:
- Does Linaro's docker-compose solution modify postgres restore mechanism in any way?
- How do you handle backup/restore at linaro?

Thanks a lot in advance,


Philippe Mazet
NXP Semiconductors - Edge Processing
Email: philippe.mazet@nxp.com



-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: lava-docker-compose-restore-failure.txt
URL: <http://lists.lavasoftware.org/pipermail/lava-users/attachments/20210318/fcac51a4/attachment-0001.txt>

------------------------------

Subject: Digest Footer

_______________________________________________
Lava-users mailing list
Lava-users@lists.lavasoftware.org
https://lists.lavasoftware.org/mailman/listinfo/lava-users


------------------------------

End of Lava-users Digest, Vol 31, Issue 6
*****************************************