Charmed PostgreSQL K8s

Channel Revision Published Runs on
latest/stable 20 20 Sep 2022
Ubuntu 20.04
14/stable 193 13 Mar 2024
Ubuntu 22.04
14/candidate 248 04 May 2024
Ubuntu 22.04
14/candidate 247 03 May 2024
Ubuntu 22.04
14/beta 278 14 Jun 2024
Ubuntu 22.04
14/beta 248 04 May 2024
Ubuntu 22.04
14/edge 278 13 Jun 2024
Ubuntu 22.04
14/edge 277 13 Jun 2024
Ubuntu 22.04
juju deploy postgresql-k8s --channel 14/stable
Show information

Platform:

Learn about configurations >

  • durability_synchronous_commit | string

    Default: on

    Sets the current transactions synchronization level. This charm allows only the “on”, “remote_apply” and “remote_write” values to avoid data loss if the primary crashes and there are replicas.

  • instance_default_text_search_config | string

    Default: pg_catalog.simple

    Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. Allowed values start with “pg_catalog.” followed by a language name, like “pg_catalog.english”.

  • instance_password_encryption | string

    Default: scram-sha-256

    Determines the algorithm to use to encrypt the password. Allowed values are: “md5” and “scram-sha-256”.

  • logging_log_connections | boolean

    Logs each successful connection.

  • logging_log_disconnections | boolean

    Logs end of a session, including duration.

  • logging_log_lock_waits | boolean

    Logs long lock waits.

  • logging_log_min_duration_statement | int

    Default: -1

    Sets the minimum running time (milliseconds) above which statements will be logged. Allowed values are: from -1 to 2147483647 (-1 disables logging statement durations).

  • memory_maintenance_work_mem | int

    Default: 65536

    Sets the maximum memory (KB) to be used for maintenance operations. Allowed values are: from 1024 to 2147483647.

  • memory_max_prepared_transactions | int

    Sets the maximum number of simultaneously prepared transactions. Allowed values are: from 0 to 262143.

  • memory_shared_buffers | int

    Sets the number of shared memory buffers (8 kB) used by the server. This charm allows to set this value up to 40% of the available memory from the unit, as it is unlikely that an allocation of more than that will work better than a smaller amount. Allowed values are: from 16 to 1073741823.

  • memory_temp_buffers | int

    Default: 1024

    Sets the maximum number of temporary buffers (8 kB) used by each session. Allowed values are: from 100 to 1073741823.

  • memory_work_mem | int

    Default: 4096

    Sets the maximum memory (KB) to be used for query workspaces. Allowed values are: from 64 to 2147483647.

  • optimizer_constraint_exclusion | string

    Default: partition

    Enables the planner to use constraints to optimize queries. Allowed values are: “on”, “off” and “partition”.

  • optimizer_default_statistics_target | int

    Default: 100

    Sets the default statistics target. Allowed values are: from 1 to 10000.

  • optimizer_from_collapse_limit | int

    Default: 8

    Sets the FROM-list size beyond which subqueries are not collapsed. Allowed values are: from 1 to 2147483647.

  • optimizer_join_collapse_limit | int

    Default: 8

    Sets the FROM-list size beyond which JOIN constructs are not flattened. Allowed values are: from 1 to 2147483647.

  • plugin_address_standardizer_data_us_enable | boolean

    Enable address_standardizer_data_us extension.

  • plugin_address_standardizer_enable | boolean

    Enable address_standardizer extension.

  • plugin_bloom_enable | boolean

    Enable bloom extension.

  • plugin_bool_plperl_enable | boolean

    Enable bool_plperl extension.

  • plugin_btree_gin_enable | boolean

    Enable btree_gin extension.

  • plugin_btree_gist_enable | boolean

    Enable btree_gist extension.

  • plugin_citext_enable | boolean

    Enable citext extension.

  • plugin_cube_enable | boolean

    Enable cube extension.

  • plugin_debversion_enable | boolean

    Enable debversion extension.

  • plugin_dict_int_enable | boolean

    Enable dict_int extension.

  • plugin_dict_xsyn_enable | boolean

    Enable dict_xsyn extension.

  • plugin_earthdistance_enable | boolean

    Enable earthdistance extension.

  • plugin_fuzzystrmatch_enable | boolean

    Enable fuzzystrmatch extension.

  • plugin_hll_enable | boolean

    Enable hll extension.

  • plugin_hstore_enable | boolean

    Enable hstore extension.

  • plugin_hypopg_enable | boolean

    Enable hypopg extension.

  • plugin_icu_ext_enable | boolean

    Enable icu_ext extension.

  • plugin_intarray_enable | boolean

    Enable intarray extension.

  • plugin_ip4r_enable | boolean

    Enable ip4r extension.

  • plugin_isn_enable | boolean

    Enable isn extension.

  • plugin_jsonb_plperl_enable | boolean

    Enable jsonb_plperl extension.

  • plugin_lo_enable | boolean

    Enable lo extension.

  • plugin_ltree_enable | boolean

    Enable ltree extension.

  • plugin_old_snapshot_enable | boolean

    Enable old_snapshot extension.

  • plugin_orafce_enable | boolean

    Enable orafce extension.

  • plugin_pg_freespacemap_enable | boolean

    Enable pg_freespacemap extension.

  • plugin_pg_similarity_enable | boolean

    Enable pg_similarity extension.

  • plugin_pg_trgm_enable | boolean

    Enable pg_trgm extension.

  • plugin_pg_visibility_enable | boolean

    Enable pg_visibility extension.

  • plugin_pgrowlocks_enable | boolean

    Enable pgrowlocks extension.

  • plugin_pgstattuple_enable | boolean

    Enable pgstattuple extension.

  • plugin_plperl_enable | boolean

    Enable plperl extension.

  • plugin_plpython3u_enable | boolean

    Enable PL/Python extension.

  • plugin_pltcl_enable | boolean

    Enable pltcl extension.

  • plugin_postgis_enable | boolean

    Enable postgis extension.

  • plugin_postgis_raster_enable | boolean

    Enable postgis_raster extension.

  • plugin_postgis_tiger_geocoder_enable | boolean

    Enable postgis_tiger_geocoder extension.

  • plugin_postgis_topology_enable | boolean

    Enable postgis_topology extension.

  • plugin_prefix_enable | boolean

    Enable prefix extension.

  • plugin_rdkit_enable | boolean

    Enable rdkit extension.

  • plugin_seg_enable | boolean

    Enable seg extension.

  • plugin_spi_enable | boolean

    Enable spi extension.

  • plugin_tablefunc_enable | boolean

    Enable tablefunc extension.

  • plugin_tcn_enable | boolean

    Enable tcn extension.

  • plugin_tds_fdw_enable | boolean

    Enable tds_fdw extension.

  • plugin_tsm_system_rows_enable | boolean

    Enable tsm_system_rows extension.

  • plugin_tsm_system_time_enable | boolean

    Enable tsm_system_time extension.

  • plugin_unaccent_enable | boolean

    Enable unaccent extension.

  • plugin_uuid_ossp_enable | boolean

    Enable uuid_ossp extension.

  • plugin_vector_enable | boolean

    Enable pgvector extension

  • profile | string

    Default: production

    Profile representing the scope of deployment, and used to tune resource allocation. Allowed values are: “production” and “testing”. Production will tune postgresql for maximum performance while testing will tune for minimal running performance.

  • profile-limit-memory | int

    [DEPRECTATED] Use profile_limit_memory instead. Amount of memory in Megabytes to limit PostgreSQL and associated process to. If unset, this will be decided according to the default memory limit in the selected profile. Only comes into effect when the `production` profile is selected. This config option cannot be set at the same time as profile_limit_memory.

  • profile_limit_memory | int

    Amount of memory in Megabytes to limit PostgreSQL and associated process to. If unset, this will be decided according to the default memory limit in the selected profile. Only comes into effect when the `production` profile is selected. This config option cannot be set at the same time as profile-limit-memory.

  • request_date_style | string

    Default: ISO, MDY

    Sets the display format for date and time values. Allowed formats are explained in https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DATESTYLE.

  • request_standard_conforming_strings | boolean

    Default: True

    Causes ... strings to treat backslashes literally.

  • request_time_zone | string

    Default: UTC

    Sets the time zone for displaying and interpreting time stamps. Allowed values are the ones from IANA time zone data, a time zone abbreviation like PST and POSIX-style time zone specifications.

  • response_bytea_output | string

    Default: hex

    Sets the output format for bytes. Allowed values are: “escape” and “hex”.

  • response_lc_monetary | string

    Default: C

    Sets the locale for formatting monetary amounts. Allowed values are the locales available in the unit.

  • response_lc_numeric | string

    Default: C

    Sets the locale for formatting numbers. Allowed values are the locales available in the unit.

  • response_lc_time | string

    Default: C

    Sets the locale for formatting date and time values. Allowed values are the locales available in the unit.

  • vacuum_autovacuum_analyze_scale_factor | float

    Default: 0.1

    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.1, means 10% of table size. Allowed values are: from 0 to 100.

  • vacuum_autovacuum_analyze_threshold | int

    Default: 50

    Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. Allowed values are: from 0 to 2147483647.

  • vacuum_autovacuum_freeze_max_age | int

    Default: 200000000

    Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. Allowed values are: from 100000 to 2000000000.

  • vacuum_autovacuum_vacuum_cost_delay | float

    Default: 2.0

    Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. Allowed values are: from -1 to 100 (-1 tells PostgreSQL to use the regular vacuum_cost_delay value).

  • vacuum_autovacuum_vacuum_scale_factor | float

    Default: 0.2

    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default, 0.2, means 20% of table size. Allowed values are: from 0 to 100.

  • vacuum_vacuum_freeze_table_age | int

    Default: 150000000

    Age (in transactions) at which VACUUM should scan whole table to freeze tuples. Allowed values are: from 0 to 2000000000.