View Single Post
  #1   (View Single Post)  
Old 4th March 2020
CiotBSD CiotBSD is offline
c107:b5d::
 
Join Date: Jun 2019
Location: Under /
Posts: 175
Default [6.6] postgresql .lock: Permission denied

Hi,

Today I install postgresql server on OpenBSD 6.6 server.

Into file postgresql.conf, I set socket_unix_directories, as:
Code:
unix_socket_directories = '/var/www/tmp/postgresql, /tmp'
But, the server deny to start!
Quote:
2020-03-04 14:02:04.169 CET [50162] LOG: listening on IPv4 address "127.0.0.1", port 5432
2020-03-04 14:02:04.169 CET [50162] LOG: listening on IPv6 address "::1", port 5432
2020-03-04 14:02:04.170 CET [50162] FATAL: could not open lock file "/var/www/tmp/postgresql/.s.PGSQL.5432.lock": Permission denied
2020-03-04 14:02:04.170 CET [50162] LOG: database system is shut down
The rights on FS are:
Code:
# ls -al /var/www/ | grep tmp                                                                                                                                                         
drwx-----T   3 www   www     512 Mar  4 01:00 tmp/

# ls -al /var/www/tmp         
total 12
drwx-----T   3 www          www     512 Mar  4 01:00 ./
drwxr-xr-x  13 root         daemon  512 Mar  4 00:35 ../
drwxr-xr-x   2 _postgresql  www     512 Mar  4 01:00 postgresql/
One idea/suggestion?!
__________________
GPG:Fingerprint ed25519 : 072A 4DA2 8AFD 868D 74CF 9EA2 B85E 9ADA C377 5E8E
GPG:Fingerprint rsa4096 : 4E0D 4AF7 77F5 0FAE A35D 5B62 D0FF 7361 59BF 1733
Reply With Quote