Tribaal Postgresql Built
- By Chris Glass
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 0 | 19 Mar 2021 |
juju deploy tribaal-postgresql-built
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
-
admin_addresses | string
A comma-separated list of IP Addresses (or single IP) admin tools like pgAdmin3 will connect from. The IP addresses added here will be included in the pg_hba.conf file allowing ip connections to all databases on the server from the given IP addresses using md5 password encryption. IP address ranges are also supported, using the standard format described in the PostgreSQL reference guide.
-
advisory_lock_restart_key | int
Default: 765
DEPRECATED AND IGNORED. An advisory lock key used internally by the charm. You do not need to change it unless it happens to conflict with an advisory lock key being used by your applications.
-
archive_command | string
DEPRECATED. Use extra_pg_conf. Command used to archive WAL files when archive_mode is set and wal_level > minimal.
-
archive_mode | boolean
DEPRECATED. Use extra_pg_conf. Enable archiving of WAL files using the command specified by archive_command. If archive_mode is enabled and archive_command not set, then archiving is deferred until archive_command is set and the WAL files will accumulate.
-
autovacuum | boolean
Default: True
DEPRECATED. Use extra_pg_conf. Autovacuum should almost always be running. If you want to turn this off, you are probably following out of date documentation.
-
autovacuum_analyze_scale_factor | float
Default: 0.1
DEPRECATED. Use extra_pg_conf. Fraction of table size before analyze
-
autovacuum_analyze_threshold | int
Default: 50
DEPRECATED. Use extra_pg_conf. min number of row updates before analyze
-
autovacuum_vacuum_cost_delay | string
Default: 20ms
DEPRECATED. Use extra_pg_conf. Default vacuum cost delay for autovacuum, in milliseconds; -1 means use vacuum_cost_delay
-
autovacuum_vacuum_scale_factor | float
Default: 0.2
DEPRECATED. Use extra_pg_conf. Fraction of table size before vacuum
-
aws_access_key_id | string
EXPERIMENTAL. Amazon AWS access key id.
-
aws_secret_access_key | string
EXPERIMENTAL. Amazon AWS secret access key.
-
backup_dir | string
Default: /var/lib/postgresql/backups
Directory to place backups in.
-
backup_retention_count | int
Default: 7
Number of backups to retain.
-
backup_schedule | string
Default: 13 4 * * *
Cron-formatted schedule for regular database backups.
-
checkpoint_completion_target | float
Default: 0.9
DEPRECATED. Use extra_pg_conf. checkpoint target duration time, as a fraction of checkpoint_timeout. Range [0.0, 1.0].
-
checkpoint_segments | int
Default: 10
DEPRECATED. Use extra_pg_conf. in logfile segments, min 1, 16MB each. Ignored unless 'performance_tuning' is set to 'manual'.
-
checkpoint_timeout | string
DEPRECATED. Use extra_pg_conf. Maximum time between automatic WAL checkpoints. range '30s-1h'. If left empty, the default postgresql value will be used.
-
collapse_limit | int
Default: -1
DEPRECATED. Use extra_pg_conf. Sets the from_collapse_limit and join_collapse_limit query planner options, controlling the maximum number of tables that can be joined before the turns off the table collapse query optimization.
-
default_statistics_target | int
Default: -1
DEPRECATED. Use extra_pg_conf. Sets the default statistics target for table columns without a column-specific target set via ALTER TABLE SET STATISTICS. Leave unchanged to use the server default, which in recent releases is 100. Ignored unless 'performance_tuning' is 'manual'. Larger values increase the time needed to do ANALYZE, but might improve the quality of the planner's estimates.
-
effective_cache_size | string
DEPRECATED. Use extra_pg_conf. Effective cache size is an estimate of how much memory is available for disk caching within the database. (50% to 75% of system memory). This string should be of the format '###MB'. Ignored unless 'performance_tuning' is set to 'manual'.
-
encoding | string
Default: UTF-8
Default encoding used to store text in this service. Can only be set when deploying the first unit of a service.
-
extra-packages | string
DEPRECATED. Use extra_packages.
-
extra_packages | string
Space separated list of extra deb packages to install.
-
extra_pg_auth | string
A comma separated extra pg_hba.conf auth rules. This will be written to the pg_hba.conf file, one line per rule. Note that this should not be needed as db relations already create those rules the right way. Only use this if you really need too (e.g. on a development environment), or are connecting juju managed databases to external managed systems, or configuring replication between unrelated PostgreSQL services using the manual_replication option.
-
extra_pg_conf | string
Default: # Additional service specific postgresql.conf settings. listen_addresses='*' ssl=true log_timezone=UTC log_checkpoints=true log_connections=true log_disconnections=true log_autovacuum_min_duration=-1 log_line_prefix='%t [%p]: [%l-1] db=%d,user=%u ' archive_mode=on archive_command='/bin/true' hot_standby=true max_wal_senders=80 # max_wal_senders=num_units * 2 + 5 # wal_level=hot_standby (<9.4) or logical (>=9.4) # shared_buffers=total_ram*0.25 # effective_cache_size=total_ram*0.75 default_statistics_target=250 from_collapse_limit=16 join_collapse_limit=16 wal_buffers=-1 checkpoint_completion_target=0.9 password_encryption=true max_connections=100
postgresql.conf settings, one per line in standard key=value PostgreSQL format. These settings will generally override any values selected by the charm. The charm however will attempt to ensure minimum requirements for the charm's operation are met.
-
fsync | boolean
Default: True
DEPRECATED. Use extra_pg_conf. Turns forced synchronization on/off. If fsync is turned off, database failures are likely to involve database corruption and require recreating the unit
-
full_page_writes | boolean
Default: True
DEPRECATED. Use extra_pg_conf. Recover from partial page writes.
-
hot_standby | boolean
DEPRECATED. Use extra_pg_conf. Hot standby or warm standby. When True, queries can be run against the database when in recovery or standby mode (ie. replicated). Overridden when service contains multiple units.
-
hot_standby_feedback | boolean
DEPRECATED. Use extra_pg_conf. Hot standby feedback, informing a master about in progress transactions on a streaming hot standby and allowing the master to defer cleanup and avoid query cancelations on the hot standby.
-
idle_reap_secs | int
Default: 900
Terminate transactions that have been idle more than this many seconds. While this may seem harsh, in most environments it is preferable to allowing them to create database bloat and hold locks needed by well behaved transactions. Set to 0 to disable.
-
install_keys | string
List of signing keys for install_sources package sources, per charmhelpers standard format (a yaml list of strings encoded as a string). The keys should be the full ASCII armoured GPG public keys. While GPG key ids are also supported and looked up on a keyserver, operators should be aware that this mechanism is insecure. null can be used if a standard package signing key is used that will already be installed on the machine, and for PPA sources where the package signing key is securely retrieved from Launchpad.
-
install_sources | string
List of extra apt sources, per charm-helpers standard format (a yaml list of strings encoded as a string). Each source may be either a line that can be added directly to sources.list(5), or in the form ppa:<user>/<ppa-name> for adding Personal Package Archives, or a distribution component to enable.
-
kernel_shmall | int
DEPRECATED and ignored. Total amount of shared memory available, in bytes.
-
kernel_shmmax | int
DEPRECATED and ignored. The maximum size, in bytes, of a shared memory segment.
-
listen_port | int
Default: -1
DEPRECATED. Use extra_pg_conf. Port to listen on. Default is automatically assigned.
-
locale | string
Default: C
Locale of service, defining language, default collation order, and default formatting of numbers, currency, dates & times. Can only be set when deploying the first unit of a service.
-
log_autovacuum_min_duration | int
Default: -1
DEPRECATED. Use extra_pg_conf. -1 disables, 0 logs all actions and their durations, > 0 logs only actions running at least this number of milliseconds.
-
log_checkpoints | boolean
DEPRECATED. Use extra_pg_conf.
-
log_connections | boolean
DEPRECATED. Use extra_pg_conf.
-
log_disconnections | boolean
DEPRECATED. Use extra_pg_conf.
-
log_line_prefix | string
Default: %t [%p]: [%l-1] db=%d,user=%u
DEPRECATED. Use extra_pg_conf. special values: %a = application name %u = user name %d = database name %r = remote host and port %h = remote host %p = process ID %t = timestamp without milliseconds %m = timestamp with milliseconds %i = command tag %e = SQL state %c = session ID %l = session line number %s = session start timestamp %v = virtual transaction ID %x = transaction ID (0 if none) %q = stop here in non-session processes %% = '%' e.g. '<%u%%%d> '
-
log_lock_waits | boolean
DEPRECATED. Use extra_pg_conf.
-
log_min_duration_statement | int
Default: -1
DEPRECATED. Use extra_pg_conf. -1 is disabled, 0 logs all statements and their durations, > 0 logs only statements running at least this number of milliseconds
-
log_temp_files | string
Default: -1
DEPRECATED. Use extra_pg_conf. Log creation of temporary files larger than the threshold. -1 disables the feature, 0 logs all temporary files, or specify the threshold size with an optional unit (eg. "512KB", default unit is kilobytes).
-
log_timezone | string
Default: UTC
DEPRECATED. Use extra_pg_conf.
-
maintenance_work_mem | string
Default: 1MB
DEPRECATED. Use extra_pg_conf. Maintenance working memory. Ignored unless 'performance_tuning' is set to 'manual'.
-
manual_replication | boolean
Enable or disable charm managed replication. When manual_replication is True, the operator is responsible for maintaining recovery.conf and performing any necessary database mirroring. The charm will still advertise the unit as standalone, master or hot standby to relations based on whether the system is in recovery mode or not. Note that this option makes it possible to create a PostgreSQL service with multiple master units, which is a very silly thing to do unless you are also using multi-master software like BDR.
-
max_connections | int
Default: 100
DEPRECATED. Use extra_pg_conf. Maximum number of connections to allow to the PG database
-
max_prepared_transactions | int
DEPRECATED. Use extra_pg_conf. Maximum number of prepared two phase commit transactions, waiting to be committed. Defaults to 0. as using two phase commit without a process to monitor and resolve lost transactions is dangerous.
-
max_wal_senders | int
DEPRECATED. Use extra_pg_conf. Maximum number of hot standbys that can connect using streaming replication. Set this to the expected maximum number of hot standby units to avoid unnecessary blocking and database restarts. Overridden by juju if necessary.
-
metrics_prefix | string
Default: dev.$UNIT.postgresql
Prefix for metrics. Special value $UNIT can be used to include the name of the unit in the prefix.
-
metrics_sample_interval | int
Default: 5
Period for metrics cron job to run in minutes
-
metrics_target | string
Destination for statsd-format metrics, format "host:port". If not present and valid, metrics disabled.
-
nagios_context | string
Default: juju
Used by the nrpe subordinate charms. A string that will be prepended to instance name to set the host name in nagios. So for instance the hostname would be something like: juju-postgresql-0 If you're running multiple environments with the same services in them this allows you to differentiate between them.
-
nagios_servicegroups | string
A comma-separated list of nagios servicegroups. If left empty, the nagios_context will be used as the servicegroup
-
os_auth_url | string
EXPERIMENTAL. OpenStack Swift authentication URL.
-
os_password | string
EXPERIMENTAL. OpenStack Swift password.
-
os_tenant_name | string
EXPERIMENTAL. OpenStack Swift tenant name.
-
os_username | string
EXPERIMENTAL. OpenStack Swift username.
-
package_status | string
Default: install
The status of service-affecting packages will be set to this value in the dpkg database. Valid values are "install" and "hold".
-
performance_tuning | string
Default: Mixed
DEPRECATED AND IGNORED. The pgtune project has been abandoned and the packages dropped from Debian and Ubuntu. The charm still performs some basic tuning, which users can tweak using extra_pg_config.
-
pgdg | boolean
Enable the PostgreSQL Global Development Group APT repository (https://wiki.postgresql.org/wiki/Apt). This package source provides official PostgreSQL packages for Ubuntu LTS releases beyond those provided by the main Ubuntu archive.
-
random_page_cost | float
Default: 4.0
DEPRECATED. Use extra_pg_conf. Random page cost
-
relation_database_privileges | string
Default: ALL
A comma-separated list of database privileges to grant to relation users on their databases. The defaults allow to connect to the database (CONNECT), create objects such as tables (CREATE), and create temporary tables (TEMPORARY). Client charms that create objects in the database are responsible to granting suitable access on those objects to other roles and users (or PUBLIC) using standard GRANT statements.
-
replicated_wal_keep_segments | int
Default: 5000
DEPRECATED. Use extra_pg_conf. Value of wal_keep_segments used when this service is replicated. This setting only exists to provide a sane default when replication is requested (so it doesn't fail) and nobody bothered to change the wal_keep_segments setting.
-
search_path | string
Default: "$user",public
DEPRECATED. Use extra_pg_conf. Comma separated list of schema names for the default SQL search path.
-
ssl | string
Default: True
DEPRECATED. Use extra_pg_conf. Whether PostgreSQL should talk SSL
-
standard_conforming_strings | boolean
Default: True
DEPRECATED. Use extra_pg_conf. Standard conforming strings
-
streaming_replication | boolean
Default: True
Enable streaming replication. Normally, streaming replication is always used, and any log shipping configured is used as a fallback. Turning this off without configuring log shipping is an error.
-
synchronous_commit | boolean
Default: True
DEPRECATED. Use extra_pg_conf. Immediate fsync after commit.
-
temp_buffers | string
Default: 1MB
DEPRECATED. Use extra_pg_conf. The maximum number of temporary buffers used by each database session.
-
version | string
Version of PostgreSQL that we want to install. Supported versions are "9.1", "9.2", "9.3", "9.4" & "9.5". The default version for the deployed Ubuntu release is used when the version is unspecified.
-
wabs_access_key | string
EXPERIMENTAL. Windows Azure access key.
-
wabs_account_name | string
EXPERIMENTAL. Windows Azure account name.
-
wal_buffers | string
Default: -1
DEPRECATED. Use extra_pg_conf. min 32kB, -1 sets based on shared_buffers (change requires restart). Ignored unless 'performance_tuning' is set to 'manual'.
-
wal_e_backup_retention | int
Default: 2
EXPERIMENTAL. Number of recent base backups and WAL files to retain. You need enough space for this many backups plus one more, as an old backup will only be removed after a new one has been successfully made to replace it.
-
wal_e_backup_schedule | string
Default: 13 0 * * *
EXPERIMENTAL. Cron-formatted schedule for WAL-E database backups. If wal_e_backup_schedule is unset, WAL files will never be removed from WAL-E storage.
-
wal_e_storage_uri | string
EXPERIMENTAL. Specify storage to be used by WAL-E. Every PostgreSQL service must use a unique URI. Backups will be unrecoverable if it is not unique. The URI's scheme must be one of 'swift' (OpenStack Swift), 's3' (Amazon AWS) or 'wabs' (Windows Azure). For example: 'swift://some-container/directory/or/whatever' 's3://some-bucket/directory/or/whatever' 'wabs://some-bucket/directory/or/whatever' Setting the wal_e_storage_uri enables regular WAL-E filesystem level backups (per wal_e_backup_schedule), and log shipping to the configured storage. Point-in-time recovery becomes possible, as is disabling the streaming_replication configuration item and relying solely on log shipping for replication.
-
wal_keep_segments | int
DEPRECATED. Use extra_pg_conf. Number of old WAL files to keep, providing a larger buffer for streaming hot standbys to catch up from when lagged. Each WAL file is 16MB in size. The WAL files are the buffer of how far a hot standby can lag behind the master, and replication fails if this buffer is overrun. When this service is replicated, the larger value of wal_keep_segments and replicated_wal_keep_segments is used.
-
wal_level | string
Default: minimal
DEPRECATED. Use extra_pg_conf. 'minimal', 'archive', 'hot_standby' or 'logical'. Defines how much information is written to the WAL. Set to 'minimal' for stand alone databases and 'hot_standby' for replicated setups. Overridden by juju when replication is used.
-
work_mem | string
Default: 1MB
DEPRECATED. Use extra_pg_conf. Working Memory. Ignored unless 'performance_tuning' is set to 'manual'.