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/