[ThingWorx] Install PostgreSQL Issue
ThingWorx application need PostgreSQL, I try configurate it in macbook. The first step is install PostgreSQL.
Install PostgreSQL is very easy. Download it from www.postgresql.org, and install it.
But after installing db, I need create the database and space. I got error by following command.
postgres=# CREATE TABLESPACE thingworx
postgres-# OWNER twadmin
postgres-# LOCATION '/Work/ThingWorx/ThingworxPostgresqlStorage/thingworx';
ERROR: could not set permissions on directory "/Work/ThingWorx/ThingworxPostgresqlStorage/thingworx": Operation not permitted
postgres=#
ERROR: could not set permissions on directory "/Work/ThingWorx/ThingworxPostgresqlStorage/thingworx": Operation not permitted
After some search in bing and baidu, I found the solution and reason.
The folder I was created by 'Eric' user, but PostgreSQL need set the creator as 'postgres'. Than I change the folder creator by following command.
$sudo chown postgres /Work/ThingWorx/ThingworxPostgresqlStorage/thingworx
$sudo chown postgres /Work/ThingWorx/ThingworxPostgresqlStorage/thingworx
After change the folder's owner, it work well.
BTW, If you create table or space repear the permission issue, please check the PostgreSQL's service account have full permission for the folder.
最新文章
- 数据存储_FMDB数据库队列
- WebApi Post 后台无法获取参数的解决方案
- iOS 2D绘图 (Quartz2D)之阴影和渐变(shadow，Gradient)
- java-生成印章swing
- CentOS下安装Redis及Redis的PHP扩展
- AndroidDev站点推荐-zz
- CSS实例：鼠标滑过超级链接文字时改变背景颜色
- UVa 11732 (Tire树) "strcmp()" Anyone?
- 【转】二叉树 VS hashtable
- windows 下搭建 apache + php52 + postgreSQL7/8/9环境
- OpenVPN GUI: "No TAP-WIN32 adapters on this system"
- Linux haproxy配置参数
- Abp.vNext 权限备注
- 8 种常被忽视的 SQL 错误用法
- PHP+Ajax实现文件上传功能
- python bittorrent 使用与学习
- c++设计一个无法被继承的类
- https://www.cnblogs.com/beileixinqing/p/7724779.html vue-cli生成的项目配置开发和生产环境不同的接口 vue-cli生成的项目，vue项目配置了不同开发环境的接口地址，axios.defaults.baseURL如何引用这个地址，这是在我发布项目的时候考虑的，于是想到了
- OpenJudge 兔子与樱花
- GoldNumber游戏比赛成绩公布