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?
Also, Is there a way to find out the default password for lavaserver user in the host?
regards,
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
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/
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/
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- postgresql-versions
I saw that link. The tutorial is explaining how to upgrade Postgresql. I do not think it is addressing downgrades. May be I am wrong. I did not follow those instructions to avoid issues but may be I should give it a try.
The Linaro lab just use pg_dump to create backups
I am also creating backups with pg_dumps. The issue is not there. The issues comes when trying to restore the backup on another host. My current host is using Postgresql-10. The second host is using Postgresql-9.6 because Postgresql-10 is no longer available for the second host. Then, on the second host, I can't use pg_restore due to Postgresql compatibility issues.
One idea could be downgrading the Postgresql-10 on the first host to Postgresql-9.6 using https://staging.validation.linaro.org/static/docs/v2/ debian.html#migrating-postgresql-versions (hopping it works). Then the second host will be able to use pg_restore without compatibility issues.
regards,
On 13 June 2018 at 16:36, Neil Williams neil.williams@linaro.org wrote:
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-postgresql-versions
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/
--
Neil Williams
neil.williams@linaro.org http://www.linux.codehelp.co.uk/
-
Conrad Djedjebi -
Neil Williams