Re: permission denied

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: phil campaigne <pcampaigne(at)charter(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: permission denied
Date: 2003-03-20 04:10:20
Message-ID: 20053.1048133420@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

phil campaigne <pcampaigne(at)charter(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Adams (DNS) 2003-03-20 06:26:46 Re: Problems with copy
Previous Message Josh Berkus 2003-03-19 22:30:47 Re: User access