[SOLVED] Which privilege to add to user

Huamin · 07-11-2014, 11:37 PM

Hi,
It means huamin user below, is not able to access the folder,

[huamin@CentOS65x64 ~]$ cd /var/lib/pgsql/data/
bash: cd: /var/lib/pgsql/data/: Permission denied
[huamin@CentOS65x64 ~]$ su
Password:
[root@CentOS65x64 huamin]# cd /var/lib/pgsql/data/
[root@CentOS65x64 data]#

then which privileges should be added to "huamin"?

unSpawn · 07-12-2014, 06:53 AM

The 'su' command has a manual page. Please read 'man su', configure, test and then ask.

jefro · 07-12-2014, 03:24 PM

command ls -l should show the user, owner and group. chmod would allow the user to access the files or folders.

sundialsvcs · 07-13-2014, 04:32 PM

For postgres SQL data, you probably do not want to assign permissions to anyone beyond those that the Postgres configuration already uses!

STOP and read the Postgres documentation ... thoroughly. Do not do anything further, until you have done so.

Huamin · 07-13-2014, 11:00 PM

Jefro,
"pqsql" is now having this

drwx----w-. 4 postgres postgres 4096 Jul 11 17:36 pgsql

what privilege should be added to the user, to be able to access this folder?

astrogeek · 07-13-2014, 11:14 PM

Quote:

Originally Posted by Huamin

Jefro,
"pqsql" is now having this

drwx----w-. 4 postgres postgres 4096 Jul 11 17:36 pgsql

what privilege should be added to the user, to be able to access this folder?

Those permissions must be

Code:

drwx------ postgres postgres

You should NEVER grant any other user permission to access that directory!

Postgresql will refuse to start if you change those permissions!

Why would you want huamin user to access that directory?

Huamin · 07-14-2014, 03:15 AM

why I want to adjust the privilege to the user on the folder, is due to that I encounter this problem below, to start Postgresql.

[huamin@CentOS65x64 ~]$ postgres -D /usr/local/pgsql/data
postgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directory

what to adjust then?

yancek · 07-14-2014, 09:11 AM

Quote:

postgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directory

That is not a permissions issue. In your initial post you tried to access a file as a normal user and were denied. You then were able to access as root without a permission denied. Other members have explained that you should use postgres user to access. The error above is telling you that particular file does not exist which is another issue. I'm not familiar with postgres but someone should be along to give you some advice.

astrogeek · 07-14-2014, 04:50 PM

Quote:

Originally Posted by Huamin

why I want to adjust the privilege to the user on the folder, is due to that I encounter this problem below, to start Postgresql.

[huamin@CentOS65x64 ~]$ postgres -D /usr/local/pgsql/data
postgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directory

what to adjust then?

That is a whole different problem/question from that in your original post.

I suspect that you have never initialized postgresql at all - hence no configuration or data files...

See man {postgres,initdb} for how to initialize and start your version of postgresql properly.

But I would stress once more, if you have changed directory permissions along that path, postgresql will refuse to start and write something like the following to the postgres log file:

Code:

FATAL:  data directory "/var/lib/pgsql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).