.TH pglistener-update "1" "Sep 2022" "PGLISTENER-UPDATE 5.0" "postgres listener" .\" Text automatically generated by txt2man .SH NAME \fBpglistener-update \fP- postgres listener. \fB .SH DESCRIPTION pglistener-update is a daemon that generates files from Postgres database. .PP It is a tool that listens for notifies from a Postgres database and then calls out to a number of hooks which do everything from updating the password database to updating accounts in RT. .SH USAGE Config and hooks live under: .PP .nf .fam C /var/lib/pglistener /var/lib/pglistener/hooks /etc/pglistener /etc/pglistener/conf.d .fam T .fi It is fine to restart postgres while pglistener is running. .PP If pglistener crashes for whatever reason, it can be restarted as a normal service. .PP Pglistener can in general be restarted at any time, it's quick to start and there are no interruptions to services or authentication. .SH SETTING UP Install a usable pglistener config in /etc/pglistener/pglistener.conf and should be mode 600, user pglistener. .PP Make symlinks for databases in /var/lib/misc: .PP .nf .fam C cd /var/lib/misc ln -s ../pglistener/group.db ln -s ../pglistener/passwd.db ln -s ../pglistener/shadow.db .fam T .fi If you have ssh keys for everybody on the host, add the following two lines to /etc/ssh/sshd_config: .PP .nf .fam C AuthorizedKeysFile /root/%u/.ssh/authorized_keys AuthorizedKeysFile2 /var/lib/misc/sshkeys/%u .fam T .fi Make sure pam_mkhomedir is set up, /etc/pam.d/common-session should contain: .PP .nf .fam C session required pam_mkhomedir.so .fam T .fi .SH AUTHOR The pglistener-update was written by Rob Bradford , Robert McQueen , Dafydd Harries , Tollef Fog Heen , Maxime Buquet , Jordi Mallach , Vivek Das Mohapatra Paulo Henrique de Lima Santana Bruna Pinos de Oliveira Mark Kennedy Stelios Milidonis .PP For a complete list of authors, please open AUTHORS file. .PP This manual page was written by Paulo Henrique de Lima Santana (phls) for the Debian project (but may be used by others).