Postgres Pro
Downloads
Home   >   mailing lists

Thread: Permission Denied

Permission Denied

From
"pcampaigne"
Date:
I'm using jdbc to connect tomcat to postgresql.  I get "permission denied"
when my application tries to acces the database files.
  "/usr/local/pgsql/data/global/1262"
I think I need to change the linux directory permission, but to who?
...postgres
         ...the database user
1. Which one? Should directory permission match the database username and password in the jdbc connection code?
2. Do I set permissions using chown and chgrp?
3. Set permission for just 1262 or all in the global directory? or of the path?

thanks,
Phil

Re: Permission Denied

From
"Marcus Andree S. Magalhaes"
Date:
I'm having problems with Postgres and JDBC. When connecting from root, using
JDBC,
the user can't authenticate against the database. But, when running a norma.
user, everything works flawlessly... The PATH and CLASSPATH environment
variables are exactly the same... Any ideas??

Thanks

Quoting pcampaigne <pcampaigne@charter.net>:

> I'm using jdbc to connect tomcat to postgresql.  I get "permission denied"
> when my application tries to acces the database files.
>   "/usr/local/pgsql/data/global/1262"
> I think I need to change the linux directory permission, but to who?
> ...postgres
>          ...the database user
> 1. Which one? Should directory permission match the database username and
> password in the jdbc connection code?
> 2. Do I set permissions using chown and chgrp?
> 3. Set permission for just 1262 or all in the global directory? or of the
> path?
>
> thanks,
> Phil
>
>




-------------------------------
   http://www.vlinfo.com.br