---
name: "cvm-pgsql"
section: "8"
platform: "linux"
package: "cvm-pgsql"
version: "0.97-3"
release: "Debian 12 (Bookworm)"
platforms: ["linux"]
url: "https://new.carta.tech/cvm-pgsql"
---

# cvm-pgsql(8)

PgSQL module

## NAME

cvm-pgsql - PgSQL module

## SYNOPSIS

cvm-pgsql

## CREDENTIALS

Pass phrase

## DESCRIPTION

This module queries a PgSQL database for the account name, compares the stored pass phrase with the given one using [**crypt**(3)](/crypt/3.md).

## CONFIGURATION VARIABLES

The server hostname, port, database, username, password, and additional options can be controlled by setting *$PGHOST*, *$PGPORT*, *$PGDATABASE*, *$PGUSER*, *$PGPASSWORD*, and *$PGOPTIONS* respectively, which are parsed by the PgSQL client library.

- **CVM\_MYSQL\_POSTQ (optional)**

  The SQL query to execute after the credentials have been validated, see [**cvm-sql**(7)](/cvm-sql/7.md).

- **CVM\_PGSQL\_PWCMP (optional)**

  The *password comparison module* to use.

- **CVM\_PGSQL\_QUERY (optional)**

  The SQL query to issue to retrieve the row containing the account information from the database.

## SEE ALSO

[cvm-sql(7)](/cvm-sql/7.md), [cvm-mysql(8)](/cvm-mysql/8.md), [cvm-pwfile(8)](/cvm-pwfile/8.md), [cvm-qmail(8)](/cvm-qmail/8.md), [cvm-unix(8)](/cvm-unix/8.md), [cvm-vmailmgr(8)](/cvm-vmailmgr/8.md), [cvm-benchclient(8)](/cvm-benchclient/8.md), [cvm-checkpassword(8)](/cvm-checkpassword/8.md), [cvm-testclient(8)](/cvm-testclient/8.md)

 http://untroubled.org/pwcmp/pwcmp.html\
  http://untroubled.org/cvm/cvm.html