PostgreSQL 9.0 in Ubuntu Linux

#11

On Sun, 14 Aug 2011 06:32:58 +0000, Fredrik Jonson wrote:

Quote:

Did you ask on the
mailinglist mentioned on
http://wiki.postgresql.org/wiki/RPM_Installation>?

No, I didn't. To tell the truth, I toned down my engagement with Postgres
in the recent months.

--
http://mgogala.byethost5.com

#12

gargoyle60 wrote:

Quote:

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

#13

On Mon, 22 Aug 2011 10:51:13 +0200, "Laurenz Albe" <invite (AT) spam (DOT) to.invalid> wrote:

Quote:

Become user postgres

Thanks, I eventually realised that I had to login/become user postgres to successfully chmod, being
root wasn't enough.

#14

gargoyle60 wrote:

Quote:

Become user postgres

Thanks, I eventually realised that I had to login/become user postgres to successfully chmod, being
root wasn't enough.

I don't understand.

Running this chmod command will not fix your problem.

If CREATE TABLESPACE fails with the error you report,
then the command should also fail on the command line.
This should help you find out what is wrong.

Yours,
Laurenz Albe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

PostgreSQL 9.0 in Ubuntu Linux

comp.databases.postgresql comp.databases.postgresql

Re: PostgreSQL 9.0 in Ubuntu Linux - 08-14-2011 , 04:40 PM

Re: PostgreSQL 9.0 in Ubuntu Linux - 08-22-2011 , 03:51 AM

Re: PostgreSQL 9.0 in Ubuntu Linux - 08-22-2011 , 05:06 AM

Re: PostgreSQL 9.0 in Ubuntu Linux - 08-22-2011 , 09:59 AM