Skip to content
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

Postgres command is wrong in 'Docker installation using separate container' #2845

Open
john2exonets opened this issue Oct 6, 2022 · 0 comments
Labels
Documentation All the words.

Comments

@john2exonets
Copy link

john2exonets commented Oct 6, 2022

In the Installation doc (https://github.com/TracksApp/tracks/blob/master/doc/installation.md ) the Postgres command to create the 'tracks' user for the database has the wrong syntax -- it doesn't have all the roles needed for tracks to work!

In the Docs:

postgres=# CREATE USER tracks WITH ENCRYPTED PASSWORD 'password-goes-here';

What it needs to be in order for tracks to work with the database:

postgres=# CREATE ROLE tracks WITH LOGIN NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION PASSWORD 'password-goes-here';

Your database setup command will die with an "Unable to drop database" error when you run the 'bin/rake db:reset' if you don't give the user the CREATEDB role. You can use the ENCRYPTED PASSWORD option, but it needs to be in SCRAM-SHA-256 format to be accepted.

@ZeiP ZeiP added the Documentation All the words. label Oct 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Documentation All the words.
Projects
None yet
Development

No branches or pull requests

2 participants