On Wed, 13 Jun 2018 at 15:27, Conrad Djedjebi conrad.djedjebi@linaro.org wrote:
Thank you Neil,
I am writing a bash script to handle backups of my LAVA Server. I am following the recommendations available here : https://staging.validation.linaro.org/static/docs/v2/admin-backups.html
You can permanently migrate the live instance to the current postgresql, that will mean that you don't need to fettle around in the backup routine.
https://staging.validation.linaro.org/static/docs/v2/debian.html#migrating-p...
The Linaro lab just use pg_dump to create backups.
Due to some incompatibilities with Postgresql versions, I am obliged to drop lavaserver database and recreate lavaserver database before restoring the tables from my backup. I can't use *pg_restore* due to incompatibilities with Postgresql versions. *Postgresql-10 is no longer available* for debian and the latest stable version of LAVA, LAVA *2018.4-1~bpo9+1, is based on Postgresql-9.6. *When I set up LAVA in March 2018, Postgresql-10 was still available and I have been using that version. Now, to backup, I have to migrate the database from Postgresql-10 to Postgresql-9.6. *pg_restore do not allow it*.
https://packages.debian.org/sid/postgresql-10 - also available in buster.
You can quite happily run LAVA using buster if you want to migrate to postgresql-10
So, I am dropping lavaserver database, recreating lavaserver database and pushing the tables from Postgresql-10 using* psql -f* instead of *pg_restore*. For that purpose, I need lavaserver's databse password in my bash script.
regards
On 13 June 2018 at 16:10, Neil Williams neil.williams@linaro.org wrote:
On Wed, 13 Jun 2018 at 15:06, Conrad Djedjebi conrad.djedjebi@linaro.org wrote:
Good morning everyone,
I would like to know if the default password for lavaserver database created in Postgresql is available somewhere in the default configuration files?
It's in /etc/lava-server/instance.conf
Normally, this isn't useful because you also need the Django environment settings to do anything useful in the database.
The best way to interact with the database is using Python3:
$ sudo lava-server manage shell
Also, Is there a way to find out the default password for lavaserver user in the host?
The lavaserver user is created without a password. To change to that user, just use:
$ sudo su lavaserver
What are you trying to do?
regards, _______________________________________________ Lava-users mailing list Lava-users@lists.linaro.org https://lists.linaro.org/mailman/listinfo/lava-users
--
Neil Williams
neil.williams@linaro.org http://www.linux.codehelp.co.uk/