pgcharts - Online in the Cloud

PROGRAM:

NAME

pgcharts - PostgreSQL data loader

SYNOPSIS

pgcharts [options] [command-file]...

DESCRIPTION

pgcharts is The PostgreSQL Extension Installer server.

OPTIONS

-h, --help
Show command usage summary and exit.

-V, --version
Show pgcharts version string and exit.

-c, --config
Use the given configuration file (default to "~/.pgcharts.ini").

COMMANDS

The pgcharts binary allows running and controling the pgcharts embedded web server.

CONFIGURATION CONTROL
While it´s possible to ship a configuration file or to prepare it by hand, the following
commands allow to control the setup from the command line.

· config [ name ] [ value ]

Without arguments, print the whole configuration file content. When given a variable
name, print its current value. When given both a name and a value, set the
configuration variable to the given value.

· config get <name>

Print the current value of the configuration variable name.

· config set <name> <value>

Set the variable name to the given value.

SERVER CONTROL
The PostgreSQL Extension Installer comes with a PostgreSQL plugin that downloads static
files: that part doesn´t need any server at all. This server is meant to be used by
maintainers of a set of extension archives, when they want to ease the maintenance and
setup of the building.

· start

Start the embedded pgcharts HTTP server on the port it´s been setup to listen to,
which defaults to 8042. The

· stop

Stops the server.

· status

Print the result of querying the HTTP status API against the (hopefully) running
server.

· pid

Print the registered pid of the server process. This information might be stale in
case of unexpected termination of the server.

· setup <dburi>

Connects to the PostgreSQL database specified with the dburi parameter and install the
database model there.

REGISTERING DATABASES
Once pgcharts is properly setup (see the setup command above) then it´s necessary to add
databases against which you want to run queries and draw charts.

· register <dburi>

Register given dburi.

DATABASE URI

The dburi connection string is expected to be given as a Connection URI as documented in
the PostgreSQL documentation at
http://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNSTRING.

postgresql://[user[:password]@][netloc][:port][/dbname][?sslmode=...]

Where:

· user

Can contain any character, including colon (:) which must then be doubled (::) and
at-sign (@) which must then be doubled (@@).

When omitted, the user name defaults to the value of the PGUSER environment variable,
and if it is unset, the value of the USER environment variable.

· password

Can contain any character, including that at sign (@) which must then be doubled (@@).
To leave the password empty, when the user name ends with at at sign, you then have to
use the syntax user:@.

When omitted, the password defaults to the value of the PGPASSWORD environment
variable if it is set, otherwise the password is left unset.

· netloc

Can be either a hostname in dotted notation, or an ipv4, or an Unix domain socket
path. Empty is the default network location, under a system providing unix domain
socket that method is preferred, otherwise the netloc default to localhost.

It´s possible to force the unix domain socket path by using the syntax
unix:/path/to/where/the/socket/file/is, so to force a non default socket path and a
non default port, you would have:

postgresql://unix:/tmp:54321/dbname

The netloc defaults to the value of the PGHOST environment variable, and if it is unset,
to either the default unix socket path when running on a Unix system, and localhost
otherwise.

· dbname

Should be a proper identifier (letter followed by a mix of letters, digits and the
punctuation signs comma (,), dash (-) and underscore (_).

When omitted, the dbname defaults to the value of the environment variable PGDATABASE,
and if that is unset, to the user value as determined above.

· The only optional parameter supported is sslmode and it accepts the values disable,
allow, prefer and require.

Use pgcharts online using onworks.net services