dbTalk Databases Forums  

Odd permission denied message when starting client

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Odd permission denied message when starting client in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Green
 
Posts: n/a

Default Odd permission denied message when starting client - 11-18-2004 , 03:27 PM






I have just installed Postgresql 7.3.4 on my slackware 9.1 system.
The installation went fairly smoothly and the server process has
started normally:-

postgres 21027 20767 0 20:12 pts/5 00:00:00 -su
postgres 21246 1 0 20:17 pts/3 00:00:00 /usr/bin/postmaster -D /var/lib/postgresql/data
postgres 21248 21246 0 20:17 pts/3 00:00:00 postgres: stats buffer process
postgres 21251 21248 0 20:17 pts/3 00:00:00 postgres: stats collector process


However when I try and run a postgres client process as an ordinary
user I get the following:-

FATAL: could not open configuration file "postgresql.conf": Permission denied

As I understand it the permissions on the postgresql data directory
should be 0700 and owned by the postgresql user and this is how they
are set. So what permission(s) is this error complaining about?

--
Chris Green (chris (AT) areti (DOT) co.uk)

"Never ascribe to malice, that which can be explained by incompetence."

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match


Reply With Quote
  #2  
Old   
Chris Green
 
Posts: n/a

Default Re: Odd permission denied message when starting client - 11-18-2004 , 03:33 PM






On Thu, Nov 18, 2004 at 09:27:08PM +0000, Chris Green wrote:
Quote:
I have just installed Postgresql 7.3.4 on my slackware 9.1 system.
The installation went fairly smoothly and the server process has
started normally:-

postgres 21027 20767 0 20:12 pts/5 00:00:00 -su
postgres 21246 1 0 20:17 pts/3 00:00:00 /usr/bin/postmaster -D /var/lib/postgresql/data
postgres 21248 21246 0 20:17 pts/3 00:00:00 postgres: stats buffer process
postgres 21251 21248 0 20:17 pts/3 00:00:00 postgres: stats collector process


However when I try and run a postgres client process as an ordinary
user I get the following:-

FATAL: could not open configuration file "postgresql.conf": Permission denied

As I understand it the permissions on the postgresql data directory
should be 0700 and owned by the postgresql user and this is how they
are set. So what permission(s) is this error complaining about?

Who is being stupid then! Me!!!! :-)

The 'postgres' command is trying to run the server, oops.


I'll go away again and shut up for the moment.

--
Chris Green (chris (AT) areti (DOT) co.uk)

"Never ascribe to malice, that which can be explained by incompetence."

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
  #3  
Old   
Tom Lane
 
Posts: n/a

Default Re: Odd permission denied message when starting client - 11-18-2004 , 03:48 PM



Chris Green <chris (AT) areti (DOT) co.uk> writes:
Quote:
However when I try and run a postgres client process as an ordinary
user I get the following:-

FATAL: could not open configuration file "postgresql.conf": Permission denied
You don't run "postgres" as an ordinary user. You want a client
application, such as "psql".

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.