cdist-type__postgres

cdist-type__postgres_privilege(7)

Nico Schottelius

<nico-cdist--@--schottelius.org>

Table of Contents

1. NAME
2. DESCRIPTION
3. REQUIRED PARAMETERS
4. OPTIONAL PARAMETERS
5. EXAMPLES
6. SEE ALSO
7. COPYING

1. NAME

cdist-type__postgres_privilege - Manage postgres privileges

2. DESCRIPTION

This cdist type allows you to add and remove priviliges in postgres.

3. REQUIRED PARAMETERS

4. OPTIONAL PARAMETERS

state

present or absent, defaults to present

line

SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, and USAGE

Specifies the line which should be absent or present

Must be present, if state is present.
Must not be combined with regex, if state is absent.

regex

If state is present, search for this pattern and add given line, if the given regular expression does not match.

In case of absent, ensure all lines matching the
regular expression are absent (cannot be combined with
the line parameter, if state is absent).

If the regular expression contains / (slashes), they need
to be escaped with \ (backslash): / becomes \/.

file

If supplied, use this as the destination file. Otherwise the object_id is used.

5. EXAMPLES

# Manage the DAEMONS line in rc.conf
__postgres_privilege daemons --file /etc/rc.conf --line 'DAEMONS=(hwclock !network sshd crond postfix)'

# Ensure the home mount is present in /etc/fstab - explicitly make it present
__postgres_privilege home-fstab \
    --file /etc/fstab \
    --line 'filer.fs:/vol/home /home  nfs    defaults        0 0' \
    --state present

# Removes the line specifiend in "include_www" from the file "lighttpd.conf"
__postgres_privilege legacy_timezone --file /etc/rc.conf --regex 'TIMEZONE=.*' --state absent

6. SEE ALSO

cdist-type(7)