473,503 Members | 5,593 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Odd permission denied message when starting client

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 (ch***@areti.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

Nov 23 '05 #1
2 4182
On Thu, Nov 18, 2004 at 09:27:08PM +0000, Chris Green wrote:
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 (ch***@areti.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

Nov 23 '05 #2
Chris Green <ch***@areti.co.uk> writes:
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

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
2481
by: Russ | last post by:
Hello. My new dev machine is running XP Pro. In the past all equipment has only used Windows 2000. I have had a lot of problems getting my projects up and running on the new machine. The current...
3
2743
by: Chua Wen Ching | last post by:
Hi there, I had applied this security permissions in my class library based on fxcop standards. Before namespace: using System.Runtime.InteropServices; using System.Security.Permissions;
0
1209
by: Jeremy | last post by:
I have an ASP.net application which needs to retreive images from multiple remote machines. It is reterieveing images generated by a web cam service on those machines. All of these machines,...
0
6833
by: phil469 | last post by:
I'm having an issue when trying to read a file in a user's homedir from a cgi script. I have a virtual host section in my httpd.conf file which I'll include. The cgi script is a very basic script...
0
3182
by: debug03 | last post by:
I am executing a DTS package on a Windows 2000 sp4 server running SQL Server 2000 and IBM DB2 V7 client. The DTS package source data(SQL Server) is selected from SQL server table and inserts data to...
0
3384
by: private.anders | last post by:
Hi David! Really need assistance since I have been struggling with a problem long time now. I am running a web application on a Win 2003 Std (Active Directory). Everything works fine. I have...
1
3142
by: private.anders | last post by:
Really need assistance since I have been struggling with a problem long time now. I am running a web application on a Win 2003 Std (Active Directory). Everything works fine. I have installed...
1
7126
by: wo3kie | last post by:
I had not any issues with Windows, but with Linux I failed It is going about an example from boost::asio library tutorial # Daytime.1 - A synchronous TCP daytime client # Daytime.2 - A...
4
2656
by: xzzy | last post by:
I have a v1.1 web app that works on my local computer. However, running it at the host computer, the following breaks: when a viewer selects a different country, the State dropdown should...
0
7188
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7063
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7258
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7313
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7441
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3156
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3146
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
720
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.