Redis and database upgrade in compose

[steakhutzeee]

Hi, in my compose I'm using an old version of redis and database:

image: postgres:13 and image: redis:6.0

Is it safe to copy the updated values from the compose posted in this repo? Or I should also perform some manual upgrade? In particular for the db.

Thanks!

[stumpylog]

Redis is generally safe to upgrade to a new version. As long as no tasks are in progress, no data will be lost.

Upgrading the Postgres container is more involved. We have a small section https://docs.paperless-ngx.com/administration/#database-upgrades for that, but it can be involved. A slightly easier way to to export and re-create the database with the new version

[steakhutzeee]

No, i did:

1- exporter running postgres 13
2- recreated container with posgres 15
3- commented .env file
4- started container
5- tried to import

How can i create a new DB at this point?

[stumpylog]

You would need to clear the database folder. /srv/dev-disk-by-label-HC2/AppData/paperless-ngx_db

[steakhutzeee]

Ok, so now i:

1- cleared the database folder.
2- recreated the containers commenting lines in the .env file.
3- ran the importer

Output:

steakhutzeee@dk:/srv/dev-disk-by-label-HC2/DockerCompose/paperless-ngx$ docker exec paperless-ngx document_importer ../export
Checking the manifest
Installed 274 object(s) from 1 fixture(s)
Copy files into paperless...
  0%|          | 0/87 [00:00<?, ?it/s]
Traceback (most recent call last):
  File "/usr/src/paperless/src/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.9/site-packages/django/core/management/_init_.py", line 446, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.9/site-packages/django/core/management/_init_.py", line 440, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute
    output = self.handle(*args, **options)
  File "/usr/src/paperless/src/documents/management/commands/document_importer.py", line 149, in handle
    self._import_files_from_manifest(options["no_progress_bar"])
  File "/usr/src/paperless/src/documents/management/commands/document_importer.py", line 245, in _import_files_from_manifest
    raise FileExistsError(document.source_path)
FileExistsError: /usr/src/paperless/media/documents/originals/2019/one_of_my_files.pdf
steakhutzeee@dk:/srv/dev-disk-by-label-HC2/DockerCompose/paperless-ngx$

[shamoon]

Yes. It needs to run against a completely empty database and empty paperless dirs

[steakhutzeee]

And after i will just remove comments from the .env file and recreate the container, setting the user?

EDIT: It worked! The container started and i could access directly with my admin account. Then i removed the comments from the .env file and recreate the container.

Curiosity, in this case i was importing the admin user, so paperless-ngx was ignoring the fact that the user section in the .env file was commented out?

[github-actions[bot]]

This discussion has been automatically closed due to inactivity. Please see our contributing guidelines for more details.