Charm Demo Postgresql
- By Demo Charms
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 1 | 18 Mar 2021 | |
latest/edge | 1 | 18 Mar 2021 |
juju deploy charm-demo-postgresql
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, this is most useful for developers running juju in local mode who need to connect tools like pgAdmin to a postgres. 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 using md5 password encryption.
-
advisory_lock_restart_key | int
Default: 765
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
Command used to archive WAL files when archive_mode is set and wal_level > minimal.
-
archive_mode | boolean
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
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
Fraction of table size before analyze
-
autovacuum_analyze_threshold | int
Default: 50
min number of row updates before analyze
-
autovacuum_vacuum_cost_delay | string
Default: 20ms
Default vacuum cost delay for autovacuum, in milliseconds; -1 means use vacuum_cost_delay
-
autovacuum_vacuum_scale_factor | float
Default: 0.2
Fraction of table size before vacuum
-
backup_dir | string
Default: /var/lib/postgresql/backups
Directory to place backups in
-
backup_retention_count | int
Default: 7
Number of recent backups to retain.
-
backup_schedule | string
Default: 13 4 * * *
Cron-formatted schedule for database backups.
-
checkpoint_segments | int
Default: 3
in logfile segments, min 1, 16MB each. Ignored unless 'performance_tuning' is set to 'manual'.
-
checkpoint_timeout | string
Maximum time between automatic WAL checkpoints. range '30s-1h'. If left empty, the default postgresql value will be used.
-
cluster_name | string
Default: main
Name of the cluster we want to install the DBs into
-
config_change_command | string
Default: reload
The command to run whenever config has changed. Accepted values are "reload" or "restart" - any other value will mean neither is executed after a config change (which may be desired, if you're running a production server and would rather handle these out of band). Note that postgresql will still need to be reloaded whenever authentication and access details are updated, so disabling either doesn't mean PostgreSQL will never be reloaded.
-
dumpfile_location | string
Default: None
Path to a dumpfile to load into DB when service is initiated.
-
effective_cache_size | string
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
Extra packages to install on the postgresql service units.
-
extra_archives | string
DEPRECATED & IGNORED. Use install_sources and install_keys.
-
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)
-
fsync | boolean
Default: True
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
Recover from partial page writes.
-
hot_standby | boolean
Hot standby or warm standby. When True, queries can be run against the database when in recovery or standby mode (ie. replicated). Overridden by juju when master/slave relations are used.
-
hot_standby_feedback | boolean
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.
-
install_keys | string
List of signing keys for install_sources package sources, per charmhelpers standard. YAML format.
-
install_sources | string
List of extra package sources, per charm-helpers standard. YAML format.
-
kernel_shmall | int
Total amount of shared memory available, in bytes.
-
kernel_shmmax | int
The maximum size, in bytes, of a shared memory segment.
-
listen_ip | string
Default: *
IP to listen on
-
listen_port | int
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
-1 disables, 0 logs all actions and their durations, > 0 logs only actions running at least this number of milliseconds.
-
log_checkpoints | boolean
Log checkpoints
-
log_connections | boolean
Log connections
-
log_disconnections | boolean
Log disconnections
-
log_line_prefix | string
Default: %t [%p]: [%l-1] db=%d,user=%u
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
log lock waits >= deadlock_timeout
-
log_min_duration_statement | int
Default: -1
-1 is disabled, 0 logs all statements and their durations, > 0 logs only statements running at least this number of milliseconds
-
log_timezone | string
Default: UTC
Log timezone
-
maintenance_work_mem | string
Default: 1MB
Maintenance working memory. Ignored unless 'performance_tuning' is set to 'manual'.
-
max_connections | int
Default: 100
Maximum number of connections to allow to the PG database
-
max_wal_senders | int
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.
-
nagios_context | string
Default: juju
Used by the nrpe-external-master subordinate charm. 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.
-
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. Useful valid values are "install" and "hold".
-
performance_tuning | string
Default: Mixed
Possible values here are "manual", "DW" (data warehouse), "OLTP" (online transaction processing), "Web" (web application), "Desktop" or "Mixed". When this is set to a value other than "manual", the charm invokes the pgtune tool to tune a number of performance parameters based on the specified load type. pgtune gathers information about the node on which you are deployed and tries to make intelligent guesses about what tuning parameters to set based on available RAM and CPU under the assumption that it's the only significant service running on this node.
-
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
Random page cost
-
replicated_wal_keep_segments | int
Default: 5000
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
Comma separated list of schema names for the default SQL search path.
-
ssl | string
Default: True
Whether PostgreSQL should talk SSL
-
standard_conforming_strings | boolean
Default: True
Standard conforming strings
-
streaming_replication | boolean
Default: True
EXPERIMENTAL. 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.
-
swiftwal_backup_retention | int
Default: 2
EXPERIMENTAL. Number of recent base backups to retain. You need enough space in Swift 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.
-
swiftwal_backup_schedule | string
EXPERIMENTAL. Cron-formatted schedule for SwiftWAL database backups.
-
swiftwal_container_prefix | string
EXPERIMENTAL. Swift container prefix for SwiftWAL to use. Must be set if any SwiftWAL features are enabled.
-
swiftwal_log_shipping | boolean
EXPERIMENTAL. Archive WAL files into Swift. If swiftwal_backup_schedule is set, this allows point-in-time recovery and WAL files are removed automatically with old backups. If swiftwal_backup_schedule is not set then WAL files are never removed. Enabling this option will override the archive_mode and archive_command settings.
-
synchronous_commit | boolean
Default: True
Immediate fsync after commit.
-
temp_buffers | string
Default: 1MB
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". The default version for the deployed Ubuntu release is used when the version is not specified.
-
wal_buffers | string
Default: -1
min 32kB, -1 sets based on shared_buffers (change requires restart). Ignored unless 'performance_tuning' is set to 'manual'.
-
wal_keep_segments | int
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
'minimal', 'archive' or 'hot_standby'. 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 s used.
-
work_mem | string
Default: 1MB
Working Memory. Ignored unless 'performance_tuning' is set to 'manual'.