Oracle Cloud Infrastructure Documentation

Listing OCI Database with PostgreSQL Configurations

View a list of the OCI Database with PostgreSQL database system configurations.

    1. Open the navigation menu  and select Databases. Under PostgreSQL, select Configurations.
      The Configurations list page opens. All configurations in the selected compartment are displayed in a table.
    2. To view the configurations in a different compartment, use the Compartment filter to switch compartments.

      You must have permission to work in a compartment to see the resources in it. If you're not sure which compartment to use, contact an administrator. For more information, see Understanding Compartments.

    Filtering List Results

    Use filters to limit the configurations in the list. Perform one of the following actions depending on the options that you see:

    • From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that aren't shown in the table. The Compartment filter is always displayed next to Applied filters.
    • On the left side of the list page, select a value from one of the available filters, such as compartment, state, or tags.

    Change the order of the items in the list table by using the sort icons next to the column names.

    For information about searching for resources and managing the columns in the list table, if those features are available, see Listing Resources.

    Actions

    In the list table, select the name of a configuration to open its details page, where you can view its status and perform other tasks.

    To perform an action on a configuration directly from the list table, select an available option from the Actions menu in the row for that configuration:

    To create a configuration, select Create configuration.

  • Use the oci psql default-configuration-collection list-default-configurations command and required parameters to list default configurations:

    oci psql default-configuration-collection list-default-configurations --compartment-id <compartment_ocid> [OPTIONS]

    Use the oci psql configuration-collection list-configurations command and required parameters to list custom configurations:

    oci psql configuration-collection list-configurations [OPTIONS]

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the ListDefaultConfigurations operation to list default configurations run the ListConfigurations operation to list custom configurations.