Postgres Tablespace Error Could Not Set Permissions On Directory
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss postgres create tablespace permission denied windows the workings and policies of this site About Us Learn more
Could Not Set Permissions On Directory Postgres Windows
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Could Not Set Permissions On Directory "": Permission Denied
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping
Error: Could Not Set Permissions On Directory : Operation Not Permitted
each other. Join them; it only takes a minute: Sign up PostgreSQL create tablespace no permission up vote 1 down vote favorite I've got a problem when I create tablespace for PostgreSQL. The following are the steps: mkdir /postgres chown postgres.postgres /postgres su - postgres psql create tablespace p1 location '/postgres' In this step I got a error: how to create a tablespace in postgresql could not set permissions on directory "/postgres": Permission denied The directory ownership is correct: [root@dev ~]# ls -la /postgres 总用量 8 drwxr-xr-x. 2 postgres postgres 4096 12月 2 13:17 . dr-xr-xr-x. 28 root root 4096 12月 3 06:57 .. the user is postgres [root@dev contrib]# ps -ef|grep postgres postgres 1971 1 0 08:21 ? 00:00:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data I'm running on CentOS. fix: setenforce 0 database postgresql share|improve this question edited Dec 3 '13 at 6:51 asked Dec 2 '13 at 6:50 9ban 816 Could you paste the output of ls -la /postgres? –Milen A. Radev Dec 2 '13 at 9:36 thank you for help [root@dev data]# ls -la /postgres 总用量 8 drwxr-xr-x. 2 postgres postgres 4096 12月 2 13:17 . dr-xr-xr-x. 28 root root 4096 12月 2 13:17 .. –9ban Dec 2 '13 at 11:17 Please append the listing to the question - right now it's illegible. –Milen A. Radev Dec 2 '13 at 13:37 ls -dZ /postgresql, ls -dZ /var&
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites postgres tablespace permissions Propaganda Resources Weekly News Re: CANNOT CREATE A TABLESPACE From: Charles Simard postgres list tablespaces To: 'JORGE MALDONADO' Cc: pgsql-novice(at)postgresql(dot)org Subject: Re: CANNOT CREATE A TABLESPACE Date: 2008-07-24 17:14:41 Message-ID: E6AE5AD88D55B543A0A97FF0B93AA9E9621F7A@TRADE200.DENARIUS.CA (view create table postgres raw or whole thread) Thread: 2008-07-24 17:06:57 from "JORGE MALDONADO" 2008-07-24 17:14:41 from Charles Simard Lists: pgsql-novice |> -----Original Message----- |> From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of JORGE MALDONADO http://stackoverflow.com/questions/20322397/postgresql-create-tablespace-no-permission |> Sent: 24 juillet 2008 13:07 |> To: pgsql-novice(at)postgresql(dot)org |> Subject: [NOVICE] CANNOT CREATE A TABLESPACE |> |> I am trying to create a new Tablespace without success. I am using PostgreSQL 8.3 and pgAdmin III v1.8.2 in a Windows XP |> Professional environment with the following steps: |> |> 1. I create an empty directory called c:\pgppdata using Windows https://www.postgresql.org/message-id/E6AE5AD88D55B543A0A97FF0B93AA9E9621F7A@TRADE200.DENARIUS.CA Explorer. |> 2. I right click on Tablespaces in pgAdmin III interface and select New Tablespace |> 3. I give it the name e_restdelivery |> 4. In location I type c:\pgappdata (the directory created in step 1) |> 5. In owner I select postgres and click the OK button. |> 6. I get a message saying *** ERROR: could not set permissions on directory "c:/pgappdata": Permissiond denied *** |> |> Note that the slash in the message is not the same I use in step 1; I have used both in the first step with the same result. |> |> Please advice. |> |> With respect, |> Jorge Maldonado Give appropriate permissions to your Windows postgres user on your pgppdata directory. Regards, Charles Simard In response to CANNOT CREATE A TABLESPACE at 2008-07-24 17:06:57 from JORGE MALDONADO pgsql-novice by date Next:From: Daniel GourDate: 2008-07-29 13:20:21 Subject: How to copy a schema under another name in same database Previous:From: JORGE MALDONADODate: 2008-07-24 17:06:57 Subject: CANNOT CREATE A TABLESPACE Privacy Policy | About PostgreSQL Copyright © 1996-2016 The PostgreSQL Global Development Group
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists https://www.postgresql.org/message-id/9189.1208619241@sss.pgh.pa.us Regional lists Associations User groups Project lists Inactive lists https://www.redhat.com/archives/rhelv5-list/2008-April/msg00213.html IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News Re: Could not create a tablespace - permission denied From: Tom Lane To: Graham Leggett Cc: pgsql-admin(at)postgresql(dot)org Subject: Re: Could not could not create a tablespace - permission denied Date: 2008-04-19 15:34:01 Message-ID: 9189.1208619241@sss.pgh.pa.us (view raw or whole thread) Thread: 2008-04-19 12:58:35 from Graham Leggett 2008-04-19 15:34:01 from Tom Lane 2008-04-19 15:42:45 from Graham Leggett 2008-04-19 15:50:29 from Tom Lane 2008-04-19 16:08:43 could not set from Graham Leggett 2008-04-19 16:14:13 from "Joshua D(dot) Drake" 2008-04-19 18:21:17 from Graham Leggett 2008-04-19 18:51:53 from "Joshua D(dot) Drake" 2008-04-19 21:11:02 from Tom Lane 2008-04-19 16:17:31 from Tom Lane Lists: pgsql-admin Graham Leggett writes: > While attempting to create a tablespace as the postgres user under RHEL5 > with *no* SELinux enabled, I get the following error: > postgres=# CREATE TABLESPACE fma LOCATION '/home/chandler/fma/db/pgsql'; > ERROR: could not set permissions on directory > "/home/chandler/fma/db/pgsql": Permission denied > The user postgres is able to access the directory, and the user postgres > is able to set permissions on the directory to 0700: > -bash-3.1$ chmod 700 /home/chandler/fma/db/pgsql If you can do that from a shell running as postgres, then I think seli
5 (Tikanga) discussion mailing-list" Subject: Re: [rhelv5-list] Postgresql: Could not create a tablespace - permission denied Date: Sat, 19 Apr 2008 09:12:54 -0500 Graham Leggett wrote: Hi all, While attempting to create a postgresql tablespace as the postgres user under RHEL5 with *no* SELinux enabled, I get the following error: postgres=# CREATE TABLESPACE fma LOCATION '/home/chandler/fma/db/pgsql'; ERROR: could not set permissions on directory "/home/chandler/fma/db/pgsql": Permission denied The user postgres is able to access the directory, and the user postgres is able to set permissions on the directory to 0700: -bash-3.1$ chmod 700 /home/chandler/fma/db/pgsql -bash-3.1$ When I first encountered this problem, the only solution I could find was to blow away postgres and reinstall the databases from scratch. Now that one database is live, this is no longer an option. Does anyone know for sure whether postgres tablespaces are known to work at all on the RHEL5 platform? Regards, Graham -- I'd check that the user postgresql is running as can create files in /home/chandler/fma/db/pgsql # assuming postgres is the user su - postgres touch /home/chandler/fma/db/pgsql/foo rm /home/chandler/fma/db/pgsql/foo Hugh Follow-Ups: Re: [rhelv5-list] Postgresql: Could not create a tablespace - permission denied From: Graham Leggett References: [rhelv5-list] Postgresql: Could not create a tablespace - permission denied From: Graham Leggett [Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]