postgres, initdb, FreeBSD bug?

[David Noel]

Ahh... the security.bsd. sysctl output had the answer: I had
security.bsd.hardlink_check_gid and security.bsd.hardlink_check_uid
set to 1 in sysctl.conf. Removing that fixed the problem.

Many thanks,

-David



> Show the ktrace from the same error on UFS.

  5179 postgres CALL  unlink(0x7fffffffe570)
  5179 postgres NAMI  "pg_notify/0000"
  5179 postgres RET   unlink 0
  5179 postgres CALL  getdirentries(0x3,0x801a4b000,0x1000,0x801a4a068)
  5179 postgres RET   getdirentries 0
  5179 postgres CALL  lseek(0x3,0,SEEK_SET)
  5179 postgres RET   lseek 0
  5179 postgres CALL  close(0x3)
  5179 postgres RET   close 0
  5179 postgres CALL  open(0x7fffffffe580,O_RDWR|O_CREAT,S_IRUSR|S_IWUSR)
  5179 postgres NAMI  "pg_notify/0000"
  5179 postgres RET   open 3
  5179 postgres CALL  lseek(0x3,0,SEEK_SET)
  5179 postgres RET   lseek 0
  5179 postgres CALL  write(0x3,0x8041c1b40,0x2000)
  5179 postgres GIO   fd 3 wrote 4096 bytes
...
  5179 postgres RET   write 8192/0x2000
  5179 postgres CALL  close(0x3)
  5179 postgres RET   close 0
  5179 postgres CALL  unlink(0x7fffffffbc60)
  5179 postgres NAMI  "pg_xlog/000000010000000000000001"
  5179 postgres RET   unlink -1 errno 2 No such file or directory
  5179 postgres CALL  link(0x7fffffffc130,0x7fffffffbc60)
  5179 postgres NAMI  "pg_xlog/xlogtemp.5179"
  5179 postgres NAMI  "pg_xlog/000000010000000000000001"
  5179 postgres RET   link -1 errno 1 Operation not permitted
  5179 postgres CALL  unlink(0x7fffffffc130)
  5179 postgres NAMI  "pg_xlog/xlogtemp.5179"
  5179 postgres RET   unlink 0
  5179 postgres CALL  open(0x7fffffffc530,O_RDWR,<unused>0x180)
  5179 postgres NAMI  "pg_xlog/000000010000000000000001"
  5179 postgres RET   open -1 errno 2 No such file or directory


> Show the security.bsd sysctl settings, in particular,
> harlink_check_{u,g}id.ygg# sysctl security.bsd.

security.bsd.map_at_zero: 0
security.bsd.suser_enabled: 1
security.bsd.unprivileged_proc_debug: 0
security.bsd.conservative_signals: 1
security.bsd.see_other_gids: 0
security.bsd.see_other_uids: 0
security.bsd.unprivileged_idprio: 0
security.bsd.unprivileged_read_msgbuf: 0
security.bsd.hardlink_check_gid: 1
security.bsd.hardlink_check_uid: 1
security.bsd.unprivileged_get_quota: 0
security.bsd.stack_guard_page: 0

> Show the ls -la output for the pg_xlog directory.

ygg:~> ls -la /zdb/pgsql/data/pg_xlog/
total 5
drwx------   3 pgsql  wheel   3 Dec 15 08:39 .
drwx------  14 pgsql  wheel  18 Dec 15 08:39 ..
drwx------   2 pgsql  wheel   2 Dec 15 08:39 archive_status