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 users with system users</>
27 <arg><option><replaceable>options</replaceable></></arg>
31 <RefSect1><Title>Description</>
33 <command>julia</command> is a utility to sync PostgreSQL's user database with the system's users. 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.
37 <RefSect1><Title>Options</>
40 <VarListEntry><term><option>-n/--no-action<replaceable></replaceable></option></>
42 <Para>Don't actually do anything.</PARA>
46 <VarListEntry><term><option>-q/--quiet<replaceable></replaceable></option></>
48 <Para>Be quiet, i.e. display as little output as possible.</PARA>
52 <VarListEntry><term><option>-v/--verbose</option></>
54 <Para>Be verbose, i.e. display more output than normal.</PARA>
58 <VarListEntry><term><option>-h/--help</option></>
60 <Para>Show help and then exit.</PARA>
68 <title>Configuration</title>
69 <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>
72 <term>Julia::ValidGID</term>
74 <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>
78 <term>Julia::KnownPostgresUsers</term>
80 <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>
86 <RefSect1><Title>Diagnostics</>
88 <command>julia</command> returns zero on normal operation, non-zero on error.