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

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.

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/