TutorialDBA - Support | Training | Consultant

pg_createcluster -V (return code: 1) Usage: /usr/bin/pg_createcluster [options] <version> <cluster name> [-- <initdb options>] Options: -u <uid> cluster owner and superuser (default: 'postgres') -g <gid> group for data files (default: primary group of owner) -d <dir> data directory (default: /var/lib/postgresql/<version>/<cluster name>) -s <dir> socket directory (default: /var/run/postgresql for clusters owned by 'postgres', /tmp for other clusters) -l <dir> path to desired log file (default: /var/log/postgresql/postgresql-<version>-<cluster>.log) --locale <encoding> set cluster locale (default: inherit from environment) --lc-collate/ctype/messages/monetary/numeric/time <locale> like --locale, but only set for a particular category -e <encoding> Default encod...

createlang --help (return code: 0) createlang installs a procedural language into a PostgreSQL database. Usage: createlang [OPTION]... LANGNAME [DBNAME] Options: -d, --dbname=DBNAME database to install language in -e, --echo show the commands being sent to the server -l, --list show a list of currently installed languages -V, --version output version information, then exit -?, --help show this help, then exit Connection options: -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port -U, --username=USERNAME user name to connect as -w, --no-password never prompt for password -W, --password force password prompt Report bugs to <pgsql-bugs@postgresql.org>.

pg_isready --help (return code: 0) pg_isready issues a connection check to a PostgreSQL database. Usage: pg_isready [OPTION]... Options: -d, --dbname=DBNAME database name -q, --quiet run quietly -V, --version output version information, then exit -?, --help show this help, then exit Connection options: -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port -t, --timeout=SECS seconds to wait when attempting connection, 0 disables (default: 3) -U, --username=USERNAME user name to connect as Report bugs to <pgsql-bugs@postgresql.org>.

pgsql2sqlite --help (return code: 0) Postgresql/PostGIS to SQLite3 converter Options: -? [ --help ] Display this help screen. -h [ --host ] arg Allows you to specify connection to a database on a machine other than the default. -p [ --port ] arg Allows you to specify a database port other than the default. -u [ --user ] arg Connect to the database as the specified user. -d [ --dbname ] arg postgresql database name -P [ --password ] arg Connect to the database with the specified password. -q [ --query ] arg Name of the table/or query to pass to postmaster -t [ --table ] arg Name of the output table to create (default: table in query) -f [ --file ] arg Use this option to specify the name of the file to create. usage: pgsql2sqlite --dbname db --table planet_osm_line --file osm.sqlite --query "select * from planet_osm_line"

pg_config.libpq-dev --help (return code: 0) pg_config.libpq-dev provides information about the installed version of PostgreSQL. Usage: pg_config.libpq-dev [OPTION]... Options: --bindir show location of user executables --docdir show location of documentation files --htmldir show location of HTML documentation files --includedir show location of C header files of the client interfaces --pkgincludedir show location of other C header files --includedir-server show location of C header files for the server --libdir show location of object code libraries --pkglibdir show location of dynamically loadable modules --localedir show location of locale support files --mandir show location of manual pages --sharedir show location of architecture-independent support files --sysconfdir show location of system-wide configuratio...

pgagent --help (return code: 1) PostgreSQL Scheduling Agent Version: 3.4.1 Usage: pgagent [options] <connect-string> options: -v (display version info and then exit) -f run in the foreground (do not detach from the terminal) -t <poll time interval in seconds (default 10)> -r <retry period after connection abort in seconds (>=10, default 30)> -s <log file (messages are logged to STDOUT if not specified> -l <logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default 0)>

dropuser --help dropuser removes a PostgreSQL role. Usage: dropuser [OPTION]... [ROLENAME] Options: -e, --echo show the commands being sent to the server -i, --interactive prompt before deleting anything, and prompt for role name if not specified -V, --version output version information, then exit --if-exists don't report error if user doesn't exist -?, --help show this help, then exit Connection options: -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port -U, --username=USERNAME user name to connect as (not the one to drop) -w, --no-password never prompt for password -W, --password force password prompt

dropdb --help (return code: 0) dropdb removes a PostgreSQL database. Usage: dropdb [OPTION]... DBNAME Options: -e, --echo show the commands being sent to the server -i, --interactive prompt before deleting anything -V, --version output version information, then exit --if-exists don't report error if database doesn't exist -?, --help show this help, then exit Connection options: -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port -U, --username=USERNAME user name to connect as -w, --no-password never prompt for password -W, --password force password prompt --maintenance-db=DBNAME alternate maintenance database Report bugs to <pgsql-bugs@postgresql.org>.

pgbench --help (return code: 0) pgbench is a benchmarking tool for PostgreSQL. Usage: pgbench [OPTION]... [DBNAME] Initialization options: -i, --initialize invokes initialization mode -F, --fillfactor=NUM set fill factor -n, --no-vacuum do not run VACUUM after initialization -q, --quiet quiet logging (one message each 5 seconds) -s, --scale=NUM scaling factor --foreign-keys create foreign key constraints between tables --index-tablespace=TABLESPACE create indexes in the specified tablespace --tablespace=TABLESPACE create tables in the specified tablespace --unlogged-tables create tables as unlogged tables Benchmarking options: -c, --client=NUM number of concurrent database clients (default: 1) -C, --connect establish new connection for each transaction -D, --define=VARNAME=VALUE define variable for use by custom script -f...

pg_config --help pg_config provides information about the installed version of PostgreSQL. Usage: pg_config [OPTION]... Options: --bindir show location of user executables --docdir show location of documentation files --htmldir show location of HTML documentation files --includedir show location of C header files of the client interfaces --pkgincludedir show location of other C header files --includedir-server show location of C header files for the server --libdir show location of object code libraries --pkglibdir show location of dynamically loadable modules --localedir show location of locale support files --mandir show location of manual pages --sharedir show location of architecture-independent support files --sysconfdir show location of system-wide configuration files --pgxs show location o...

psql is the PostgreSQL interactive terminal. Usage: psql [OPTION]... [DBNAME [USERNAME]] General options: -c, --command=COMMAND run only single command (SQL or internal) and exit -d, --dbname=DBNAME database name to connect to (default: "ubuntu") -f, --file=FILENAME execute commands from file, then exit -l, --list list available databases, then exit -v, --set=, --variable=NAME=VALUE set psql variable NAME to VALUE (e.g., -v ON_ERROR_STOP=1) -V, --version output version information, then exit -X, --no-psqlrc do not read startup file (~/.psqlrc) -1 ("one"), --single-transaction execute as a single transaction (if non-interactive) -?, --help[=options] show this help, then exit --help=commands list backslash commands, then exit --help=variables list special variables, then exit Input and output o...

rsync version 3.1.1 protocol version 31 Copyright (C) 1996-2014 by Andrew Tridgell, Wayne Davison, and others. Web site: http://rsync.samba.org/ Capabilities: 64-bit files, 64-bit inums, 64-bit timestamps, 64-bit long ints, socketpairs, hardlinks, symlinks, IPv6, batchfiles, inplace, append, ACLs, xattrs, iconv, symtimes, prealloc rsync comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions. See the GNU General Public Licence for details. rsync is a file transfer program capable of efficient remote update via a fast differencing algorithm. Usage: rsync [OPTION]... SRC [SRC]... DEST or rsync [OPTION]... SRC [SRC]... [USER@]HOST:DEST or rsync [OPTION]... SRC [SRC]... [USER@]HOST::DEST or rsync [OPTION]... SRC [SRC]... rsync://[USER@]HOST[:PORT]/DEST or rsync [OPTION]... [USER@]HOST:SRC [DEST] or rsync [OPTION]... [USER@]HOST::SRC [DEST] or rsync [OPTION]... rsync://[USER@]HOST[:...

pg_basebackup --help pg_basebackup takes a base backup of a running PostgreSQL server. Usage: pg_basebackup [OPTION]... Options controlling the output: -D, --pgdata=DIRECTORY receive base backup into directory -F, --format=p|t output format (plain (default), tar) -r, --max-rate=RATE maximum transfer rate to transfer data directory (in kB/s, or use suffix "k" or "M") -R, --write-recovery-conf write recovery.conf after backup -T, --tablespace-mapping=OLDDIR=NEWDIR relocate tablespace in OLDDIR to NEWDIR -x, --xlog include required WAL files in backup (fetch mode) -X, --xlog-method=fetch|stream include required WAL files with specified method --xlogdir=XLOGDIR location for the transaction log directory -z, --gzip compress tar output -Z, --compress=0-9 compress tar output with given compression level Ge...

pg_restore restores a PostgreSQL database from an archive created by pg_dump. Usage: pg_restore [OPTION]... [FILE] General options: -d, --dbname=NAME connect to database name -f, --file=FILENAME output file name -F, --format=c|d|t backup file format (should be automatic) -l, --list print summarized TOC of the archive -v, --verbose verbose mode -V, --version output version information, then exit -?, --help show this help, then exit Options controlling the restore: -a, --data-only restore only the data, no schema -c, --clean clean (drop) database objects before recreating -C, --create create the target database -e, --exit-on-error exit on error, default is to continue -I, --index=NAME restore named index -j, --jobs=NUM use this many parallel jobs to restore -L, --use-list=FILENAME use table of contents ...

pg_dumpall --help (return code: 0) pg_dumpall extracts a PostgreSQL database cluster into an SQL script file. Usage: pg_dumpall [OPTION]... General options: -f, --file=FILENAME output file name -v, --verbose verbose mode -V, --version output version information, then exit --lock-wait-timeout=TIMEOUT fail after waiting TIMEOUT for a table lock -?, --help show this help, then exit Options controlling the output content: -a, --data-only dump only the data, not the schema -c, --clean clean (drop) databases before recreating -g, --globals-only dump only global objects, no databases -o, --oids include OIDs in dump -O, --no-owner skip restoration of object ownership -r, --roles-only dump only roles, no databases or tablespaces -s, --schema-only dump only the schema, no data -S, --superuser=NAME superus...

pg_dump dumps a database as a text file or to other formats. Usage: pg_dump [OPTION]... [DBNAME] General options: -f, --file=FILENAME output file or directory name -F, --format=c|d|t|p output file format (custom, directory, tar, plain text (default)) -j, --jobs=NUM use this many parallel jobs to dump -v, --verbose verbose mode -V, --version output version information, then exit -Z, --compress=0-9 compression level for compressed formats --lock-wait-timeout=TIMEOUT fail after waiting TIMEOUT for a table lock -?, --help show this help, then exit Options controlling the output content: -a, --data-only dump only the data, not the schema -b, --blobs include large objects in dump -c, --clean clean (drop) database objects before recreating -C, --create include commands to create dat...