pgd assess

Synopsis

The pgd assess command assesses the suitability of a Postgres server instance for migration to an EDB Postgres Distributed cluster. It’s designed to run against standard Postgres instances that don’t yet have the BDR extension installed.

The command must be run with a DSN that connects to the Postgres server instance you want to assess. Pass it with the --dsn option or set the PGD_CLI_DSN environment variable. Not providing either results in an error.

The command checks the Postgres instance for compatibility with EDB Postgres Distributed and produces a compatibility report. The number of checks varies by the edition detected on the target instance: standard Postgres and PGD Expanded instances get 11 checks, while PGD Essential instances get 7 (the 4 Expanded-specific checks are omitted).

Syntax

pgd assess [OPTIONS]

Options

The assess command has no command specific options. But it does require a DSN to connect to the Postgres server instance that you want to assess. This can be passed as the argument to the --dsn option, or by setting the PGD_CLI_DSN environment variable.

See also Global Options .

Example

pgd assess
__OUTPUT__
Assessment                           | Result                     | Details
- ------------------------------------+----------------------------+-----------------------------------------------------------
 Multiple Databases                  | Compatible                 | Found only one user database
 Materialized Views                  | Compatible                 | No materialized views found
 EPAS Queue Tables                   | Compatible                 | No EPAS Queue Tables found
 DDL Command Usage                   | Requires workload analysis | Cannot be checked automatically at this time
 Advisory Lock Usage                 | Potentially compatible     | No advisory lock commands found in pg_stat_statements
 Large Objects                       | Compatible                 | No large objects found
 Trigger/Reference Privileges        | Compatible                 | No triggers with incompatible privileges found
 Tables with Multiple Unique Indexes | Compatible                 | No tables with multiple unique indexes found
 LOCK TABLE Usage                    | Potentially compatible     | No LOCK TABLE usage found in pg_stat_statements
 LISTEN/NOTIFY Usage                 | Compatible                 | No LISTEN/NOTIFY usage found in pg_stat_statements
 Row-Level Lock Usage                | Potentially compatible     | No row-level locking commands found in pg_stat_statements