Postgres Pro Shardman Client Applications
This part contains reference information for
Postgres Pro Shardman client applications and
utilities. Not all of these commands are of general utility; some
might require special privileges. The common feature of these
applications is that they can be run on any host, independent of
where the database server resides.
When specified on the command line, user and database names have
their case preserved — the presence of spaces or special
characters might require quoting. Table names and other identifiers
do not have their case preserved, except where documented, and
might require quoting.
Table of Contents
- clusterdb — cluster a Postgres Pro Shardman database
- createdb — create a new Postgres Pro Shardman database
- createuser — define a new Postgres Pro Shardman user account
- dropdb — remove a Postgres Pro Shardman database
- dropuser — remove a Postgres Pro Shardman user account
- ecpg — embedded SQL C preprocessor
- pg_amcheck — checks for corruption in one or more
Postgres Pro Shardman databases
- pgbench — run a benchmark test on Postgres Pro Shardman
- pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups
- pg_config — retrieve information about the installed version of Postgres Pro Shardman
- pg_dump —
export a Postgres Pro Shardman database as an SQL script or to other formats
- pg_dumpall — extract a Postgres Pro Shardman database cluster into a script file
- pg_isready — check the connection status of a Postgres Pro Shardman server
- pg_receivewal — stream write-ahead logs from a Postgres Pro Shardman server
- pg_recvlogical — control Postgres Pro Shardman logical decoding streams
- pg_restore —
restore a Postgres Pro Shardman database from an
archive file created by pg_dump
- pg-wrapper
— manage Postgres Pro Shardman symbolic links
- pg_verifybackup — verify the integrity of a base backup of a
Postgres Pro Shardman cluster
- psql —
Postgres Pro Shardman interactive terminal
- reindexdb — reindex a Postgres Pro Shardman database
- vacuumdb — garbage-collect and analyze a Postgres Pro Shardman database