Error Could Not Set Permissions On Directory Postgres
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack postgres create tablespace permission denied windows Overflow the company Business Learn more about hiring developers or posting ads with us
Could Not Set Permissions On Directory Postgres Windows
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community postgresql check if tablespace exists of 4.7 million programmers, just like you, helping each other. 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
Error Could Not Set Permissions On Directory Operation Not Permitted
a tablespace in postgres, but I'm getting ownership problems. 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 postgres:postgres, I've tried changing it to maggie, but if I go : chown maggie:postgres /home/john/BSTablespace I get: chown: invalid user: `maggie:postgres' How come the user does not exist? If I list postgres list tablespaces the users inside of postgres it does come up. Any ideas what I could be doing wrong? postgresql tablespace chown share|improve this question asked Mar 6 '11 at 1:45 The_Denominater 4004518 add a comment| 1 Answer 1 active oldest votes up vote 13 down vote accepted I would hazard a guess that the problem lies in the permissions of the parent directory "/home/john". 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 change it). Doing something like: mkdir /BSTablespace chown postgres:postgres /BSTablespace and then CREATE TABLESPACE magdat OWNER maggie LOCATION '/BSTablespace'; should work fine. Regarding the user maggie: database users are not the same as OS users. 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 that to happen. share|improve this answer edited Nov 5 '15 at 20:22 answered Mar 6 '11 at 4:02 gsiems 1,6111018 Thanks, that was the problem. Put it in root and there was no problem. –The_Denominater Mar 7 '11 at 0:06 @gsiems update your answer, chown postgres:postgres /Directory. &ndash
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
Postgresql Create Tablespace
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 https://www.postgresql.org/message-id/legacy/pgsql-bugs/2008-04/msg00132.php Users International Sites Propaganda Resources Weekly News BUG #4116: Cannot create tablespace: could not set permissions on directory From: "Graham Leggett"
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [SOLVED] Permissions error with PostgreSQL psql process Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 2 of 2 Thread: Permissions error with PostgreSQL psql process Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode August 13th, 2011 #1 gargoyle60 View Profile View Forum Posts Private Message 5 Cups of Ubuntu Join Date Jun 2009 Location Kent, England Beans 32 DistroUbuntu 11.04 Natty Narwhal Permissions error with PostgreSQL psql process Need help please! I have installed PostgreSQL 9.0 in Ubuntu 11.04. The following is a bit long-winded and cross-relates to PostgreSQL, but I'm sure others are using it on Ubuntu so might offer help. I ran the PostgreSQL installation thus: Code: sudo su ./postgresql-9.0.4-1-linux.bin accepting all the installer defaults except specifying the Data Directory as "/home/gary/PostgreSQL/9.0/data/gjd_data/gjd_sentinel_data" (NB. 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: mkdir /home/gary/PostgreSQL/ mkdir /home/gary/PostgreSQL/9.0 mkdir /home/gary/PostgreSQL/9.0/data/ mkdir /home/gary/PostgreSQL/9.0/data/gjd_data mkdir /home/gary/PostgreSQL/9.0/data/gjd_data/gjd_sentinel_data I have a personal project database script file (copied from my Windows installation) that I know works perfectly under Windows. It has been modified for the correct paths/locations, etc. for Linux. When run this should create my entire project database, including loading sample data. 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/ps