Hi Philippe Mazet,
Please find my comments inline.
Questions: - Does Linaro's docker-compose solution modify postgres restore mechanism in any way? [Koti] --> I am not sure about this. - How do you handle backup/restore at linaro? [Koti] ----> still are you facing the backup/restore issue after following the below documentation?
1. https://docs.lavasoftware.org/lava/admin-backups.html 2. http://postgresguide.com/utilities/backup-restore.html
Regards, Koti
On Fri, 19 Mar 2021 at 17:30, lava-users-request@lists.lavasoftware.org wrote:
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:
- 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