Re: permission denied - Mailing list pgsql-novice

From Tom Lane
Subject Re: permission denied
Date
Msg-id 20053.1048133420@sss.pgh.pa.us
Whole thread Raw
In response to permission denied  (phil campaigne <pcampaigne@charter.net>)
List pgsql-novice
phil campaigne <pcampaigne@charter.net> writes:
> I'm using jdbc to connect tomcat to postgresql.  I a permission denied
> when my application tries to acces the database files.
>   "/usr/local/pgsql/data/global/1262"
> I am trying to change the linux directory's permission, but to who?
>     ...postgres
>          ...the database user

/usr/local/pgsql/data/ and everything under it must be owned by the
postgres user (ie, the one the postmaster runs as).  I'd bet that either
you ran initdb as the wrong user, or you've started the postmaster as
the wrong user.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: User access
Next
From: "Duncan Adams (DNS)"
Date:
Subject: Re: Problems with copy