On 7/11/2014 11:37 PM, Roelof Wobben wrote:
First I see this error ; role "roelof" does not exist.
I solved it by doing : sudo -u postgres createuser roelof
but now when I make the database by doing rake db:create I see this
error ;
PG::InsufficientPrivilege: ERROR: permission denied to cre
Hello,
I try to use postgresql with Ruby on Rails.
First I see this error ; role "roelof" does not exist.
I solved it by doing : sudo -u postgres createuser roelof
but now when I make the database by doing rake db:create I see this error ;
PG::InsufficientPrivilege: ERROR: permission denied
On Tue, 27 May 2008, Tom Lane <[EMAIL PROTECTED]> writes:
> I applied a docs patch for this, though not exactly what you sent in.
A lot better. Thanks for your interest. Let's see if I'll ask same
question next year.
Regards.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
[EMAIL PROTECTED] (Volkan =?utf-8?B?WWF6xLFjxLE=?=) writes:
> On Tue, 27 May 2008, Tom Lane <[EMAIL PROTECTED]> writes:
>> Well, you tested wrong then. It works as expected for me, which is
>> that you need SELECT if the query involves fetching any existing
>> column value:
> Pff... Sorry for the
On Tue, 27 May 2008, Tom Lane <[EMAIL PROTECTED]> writes:
> Well, you tested wrong then. It works as expected for me, which is
> that you need SELECT if the query involves fetching any existing
> column value:
Pff... Sorry for the noise. (I created example table under a differrent
schema than "pu
[EMAIL PROTECTED] (Volkan =?utf-8?B?WWF6xLFjxLE=?=) writes:
> On Tue, 27 May 2008, Tom Lane <[EMAIL PROTECTED]> writes:
>> You don't have SELECT privilege, which is required to read any of the
>> columns in the WHERE clause.
> As far as I tested, even
> DELETE FROM foo;
> UPDATE foo SET bar =
Hi,
I rarely use GRANT -- nearly once every 1-2 year -- and everytime I
forget this small detail: DELETE/INSERT/UPDATE privileges require SELECT
privilege also.
On Tue, 27 May 2008, Tom Lane <[EMAIL PROTECTED]> writes:
> You don't have SELECT privilege, which is required to read any of the
> colu
Hi,
We are running a web application based on ColdFusion 7 and PostgreSQL 8 on 2
Windows 2003 servers.
On server 1 (ColdFusion side) a query uses the lo_export function to get a
blob out of the database on server 2. This blob must be written to disk but
since the postgres user is only known on se
Ron Johnson <[EMAIL PROTECTED]> writes:
> ~$ touch /data/02/share/database/testing.testing
> ~$ dir /data/02/share/database
> total 8
> drwxrwxr-x 2 me postgres 4096 2006-10-16 21:53 ./
> drwxrwxr-x 16 me people 4096 2006-10-16 21:38 ../
> -rw-r--r-- 1 me me 0 2006-10-16 21:53 testing.
On 10/17/06, Leonel Nunez <[EMAIL PROTECTED]> wrote:
Correction to my prior mail
do this as root :
chcon system_u:object_r:postgresql_db_t /opt/home/pgdata/mspace
When you need to know what config has any directory for SELinux
do a:
ls -lZ /your/dir
and if you need /your/otherdir t
On 10/16/06 20:17, Douglas McNaught wrote:
> "Andras Simon" <[EMAIL PROTECTED]> writes:
>
>> I'm trying to create a new tablespace in a directory that postgres
>> owns, but PG says it cannot set permissions on this directory.
>
> ...
>
>> This is on Fedora Core 5 (x86), psql 8.1.4.
>
> SELinux
On 10/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
To use a nondefault tablespace, you'd want to tweak the policy to allow
postgres to write that directory tree too. I'm afraid I know too little
about selinux to explain exactly what to do though ... need to learn
that someday ...
Me too...
A
On 10/17/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
...
> This is on Fedora Core 5 (x86), psql 8.1.4.
SELinu
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
> ...
> This is on Fedora Core 5 (x86), psql 8.1.4.
Do you have selinux enabled? The default selinux policy disallows t
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
>
> [EMAIL PROTECTED] ~]# su - postgres
> -bash-3.1$ mkdir /opt/home/pgdata/mspace/
> -bash-3.1$ psql
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
"Andras Simon" <[EMAIL PROTECTED]> writes:
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
...
> This is on Fedora Core 5 (x86), psql 8.1.4.
SELinux, most likely.
-Doug
---(end of br
I'm trying to create a new tablespace in a directory that postgres
owns, but PG says it cannot set permissions on this directory.
[EMAIL PROTECTED] ~]# su - postgres
-bash-3.1$ mkdir /opt/home/pgdata/mspace/
-bash-3.1$ psql
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \cop
Dilan A wrote:
When I started the postgres service and tried connecting using PgAdmin
III I got the following error:
An Error has occurred. FATAL: could not open relation 16627/16628/2701:
Permission Denied.
Any ideas on how this can be fixed.
First step is to check the permissions on all yo
Hi, I have done some RTFMing and come up with little on this one.
I have a database that I had setup in the past that I haven't opened for
a while created under 8.1 running the native Win32 port.
When I started the postgres service and tried connecting using PgAdmin
III I got the following e
Hi,
Each time I try to insert an ascii file with the
COPY FROM command, I get the following message:
"ERROR: COPY command, running in
backend with effective uid 501 (that's Postgres), could not open file
'/usr/local/.../cltclr001' for reading. Error: Permission not allowed
(13)."
Wha
20 matches
Mail list logo
