Re: BUG #2776: unable to access created user directory

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, Nov 22, 2006 at 10:56:16AM +0000, Raghava wrote:
>
> 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,
>
[...]
> 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 is supposed to work like that. It has nothing to do with
Postgresql, but with your Unix installation. It seems that by default on
your box one user is not allowed to read another user's home folder
(btw. we Unixers call that "directory"). This makes some sense.

> This iam able to resolve
> by executing the command chmod -R 777 /home/raghav.

Wow. So anyone could remove all files in /home/raghav now. Do you want
that?

> 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?

An installation script shold run as user postgres. The schema should be
part of the installation script and be readable by postgres.

If you have more questions we can continue off-list

regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFZ9rSBcgs9XrR2kYRAp4dAJ9goEqmx8f7wXWZ3JEPzVCAV9VWHACfV+GC
XQylmdsHc0+no0Wi2DoOGJs=
=Afea
-----END PGP SIGNATURE-----