-
-
Notifications
You must be signed in to change notification settings - Fork 750
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] - SQLite to PostgreSQL FATAL: role "root" does not exist #3892
Comments
Log FATAL: role "root" does not exist is due to an error on docker-compose file on the installation documentation (https://docs.mealie.io/documentation/getting-started/installation/postgres/). |
I came here to say that @VTerret is absolutely bang on, Thank you. |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. |
Thanks a lot! Why is this not reflected in the postgres docker compose example? I started with a fresh install and ran into the same problem. |
First Check
What is the issue you are experiencing?
I am trying to migrate from the SQLite to PostgreSQL database for performance reasons, I have thousands of recipes and the SQLite is bogged down when searching recipes, ~30 seconds to load anything.
The backup restoration is failing.
Steps to Reproduce
Please provide relevant logs
Mealie:
(Background on this error at: https://sqlalche.me/e/20/e3q8)
500 Internal Server Error "POST /api/admin/backups/mealie_2024.07.15.00.15.08.zip/restore HTTP/1.1"
PostgreSQL:
[1090] FATAL: role "root" does not exist
Mealie Version
No response
Deployment
Docker (Linux)
Additional Deployment Details
Running it on a raspberry pi
The text was updated successfully, but these errors were encountered: