From: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Possible Bug - error creating a tablespace |
Date: | 2009-09-23 21:14:08 |
Message-ID: | 200909231514.08129.kevink@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
So I think I *may* have found a bug but I want to be sure before I file a bug.
I did a search on the pgsql-bugs list using the search text:
cannot create tablespace
and got nothing back.
Here's the scenario:
1) we installed CentOS 5.3 x86_64 on a 64bit Dell server
2) I installed the pgdg_centos-8.3-6.noarch rpm in order to enable the 8.3.x
repo.
3) I used yum to install postgres and friends
4) Here's the weird part:
-- If I start the cluster via "sudo /etc/init.d/postgres start" and then try
and create a tablespace it fails with :
create tablespace benchmark2 location '/eq5/pwbbench';
ERROR: could not set permissions on directory "/eq5/pwbbench": Permission
denied
-- however if I start the db as user postgres with:
pg_ctl -D /var/lib/pgsql/data start
and then create the tablespace it works.
Likewise if I create the tablespace after starting the cluster via pg_ctl and
then subsequently restart the db via 'sudo /etc/init.d/postgres start' I get
errors trying to insert data into the previously created tablespace but if I
start the cluster with pg_ctl (as user postgres) then I can also add data to
the tablespace.
I see that in the /etc/init.d/postgres file the start command is running the
postmaster (not pg_ctl) as user postgres.
So, based on the above I suspect Its a bug but I wanted to be sure.
Thoughts?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-23 21:30:03 | Re: Possible Bug - error creating a tablespace |
Previous Message | Scott Marlowe | 2009-09-23 20:58:43 | Re: Looking for way to replicate master db to multiple mobile databases |