Project

General

Profile

Bug #3028

postgresql installation and postgresql-openrc issue

0xddc - 4 months ago - . Updated 4 months ago.

Status:
confirmed
Priority:
bug
Assignee:
-
% Done:

0%

History

#1

Updated by bill-auger 4 months ago

  • Status changed from unconfirmed to confirmed

i have identified 4 bugs with one of postgresql, postgresql-openrc, opentmpfiles, or opensysusers

bug 1: (opentmpfiles) patch is broken
this was my bad - i had multiple WIP versions of the 'chattr-ignore-nocow.patch' patch, and i used the wrong one

bug 2: (postgresql-openrc?) HINT: is wrong

$ sudo rc-service postgresql start
[sudo] pasvorto por bill:
 * /var/lib/postgres/data/postgresql.conf not found
 * HINT: mv /var/lib/postgres/data/*.conf /var/lib/postgres/data/
 * ERROR: postgresql failed to start

-----------------------
bug 3: (postgresql?) TODO: 'data' dir is not supposed to exist before running `initdb`

$ sudo ls /var/lib/postgres/data/

-----------------------
bug 4: (opensysusers?) PG user should have shell

$ sudo -iu postgres
This account is currently not available.

$ grep postgres /etc/passwd
postgres:x:968:968:PostgreSQL user:/var/lib/postgres:/sbin/nologin

$ cat /usr/share/libalpm/hooks/20-opensysusers.hook
[Trigger]
Type = File
Operation = Install
Operation = Upgrade
Target = usr/lib/sysusers.d/*.conf

[Action]
Description = Creating system user accounts...
When = PostTransaction
Exec = /usr/share/libalpm/scripts/sysusers-hook sysusers
NeedsTargets

$ pkgfile /usr/lib/sysusers.d/postgresql.conf
extra/postgresql

$ cat /usr/lib/sysusers.d/postgresql.conf
u postgres - "PostgreSQL user" /var/lib/postgres /bin/bash

#2

Updated by bill-auger 4 months ago

  • Description updated (diff)

bug 1: (opentmpfiles) is fixed in abslibre

Also available in: Atom PDF