Comment 2 Graham Leggett 2008-04-19 11:32:57 EDT As it turned out, the postgresql server had cached permission credentials, so while the postgres user could see the directory without a problem, this There might be hints in dmesg, or in CentOS's SELinux helper tool, to tell you specific SELinux booleans you can turn on or off to control this. dr-xr-xr-x. 28 root root 4096 12月 3 06:57 .. Ordinary file permissions are applied uniformly to all processes running as a given userid, but selinux is different. weblink
How Aggregate Result are count against the Governor Limits? If this 01285 * fails, it doesn't exist or has the wrong owner. 01286 */ 01287 if (chmod(location, 0700) != 0) 01288 ereport(ERROR, 01289 (errcode_for_file_access(), 01290 errmsg("could not set permissions on Turn off the targeted SELinux policy for PostgreSQL, or relabel the /postgresql/ mount point correctly as system_u:object_r:postgresql_db_t:s0 so Pg is allowed to access it. –Craig Ringer Dec 3 '13 at 7:01 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 http://stackoverflow.com/questions/5208094/creating-a-tablespace-in-postgresql
However, that "common sense" is obviously wrong. ~$ dir /data/02/share | grep datab drwxrwxr-x 2 me postgres 4096 2006-10-16 21:38 database/ ~$ touch /data/02/share/database/testing.testing ~$ dir /data/02/share/database total 8 Your home directory is probably setup so that only your user has access (i.e chmod 700) to it (it's a good thing for your home directory to be chmod 700, don't 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
The command I'm using is: CREATE TABLESPACE magdat OWNER maggie LOCATION '/home/john/BSTablespace' I get the error: ERROR: could not set permissions on directory "/home/john/BSTablespace": Operation not permitted The folder belongs to Doing something like: mkdir /BSTablespace chown postgres:postgres /BSTablespace and then CREATE TABLESPACE magdat OWNER maggie LOCATION '/BSTablespace'; should work fine. Make sure the directory is owned by that user. Postgres Tablespace Permissions Redhat Enterprise Linux 5 refuses to allow a user to chmod a directory, even though that user owns that directory.
http://www.postgresql.org/docs/faq Ron Johnson Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Aother tablespace permission issue (was Re: [GENERAL] Permission problem Could Not Set Permissions On Directory Postgres Windows Now that one database is live, this is no longer an option. Browse other questions tagged database postgresql or ask your own question. https://www.postgresql.org/message-id/[email protected] Radev Dec 2 '13 at 9:36 thank you for help [[email protected] data]# ls -la /postgres 总用量 8 drwxr-xr-x. 2 postgres postgres 4096 12月 2 13:17 .
Do you have selinux enabled? Postgres List Tablespaces ps -ef | grep postgres or ps aux|grep postgres should show you what user the server is running as. Join them; it only takes a minute: Sign up Creating a tablespace in postgresql up vote 6 down vote favorite 3 I'm trying to create a tablespace in postgres, but I'm Any help appreciated. -- Ron Johnson, Jr.
Dividing with/without using floats in C Does the code terminate? https://www.postgresql.org/message-id/legacy/pgsql-bugs/2008-04/msg00132.php Drake In response to Re: Could not create a tablespace - permission denied at 2008-04-19 16:08:43 from Graham Leggett Responses Re: Could not create a tablespace - permission denied at 2008-04-19 Postgres Create Tablespace Permission Denied Windows How to improve this plot? Error: Could Not Set Permissions On Directory : Operation Not Permitted SELinux, most likely. -Doug ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives?
Do these physical parameters seem plausible? have a peek at these guys That isn't to say that you couldn't have a user in both places named maggie-- but you would need to create the user in both the database and the OS for Why did they bring C3PO to Jabba's palace and other dangerous missions? In owner I select postgres and click the OK button. |> 6. How To Create A Tablespace In Postgresql
Actually the regression test "tablespace" fails too, for the same reason, when run from sources (which creates a tablespace directory under src/test/regress) -- Deepak On Wed, Nov 25, 2015 at 2:15 That is not a permanent solution though. I can not reproduce your issue: jd(at)scratch:~$ mkdir /tmp/foo jd(at)scratch:~$ psql -U postgres postgres=# \h create tablespace Command: CREATE TABLESPACE Description: define a new tablespace Syntax: CREATE TABLESPACE tablespacename [ OWNER http://bsdupdates.com/could-not/postgresql-error-could-not-set-permissions-on-directory-permission-denied.php share|improve this answer edited Dec 3 '13 at 7:06 answered Dec 3 '13 at 1:31 Craig Ringer 134k19224307 i'm on centos.i've checked it.the user is postgres.follow is the result.
asked 5 years ago viewed 12381 times active 11 months ago Related 912PostgreSQL “DESCRIBE TABLE”406Creating a copy of a database in PostgreSQL13How can I tell what is in a Postgresql tablespace?3Tablespaces Create Table Postgres 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. Words that are anagrams of themselves Sitecore pre-fetch cache setting clarification Why would breathing pure oxygen be a bad idea?
N(e(s(t))) a string Once you use the exits, you're finally inside me Should I use "teamo" or "skipo"? I'm afraid I know too little about selinux to explain exactly what to do though ... regards, tom lane In response to Could not create a tablespace - permission denied at 2008-04-19 12:58:35 from Graham Leggett Responses Re: Could not create a tablespace - permission denied at I am pretty sure you are missing something.
Why would breathing pure oxygen be a bad idea? Was the Boeing 747 designed to be supersonic? Would there be no time in a universe with only light? this content I would > instead put them somewhere like > > C:\Users\postgres\AppData\Local\Temp (assuming C:\Users\postgres is the > %USERPROFILE% directory for the postgres service owner...) > > > > -- > john r
Is it illegal to DDoS a phishing page?