man julia (Commandes) - Utility to sync PostgreSQL users with system users
NAME
julia - Utility to sync PostgreSQL users with system users
SYNOPSIS
julia [ options ]
DESCRIPTION
julia 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.
OPTIONS
- -n/--no-action
- Don't actually do anything.
- -q/--quiet
- Be quiet, i.e. display as little output as possible.
- -v/--verbose
- Be verbose, i.e. display more output than normal.
- -h/--help
- Show help and then exit.
CONFIGURATION
julia 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:
- Julia::ValidGID
- 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.
- Julia::KnownPostgresUsers
- This is a comma-separated list of users who are in PostgreSQL's pg_user table but are not in the password file.
DIAGNOSTICS
julia returns zero on normal operation, non-zero on error.
AUTHOR
katie was written by James Troup <james@nocrew.org>.