EnglishFrenchSpanish

OnWorks favicon

pg_virtualenv - Online in the Cloud

Run pg_virtualenv in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command pg_virtualenv that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


pg_virtualenv - Create a throw-away PostgreSQL environment for running regression tests

SYNOPSIS


pg_virtualenv [OPTIONS] [-v 'version ...'] [command]

DESCRIPTION


pg_virtualenv creates a virtual PostgreSQL server environment, and sets environment
variables such that command can access the PostgreSQL database server(s). The servers are
destroyed when command exits.

The environment variables PGHOST, PGDATABASE, PGUSER, and PGPASSWORD will be set. Per
default, a single new cluster is created, using the newest PostgreSQL server version
installed. The cluster will use the first available port number starting from 5432, and
PGPORT will be set.

When clusters for more than one versions are created, they will differ in the port number
used, and PGPORT is not set. The clusters are named version/regress. To access a cluster,
set PGCLUSTER=version/regress. For ease of access, the clusters are also registered in
/etc/postgresql-common/pg_service.conf, with the version number as cluster name. Clusters
can be accessed by passing the connection string "service=version", e.g. psql service=9.2.

When invoked as root, the clusters are created in /etc/postgresql/ as usual; for other
users, PG_CLUSTER_CONF_ROOT and PGSYSCONFDIR are set to a temporary directory where all
files belonging to the clusters are created.

OPTIONS


-a Use all PostgreSQL server versions installed.

-v version ...
Use these versions (space-separated list).

-c pg_createcluster options
Extra options to pass to pg_createcluster.

-i initdb options
Extra initdb options to pass to pg_createcluster.

-o guc=value
Configuration option to set in the postgresql.conf file, passed to pg_createcluster.

-s Launch a shell inside the virtual environment when command fails.

-t Install clusters in a temporary directory, even when running as root.

-h Show program help.

EXAMPLE


# pg_virtualenv make check

NOTES


When run with fakeroot(1), pg_virtualenv will fall back to the non-root mode of operation.
Running "fakeroot pg_virtualenv" as root will fail, though.

ENVIRONMENT


PG_VIRTUALENV_NEWPID=yes
When non-empty, pg_virtualenv will re-exec itself using newpid(1).

PG_VIRTUALENV_UNSHARE=flags
When non-empty, pg_virtualenv will re-exec itself using unshare(1) using these flags.

PGPORT=n
When set, the value is used for the (single) cluster created.

Use pg_virtualenv online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

Linux commands

  • 1
    a2j_control
    a2j_control
    a2j_control - utility to control
    a2jmidid daemon ...
    Run a2j_control
  • 2
    a2mp3
    a2mp3
    a2mp3 - program to optimize your music
    for your mp3 player ...
    Run a2mp3
  • 3
    create_common
    create_common
    ctn_manpage - Generic CTN manual page
    DESCRIPTION: This is a generic manual
    package for a CTN program. All CTN
    programs will give their brief usage
    synopsis wh...
    Run create_common
  • 4
    create_compressed_fs
    create_compressed_fs
    create_compressed_fs,
    extract_compressed_fs - convert and
    extract a filesystem to/from a cloop
    volume ...
    Run create_compressed_fs
  • 5
    gapi2-codegen
    gapi2-codegen
    undocumented - No manpage for this
    program. DESCRIPTION: This program does
    not have a manpage. Run this command
    with the help switch to see what it
    does. For f...
    Run gapi2-codegen
  • 6
    gapi2-fixup
    gapi2-fixup
    undocumented - No manpage for this
    program. DESCRIPTION: This program does
    not have a manpage. Run this command
    with the help switch to see what it
    does. For f...
    Run gapi2-fixup
  • More »

Ad