Category: Uncategorised

Extract data from postgres in docker and save it to csv

The case is simple postgres database is hosted in a docker image and to access the database use this command. docker image name can be found with this command docker ps -a. docker exec -it <docker-image> psql -U postgres docker exec -it <docker-image> psql -U postgres -a <dbname> -c “copy(select user_name, place_name, attempts,p.created fromplace…

Read the full article

Moodle migration

Moodle migration from one server to another while upgrading to a new moodle version Enable maintenance mode before doing anything. This will make sure that there is no data lose and also inform users that the site will not be available. Plan the migration steps before starting the migration which will speed up the process…

Read the full article

Reset password in matrix synapse

To reset the password of matrix user in debian After login as root. Change the user to postgres At the postgres prompt connect to synapse database and update users table with new hash. generate the hash with hash_password command