Beginner: Scripted Bare Metal, move from SQLite to PostgreSQL

[method1020]

I have a VM running (Ubuntu install) a fresh InvenTree install from the 'bare metal' script provided in the docs. How would I go about moving this to a better suited database such as PostgreSQL?

I performed the PostgreSQL install:

Install POSTGRESQL:

sudo apt-get install postgresql postgresql-contrib libpq-dev
sudo service postgresql start
sudo -u postgres psql

and setup the user/database as described in the docs:

create database inventree;
create user myuser with encrypted password 'mypass';
grant all privileges on database inventree to myuser;
\q

(with changes to myuser and mypass)

The next steps i'm stuck on. it looks like i need to install psycopg2 pgcli via pip, do i do this in a virtual environment? Did the scripted install make a virtual environment?

I did also change the config file from

  ENGINE: sqlite3
  NAME: '/opt/inventree/data/database.sqlite3'
  USER: sampleuser
  PASSWORD: samplepassword
  HOST: samplehost
  PORT: sampleport

to

 ENGINE: postgresql
 NAME: inventree
 USER: inventree
 PASSWORD: inventree_password
 HOST: 'localhost'
 PORT: '5432'

(with changes to name/user/password where appropriate)

Sorry I'm learning a lot here as I go.

[matmair]

@method1020 you will need to install the packages in the env for InvenTree. It was created on package install in /opt/inventree/env .
You then need to export your database with inv export-records, switch the config.yaml and import the records again with inv import-records. Both while you are in the env.

[matmair]

@method1020 did this wok?

[method1020]

I am having difficulty but its completely on me I think. I never quite remember how to get back into my virtual environment.

[matmair]

@method1020 would a link to a guide on python venvs help? If you have any feedback on the docks feel free to open an issue or put them here. The project should be as approachable as possible. As dev it is often hard to anticipate what info needs to be included as you are very involved in the architecture and just take non-logical things for granted.

[matmair]

And another thing: we all started at zero once, you really do not need to apologise for learning new stuff. Linux, docker, python, ... - it can be a lot and that is ok.

[rui0707]

Hi - I am having the same issue, installed Inventree using the automatic script but every time I tried to migrate to postgress it says no migrations to apply when running the invoke update cmd