Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #212

Re: PostgreSQL 9.0 in Ubuntu Linux

Show all headers | View raw

gargoyle60 wrote:

>>> psql:/home/gary/PostgreSQL/9.0/data/gjd_data/Z_Build_DB_Linux.sql:48:
>>> ERROR:  could not set permissions on directory
>>> "/home/gary/PostgreSQL/9.0/ data/gjd_data/gjd_sentinel_data": Permission
>>> denied ...

>> Therein lies the problem.

> I forgot to show the statment that is causing the problem:
>   CREATE TABLESPACE sentinel_data
>     OWNER sentinel
>     LOCATION E'/home/gary/PostgreSQL/9.0/data/gjd_data/gjd_sentinel_data';
>
> From my directory listing I can see that the permissions for gjd_sentinel_data are drwxrwxrwx with
> owner/group of postgres. On that basis I can't see why there is the problem.
>
> I am wondering if it has something to do with the psql process running as, or owned by, user
> postgres?

That error message is issued when chmod(2) fails.

You can try to do the same thing from the command line to
investigate the cause of the error:

Become user postgres (or the user under which the PostgreSQL
processes tun), then try

chmod 0700 /home/gary/PostgreSQL/9.0/data/gjd_data/gjd_sentinel_data

That should fail.

What do you get for "ls -ld /home/gary/PostgreSQL/9.0/data/gjd_data/gjd_sentinel_data"
when you run it as user postgres?

Yours,
Laurenz Albe 

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

PostgreSQL 9.0 in Ubuntu Linux gargoyle60 <gargoyle60@example.invalid> - 2011-08-12 16:15 +0000
  Re: PostgreSQL 9.0 in Ubuntu Linux Mladen Gogala <no@email.here.invalid> - 2011-08-12 22:06 +0000
    Re: PostgreSQL 9.0 in Ubuntu Linux gargoyle60 <gargoyle60@example.invalid> - 2011-08-13 10:28 +0100
      Re: PostgreSQL 9.0 in Ubuntu Linux "Laurenz Albe" <invite@spam.to.invalid> - 2011-08-22 10:51 +0200
        Re: PostgreSQL 9.0 in Ubuntu Linux gargoyle60 <gargoyle60@example.invalid> - 2011-08-22 11:06 +0100
          Re: PostgreSQL 9.0 in Ubuntu Linux "Laurenz Albe" <invite@spam.to.invalid> - 2011-08-22 16:59 +0200
  Re: PostgreSQL 9.0 in Ubuntu Linux Fredrik Jonson <fredrik@jonson.org> - 2011-08-13 11:07 +0000
    Re: PostgreSQL 9.0 in Ubuntu Linux gargoyle60 <gargoyle60@example.invalid> - 2011-08-13 12:20 +0100
      Re: PostgreSQL 9.0 in Ubuntu Linux Fredrik Jonson <fredrik@jonson.org> - 2011-08-13 11:33 +0000
    Re: PostgreSQL 9.0 in Ubuntu Linux Fredrik Jonson <fredrik@jonson.org> - 2011-08-13 11:21 +0000
      Re: PostgreSQL 9.0 in Ubuntu Linux gargoyle60 <gargoyle60@example.invalid> - 2011-08-13 12:28 +0100
    Re: PostgreSQL 9.0 in Ubuntu Linux Mladen Gogala <gogala.mladen@gmail.com> - 2011-08-13 15:54 +0000
      Re: PostgreSQL 9.0 in Ubuntu Linux Fredrik Jonson <fredrik@jonson.org> - 2011-08-14 06:32 +0000
        Re: PostgreSQL 9.0 in Ubuntu Linux Mladen Gogala <gogala.mladen@gmail.com> - 2011-08-14 21:40 +0000

csiph-web