Drake wrote: > >> I am pretty sure you are missing something. The default selinux policy disallows the postgres daemon from writing anywhere outside the standard /var/lib/pgsql/data directory tree. Yes, I'd like to avoid that if at all possible. vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. http://gsbook.org/could-not/postgres-error-could-not-set-permissions-on-directory.php
Does anyone know for sure whether postgres tablespaces are known to work at all on the RHEL5 platform? regards, tom lane -- Sent via pgsql-admin mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ‹ Previous Thread Next Thread › « Return to PostgreSQL - admin | Hot Network Questions Is three knights versus knight really winning? I am pretty sure you are missing something. http://stackoverflow.com/questions/5208094/creating-a-tablespace-in-postgresql
Free forum by Nabble Edit this page Backpacker // Photographer // Programmer // Gamer // MenuMy Application Stack MyBatis Tutorials Memorable Quotes Archieves About Fixing Postgresql Error, "initdb: could not change Check for "avc denied" messages in the kernel log to verify this. Word for fake religious people Why doesn't my iphone 6s plus charge while it is on the cable? Or that I am running as the wrong user?
In my case, it is *not* SELinux, since I'm not running it... Who were the red-robed citizens of Jedha City? Dual boot with Windows XP Home Adv Reply August 18th, 2011 #2 gargoyle60 View Profile View Forum Posts Private Message 5 Cups of Ubuntu Join Date Jun 2009 Location Kent, How To Create A Tablespace In Postgresql In addition, if SELinux is enabled, this gives a further reason why the code will fail.
Adv Reply Quick Navigation General Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums The Ubuntu Forum Community Ubuntu Official Flavours Support New to Could Not Set Permissions On Directory Postgres Windows I've been trying to reference a '/media/username/drive_name/pg_data' directory, whose permissions are set with a similar chown command and parent directory whose permissions are set to 700 (with a separate user). Note You need to log in before you can comment on or make changes to this bug. https://www.postgresql.org/message-id/legacy/pgsql-bugs/2008-04/msg00132.php Would presence of MANPADS ground the entire airline industry?
Andras ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [hidden email] so that your message can get Postgres Tablespace Location regards, tom lane -- Sent via pgsql-admin mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin Graham Leggett Reply | Threaded Open this post in threaded view ♦ ♦ Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Too many advisors How much effort (and why) should consumers put into protecting their credit card numbers?
A quick and dirty solution is to put selinux into non-enforcing mode, but if this machine is exposed to the internet at all, that's probably not a good answer. Redhat Enterprise Linux 5 refuses to allow a user to chmod a directory, even though that user owns that directory. Postgres Create Tablespace Permission Denied Windows Google+ database postgresql util utility edwin Related Posts Error on Swagger 2 using Springfox - Request processing failed; nested exception is java.lang.IndexOutOfBoundsException: Index: 1 [MySQL Error] Got a packet bigger than Error: Could Not Set Permissions On Directory Operation Not Permitted regards, tom lane -- Sent via pgsql-admin mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin Graham Leggett Reply | Threaded Open this post in threaded view ♦ ♦
Type: \copyright for distribution terms \h for help with SQL commands \? Check This Out When postgresql is started, is actually launches a new shell as the user and the fact that they are part of the group is picked up. quotes shown here for emphasis only, not entered to the installer) Beforehand I manually created a data directory structure to isolate my personal data files (as myself, not using sudo): Code: Any ideas what I could be doing wrong? Postgres Tablespace Permissions
Similarly with chgrp. Drake Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Could not create a tablespace - permission denied Graham Leggett Regards, Graham -- Responses Re: Could not create a tablespace - permission denied at 2008-04-19 15:34:01 from Tom Lane pgsql-admin by date Next:From: Tom LaneDate: 2008-04-19 15:34:01 Subject: Re: Could not http://gsbook.org/could-not/postgres-tablespace-error-could-not-set-permissions-on-directory.php Format For Printing -XML -Clone This Bug -Top of page First Last Prev Next This bug is not in your last search results.
This script file is called "Z_Build_DB_Linux.sql" I am trying to run psql in batch mode as follows (long command, line wrapped here): Code: /opt/PostgreSQL/9.0/bin/psql --dbname postgres --host localhost --port 5432 --username Postgres Change Tablespace asked 5 years ago viewed 12992 times active 1 year ago Related 970PostgreSQL “DESCRIBE TABLE”13How can I tell what is in a Postgresql tablespace?3Tablespaces used to create a materialized view?0why I I'm afraid I know too little about selinux to explain exactly what to do though ...
To try it, I have to wait for the next reboot, because in order to get moving, I checked SELinux > Modify SELinux Policy > SELinux Service Protection > Disable SELinux In fact, NFS has enough weirdnesses that I wouldn't recommend running a database over it ... Free forum by Nabble Edit this page PostgreSQL › PostgreSQL - admin Search everywhere only in this topic Advanced Search Could not create a tablespace - permission denied ‹ Previous Topic Postgresql Create Table If Not Exists Regards, Graham -- smime.p7s (4K) Download Attachment Tom Lane-2 Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Could not
For info: abandoned the previous approach in favour of... The female equivalent of "don't break my balls" GameObject with Audio File called with FindGameObjectWithTag returns "Object reference not set to an instance of an object" Why is credit card information Regards, Graham -- smime.p7s (4K) Download Attachment Tom Lane-2 Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Could not http://gsbook.org/could-not/postgres-create-tablespace-could-not-set-permissions-on-directory.php Joshua D.
I can not reproduce your issue: [email protected]:~$ mkdir /tmp/foo [email protected]:~$ psql -U postgres postgres=# \h create tablespace Command: CREATE TABLESPACE Description: define a new tablespace Syntax: CREATE TABLESPACE tablespacename Just make a test program that chmod's, sleeps awhile, and chmod's again, and manually change the permissions while it's sleeping, in the same way that you did in the problem case. http://archives.postgresql.org/ Tom Lane-2 Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Aother tablespace permission issue (was Re: [GENERAL] Permission After several hours trying, i found out that the workaround is actually simple.
To fix this, check that the mode is 0700, don't try to set it. Is scroll within a card good or bad? (In desktop) Were Palpatine or Vader ever congratulatory or nice to any of their subordinates? there is no "cacheing of credentials" in there that I know about. What the code should be doing is testing that the permissions are 0700, and throwing an error if this is not the case.