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

README for materials/1-dimensional-data-modeling missed user creation step #129

Open
gitgithan opened this issue Nov 18, 2024 · 1 comment

Comments

@gitgithan
Copy link

gitgithan commented Nov 18, 2024

Run this command after replacing <computer-username> with your computer's username:

psql -U <computer-username> postgres < data.dump

This command failed until I did CREATE ROLE <computer-username> WITH LOGIN SUPERUSER PASSWORD <pass>;

In Dbeaver postgres which uses JDBC, it seems JDBC requires a password too, so using the default postgres which has no password would not connect.

So even if students did not create a new ROLE for <computer-username> and used the default postgres user, they would still fail to connect to dbeaver until a password is added with something like ALTER ROLE postgres WITH PASSWORD 'postgres';

The docker method did not have these complexities because the postgres image required the password and created the required roles as the image started.
`

@GuendouzeAhcene
Copy link

JDBC، يبدو أن JDBC يتطلب كلمة مرور أيضًا، لذا فإن استخدام postgres الافتراضي الذي لا يحتوي على كلمة مرور لن يؤدي إلى الاتصال.

لذلك حتى لو لم ينشئ الطلاب دورًا جديدًا واستخدموا مستخدم postgres الافتراضي، فسيظلون يفشلون في الاتصال بـ dbeaver حتى تتم إضافة كلمة مرور بشيء مثلALTER ROLE postgres WITH PASSWORD 'postgres';

لم تكن طريقة Docker تحتوي على هذه التعقيدات لأن صورة Postgres تتطلب كلمة المرور وتنشئ الأدوار المطلوبة عند بدء تشغيل الصورة

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants