Q: permissions PostgreSQL/data
Hi.
I destryed one of my Wikis so I had to replace the:
Server/wiki/
Server/PostgreSQL/
folders with a backup..
Unfortunally I dont have the right permissions on the PostgreSQL/data/ folder. Can anyone help me with resetting those for the foldr, and the subfiles/folders.
As it is now the PostgreSQL.log gives me this fault
CETFATAL: could not create lock file "postmaster.pid": Permission denied
The permissions are now:
$ sudo ls -al /Library/Server/PostgreSQL/
total 0
drwxrw-r-x@ 5 _teamsserver _teamsserver 170 23 Mar 2013 .
drwxr-xr-x 28 root wheel 952 18 Mar 22:09 ..
drwxr-xr-x@ 3 _postgres _postgres 102 19 Mar 00:04 Config
drwx------+ 19 _postgres _postgres 646 19 Mar 10:17 Data
$ sudo ls -al /Library/Server/PostgreSQL/Data/
total 80
drwx------+ 19 _postgres _postgres 646 19 Mar 10:17 .
drwxrw-r-x@ 5 _teamsserver _teamsserver 170 23 Mar 2013 ..
-rwx------+ 1 _postgres _postgres 4 19 Mar 10:19 PG_VERSION
drwx------+ 6 _postgres _postgres 204 23 Mar 2013 base
drwx------+ 45 _postgres _postgres 1530 23 Mar 2013 global
drwx------+ 4 _postgres _postgres 136 23 Mar 2013 pg_clog
-rwx------+ 1 _postgres _postgres 4479 19 Mar 10:19 pg_hba.conf
-rwx------+ 1 _postgres _postgres 1636 19 Mar 10:19 pg_ident.conf
drwx------+ 4 _postgres _postgres 136 23 Mar 2013 pg_multixact
drwx------+ 3 _postgres _postgres 102 23 Mar 2013 pg_notify
drwx------+ 2 _postgres _postgres 68 23 Mar 2013 pg_serial
drwx------+ 2 _postgres _postgres 68 23 Mar 2013 pg_snapshots
drwx------+ 2 _postgres _postgres 68 23 Mar 2013 pg_stat_tmp
drwx------+ 3 _postgres _postgres 102 23 Mar 2013 pg_subtrans
drwx------+ 2 _postgres _postgres 68 23 Mar 2013 pg_tblspc
drwx------+ 2 _postgres _postgres 68 23 Mar 2013 pg_twophase
drwx------+ 4 _postgres _postgres 136 23 Mar 2013 pg_xlog
-rwx------ 1 _postgres _postgres 19596 19 Mar 10:19 postgresql.conf
-rwx------+ 1 _postgres _postgres 481 19 Mar 10:19 postmaster.opts
I dont know what the original permissions should be exect that The Data/ folder should have 700. Can anyone have a look at there servers and chack what kind of attribs the folder/files has?
Since the PostgreSQL dont work I cant start my wiki...
collabd[700]: [CSConnectionPool.m:196 77fa000 +0ms] Could not open a connection to Postgres. Please make sure it is running and has the correct access.
collabd[700]: [CSXCWorkSchedulerService.m:196 77fa000 +0ms] Failed to open DB connection, retrying in 10s: [CSDatabaseError] Connection to DB failed
com.apple.launchd[1]: (org.postgresql.postgres[51647]) Exited with code: 1
com.apple.launchd[1]: (org.postgresql.postgres) Throttling respawn: Will start in 10 seconds
It to late to do a complete reset form timemaschine since people has been working on the server for a few days. So all I want is a chmod and a chmod +acommand for the _postgres account...
Mac mini, OS X Server, Maveriks server
Posted on Mar 19, 2014 4:22 AM
Posted on Mar 20, 2014 10:07 AM