<commit_before>---
title: Postgres
authors: emesika
wiki_title: OVirt-DB-Issues/Postgres
wiki_revision_count: 31
wiki_last_updated: 2012-08-09
---

# Postgres

## Installation

We are using version 9.1.x
[Installation Guide](http://www.ovirt.org/wiki/Installing_PostgreSQL_DB)

## Authentication

Trust
Password
GSSAPI
SSPI
Kerberos
Ident
Peer
LDAP
RADIUS
Certificate
PAM
 details:
[Authentication Methods](http://www.postgresql.org/docs/9.1/static/auth-methods.html)

## Creating a new user

[Create Role](http://www.postgresql.org/docs/9.1/static/sql-createrole.html)
[Create User](http://www.postgresql.org/docs/9.0/static/sql-createuser.html)
[The password file](http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html)

## Configuration
<commit_msg>Configuration<commit_after>---
title: Postgres
authors: emesika
wiki_title: OVirt-DB-Issues/Postgres
wiki_revision_count: 31
wiki_last_updated: 2012-08-09
---

# Postgres

## Installation

We are using version 9.1.x
[Installation Guide](http://www.ovirt.org/wiki/Installing_PostgreSQL_DB)

## Authentication

Trust
Password
GSSAPI
SSPI
Kerberos
Ident
Peer
LDAP
RADIUS
Certificate
PAM
 details:
[Authentication Methods](http://www.postgresql.org/docs/9.1/static/auth-methods.html)

## Creating a new user

[Create Role](http://www.postgresql.org/docs/9.1/static/sql-createrole.html)
[Create User](http://www.postgresql.org/docs/9.0/static/sql-createuser.html)
[The password file](http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html)

## Configuration

Default postgres configuration files are under */var/lib/pgsql/data*

{'fraction_non_alphanumeric': 0.13745271122320302, 'fraction_numerical': 0.025220680958385876, 'mean_word_length': 5.034220532319392, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 10, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6519543', 'n_tokens_mistral': 615, 'n_tokens_neox': 580, 'n_words': 101}