From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Venkateswara Rao Bondada <Venkateswara_B(at)infosys(dot)com> |
Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Create table command fails with permission denied |
Date: | 2009-08-05 01:16:02 |
Message-ID: | 25959.1249434962@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Venkateswara Rao Bondada <Venkateswara_B(at)infosys(dot)com> writes:
> camd=# \c cms postgres
> You are now connected to database "cms" as user "postgres".
> cms=# create table test(id character varying(80));
> ERROR: could not create relation "test": Permission denied
Actually, what that is complaining about is that the operating system
refused its attempt to create a filesystem file to hold the table.
It's got nothing to do with permissions inside the database --- there
is something wrong with the filesystem permissions of the data
directory. Or maybe you started the postmaster as the wrong user
(not the one that owns the data directory).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Klas Stockhem | 2009-08-05 09:56:35 | Re: Problems when copy data from dump file |
Previous Message | Rob Sargent | 2009-08-04 16:32:13 | Re: Create table command fails with permission denied |