Skip site navigation (1) Skip section navigation (2)

BUG #2776: unable to access created user directory

From: "Raghava" <kraghavaiah(at)velankani(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2776: unable to access created user directory
Date: 2006-11-22 10:56:16
Message-ID: 200611221056.kAMAuGxY075172@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2776
Logged by:          Raghava
Email address:      kraghavaiah(at)velankani(dot)com
PostgreSQL version: 8.1.4
Operating system:   RHEL
Description:        unable to access created user directory
Details: 

hi,

 We have uninstalled postgres-7.1.4 and successfully installed
postgres-8.1.4. After installtion we have created database with name
"finaldb" and with postgres user. I wanted to give a schema file (schema.sql
) file as input for this finaldb. Here are the steps iam doing and
schema.sql is in home directory.

su postgres
bash-3.00$  psql  finaldb
finaldb=# \i /home/schema.sql
 
with this installtion of schema is working fine. But if i place the
schema.sql in created user directory

i.e useradd raghav
directory raghav get's created under home floder. If i place schema.sql
/home/raghav folder and execute the following commands

su postgres
bash-3.00$  psql  finaldb
finaldb=# \i /home/raghav/schema.sql

with the iam getting "directory cannot be access". This iam able to resolve
by executing the command chmod -R 777 /home/raghav.

But i have to handle this kind of issue through installtion script. Can u
please suggest where are we are missing the configuration for postgres?

Regards,
Raghava

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-11-22 14:59:34
Subject: Re: A bug or documentation error?
Previous:From: Mas KusDate: 2006-11-22 08:40:53
Subject: BUG #2775: Error select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group