1 <!-- -*- mode: sgml; mode: fold -*- -->
2 <!doctype refentry PUBLIC "-//OASIS//DTD DocBook V3.1//EN" [
4 <!ENTITY % katieent SYSTEM "katie.ent">
13 <refentrytitle>julia</>
17 <!-- Man page title -->
20 <refpurpose>Utility to sync PostgreSQL with a (LDAP-generated) passwd file</>
27 <arg><option><replaceable>options</replaceable></></arg>
28 <arg choice="plain"><replaceable>passwd file</replaceable></arg>
32 <RefSect1><Title>Description</>
34 <command>julia</command> is a utility to sync PostgreSQL's user database with a passwd file. It is designed to allow the use of 'peer sameuser' authentication. It simply adds any users in the password file into PostgreSQL's pg_user table if they are already not there. It will also warn you about users who are in the pg_user table but not in the password file.
38 <RefSect1><Title>Options</>
41 <VarListEntry><term><option>-q/--quiet<replaceable></replaceable></option></>
43 <Para>Be quiet, i.e. display as little output as possible.</PARA>
47 <VarListEntry><term><option>-v/--verbose</option></>
49 <Para>Be verbose, i.e. display more output than normal.</PARA>
53 <VarListEntry><term><option>-h/--help</option></>
55 <Para>Show help and then exit.</PARA>
63 <title>Configuration</title>
64 <para><command>julia</command> uses katie's configuration file. It follows the typical ISC configuration format as seen in ISC tools like bind 8 and dhcpd. Apart from being able to alter the defaults for command line options, the following configuration items are used:</para>
67 <term>Julia::ValidGID</term>
69 <para>Each user's primary GID is compared with this, if it's not blank. If they match, the user will be processed, if they don't, the user will be skipped.</para>
73 <term>Julia::KnownPostgresUsers</term>
75 <para>This is a comma-separated list of users who are in PostgreSQL's pg_user table but are not in the password file.</para>
81 <RefSect1><Title>Diagnostics</>
83 <command>julia</command> returns zero on normal operation, non-zero on error.