EDB Postgres Distributed Command Line Interface v4
The EDB Postgres Distributed Command Line Interface (PGD CLI) is a tool to manage your EDB Postgres Distributed cluster. It allows you to run commands against EDB Postgres Distributed clusters.
See the Command reference for the available commands to inspect, manage, and get information on cluster resources.
See Installing PGD CLI for information about how TPAexec deploys PGD CLI, how to install PGD CLI on a standalone server manually, and specifying connection strings.
The PGD CLI requires postgres superuser privileges to run.
pgd is the command name for the PGD command line interface. See pgd in the Command reference for a description of the command options. See the following sections for sample use cases.
If you rename the file or move it to another location, specify the new name and location using the optional
--config-file flag. For example:
--dsn flag to pass a database connection string directly to a command. You don't need a configuration file if you pass the connection string with this flag. The flag takes precedence if a configuration file is present. For example:
The PGD CLI supports the following output formats:
|tabular||Default format. Presents the data in tabular form.|
|json||Presents the raw data with no formatting. For some commands, the json output may show more data than shown in the tabular output such as extra fields and more detailed messages.|
|yaml||Same as json except field order is alphabetical. Experimental and may not be fully supported in future versions.|
--output flag to change the default output format to json or yaml. For example:
To list the supported commands, enter:
For help for a specific command and its parameters, enter
pgd help <command_name>. For example: