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 permission error #18

Open
CameronNemo opened this issue Feb 27, 2021 · 0 comments · May be fixed by #19
Open

postgres permission error #18

CameronNemo opened this issue Feb 27, 2021 · 0 comments · May be fixed by #19

Comments

@CameronNemo
Copy link

Spun up perfsonar/testpoint image

Cores started spinning, the pscheduler daemons were falling over and being restarted continuously.

Noticed postgresql was not working

Tried to run pg manually using the command in the supervisord configuration

Received a permission error

Checked permissions for /var/lib/pgsql/10/data and parent dirs, noticed /var/lib/pgsql was owned by root/root and had mode 0700

Ran chmod 0755 /var/lib/pgsql

Tried to run pg manually... success!

pscheduler daemons started up cleanly, load reduced

CameronNemo pushed a commit to CameronNemo/perfsonar-testpoint-docker that referenced this issue Mar 3, 2021
This directory had owner/group of root/root with a 0700 mode.
Change the mode to 0755 so that postgresql can still read the subdirs.
Note that the subdirs are still 0700 (with owner of postgres),
so this should not expose any data.

Fixes perfsonar#18
@CameronNemo CameronNemo linked a pull request Mar 3, 2021 that will close this issue
@github-project-automation github-project-automation bot moved this to Ready in perfSONAR May 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Ready
Development

Successfully merging a pull request may close this issue.

1 participant