Types
/software/postgresql/postgresql_hba_database
/software/postgresql/postgresql_hba_user
/software/postgresql/postgresql_hba
/software/postgresql/postgresql_hba/host
- required
- type: string
/software/postgresql/postgresql_hba/database
- required
- type: postgresql_hba_database
/software/postgresql/postgresql_hba/user
- required
- type: postgresql_hba_user
/software/postgresql/postgresql_hba/address
- optional
- type: string
/software/postgresql/postgresql_hba/method
- required
- type: string
/software/postgresql/postgresql_hba/options
- optional
- type: string
-
/software/postgresql/postgresql_mainconfig
-
decription: postgresql main configuration boolean -> yes / no int -> int string -> 'string' (use double single quotes for a single quote in the string)
-
/software/postgresql/postgresql_mainconfig/archive_command
- optional
- type: string
/software/postgresql/postgresql_mainconfig/archive_mode
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/archive_timeout
- optional
- type: long
/software/postgresql/postgresql_mainconfig/array_nulls
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/authentication_timeout
- optional
- type: string
/software/postgresql/postgresql_mainconfig/autovacuum
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/autovacuum_analyze_scale_factor
- optional
- type: string
/software/postgresql/postgresql_mainconfig/autovacuum_analyze_threshold
- optional
- type: long
/software/postgresql/postgresql_mainconfig/autovacuum_freeze_max_age
- optional
- type: long
/software/postgresql/postgresql_mainconfig/autovacuum_max_workers
- optional
- type: long
/software/postgresql/postgresql_mainconfig/autovacuum_naptime
- optional
- type: string
/software/postgresql/postgresql_mainconfig/autovacuum_vacuum_cost_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/autovacuum_vacuum_cost_limit
- optional
- type: long
/software/postgresql/postgresql_mainconfig/autovacuum_vacuum_scale_factor
- optional
- type: string
/software/postgresql/postgresql_mainconfig/autovacuum_vacuum_threshold
- optional
- type: long
/software/postgresql/postgresql_mainconfig/backslash_quote
- optional
- type: string
/software/postgresql/postgresql_mainconfig/bgwriter_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/bgwriter_lru_maxpages
- optional
- type: long
/software/postgresql/postgresql_mainconfig/bgwriter_lru_multiplier
- optional
- type: string
/software/postgresql/postgresql_mainconfig/bonjour
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/bonjour_name
- optional
- type: string
/software/postgresql/postgresql_mainconfig/bytea_output
- optional
- type: string
/software/postgresql/postgresql_mainconfig/check_function_bodies
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/checkpoint_completion_target
- optional
- type: string
/software/postgresql/postgresql_mainconfig/checkpoint_segments
- optional
- type: long
/software/postgresql/postgresql_mainconfig/checkpoint_timeout
- optional
- type: string
/software/postgresql/postgresql_mainconfig/checkpoint_warning
- optional
- type: string
/software/postgresql/postgresql_mainconfig/client_encoding
- optional
- type: string
/software/postgresql/postgresql_mainconfig/client_min_messages
- optional
- type: string
/software/postgresql/postgresql_mainconfig/commit_delay
- optional
- type: long
/software/postgresql/postgresql_mainconfig/commit_siblings
- optional
- type: long
/software/postgresql/postgresql_mainconfig/constraint_exclusion
- optional
- type: string
/software/postgresql/postgresql_mainconfig/cpu_index_tuple_cost
- optional
- type: string
/software/postgresql/postgresql_mainconfig/cpu_operator_cost
- optional
- type: string
/software/postgresql/postgresql_mainconfig/cpu_tuple_cost
- optional
- type: string
/software/postgresql/postgresql_mainconfig/cursor_tuple_fraction
- optional
- type: string
/software/postgresql/postgresql_mainconfig/custom_variable_classes
- optional
- type: string
/software/postgresql/postgresql_mainconfig/data_directory
- optional
- type: string
/software/postgresql/postgresql_mainconfig/datestyle
- optional
- type: string
/software/postgresql/postgresql_mainconfig/db_user_namespace
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/deadlock_timeout
- optional
- type: string
/software/postgresql/postgresql_mainconfig/debug_pretty_print
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/debug_print_parse
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/debug_print_plan
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/debug_print_rewritten
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/default_statistics_target
- optional
- type: long
/software/postgresql/postgresql_mainconfig/default_tablespace
- optional
- type: string
/software/postgresql/postgresql_mainconfig/default_text_search_config
- optional
- type: string
/software/postgresql/postgresql_mainconfig/default_transaction_deferrable
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/default_transaction_isolation
- optional
- type: string
/software/postgresql/postgresql_mainconfig/default_transaction_read_only
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/default_with_oids
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/dynamic_library_path
- optional
- type: string
/software/postgresql/postgresql_mainconfig/effective_cache_size
- optional
- type: string
/software/postgresql/postgresql_mainconfig/effective_io_concurrency
- optional
- type: long
/software/postgresql/postgresql_mainconfig/enable_bitmapscan
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_hashagg
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_hashjoin
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_indexscan
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_material
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_mergejoin
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_nestloop
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_seqscan
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_sort
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/enable_tidscan
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/escape_string_warning
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/exit_on_error
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/external_pid_file
- optional
- type: string
/software/postgresql/postgresql_mainconfig/extra_float_digits
- optional
- type: long
/software/postgresql/postgresql_mainconfig/from_collapse_limit
- optional
- type: long
/software/postgresql/postgresql_mainconfig/fsync
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/full_page_writes
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/geqo
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/geqo_effort
- optional
- type: long
/software/postgresql/postgresql_mainconfig/geqo_generations
- optional
- type: long
/software/postgresql/postgresql_mainconfig/geqo_pool_size
- optional
- type: long
/software/postgresql/postgresql_mainconfig/geqo_seed
- optional
- type: string
/software/postgresql/postgresql_mainconfig/geqo_selection_bias
- optional
- type: string
/software/postgresql/postgresql_mainconfig/geqo_threshold
- optional
- type: long
/software/postgresql/postgresql_mainconfig/hba_file
- optional
- type: string
/software/postgresql/postgresql_mainconfig/hot_standby
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/hot_standby_feedback
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/ident_file
- optional
- type: string
/software/postgresql/postgresql_mainconfig/intervalstyle
- optional
- type: string
/software/postgresql/postgresql_mainconfig/join_collapse_limit
- optional
- type: long
/software/postgresql/postgresql_mainconfig/krb_caseins_users
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/krb_server_keyfile
- optional
- type: string
/software/postgresql/postgresql_mainconfig/krb_srvname
- optional
- type: string
/software/postgresql/postgresql_mainconfig/lc_messages
- optional
- type: string
/software/postgresql/postgresql_mainconfig/lc_monetary
- optional
- type: string
/software/postgresql/postgresql_mainconfig/lc_numeric
- optional
- type: string
/software/postgresql/postgresql_mainconfig/lc_time
- optional
- type: string
/software/postgresql/postgresql_mainconfig/listen_addresses
- optional
- type: string
/software/postgresql/postgresql_mainconfig/lo_compat_privileges
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/local_preload_libraries
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_autovacuum_min_duration
- optional
- type: long
/software/postgresql/postgresql_mainconfig/log_checkpoints
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_connections
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_destination
- required
- type: string
/software/postgresql/postgresql_mainconfig/log_directory
- required
- type: string
/software/postgresql/postgresql_mainconfig/log_disconnections
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_duration
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_error_verbosity
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_executor_stats
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_file_mode
- optional
- type: long
/software/postgresql/postgresql_mainconfig/log_filename
- required
- type: string
/software/postgresql/postgresql_mainconfig/log_hostname
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_line_prefix
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_lock_waits
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_min_duration_statement
- optional
- type: long
/software/postgresql/postgresql_mainconfig/log_min_error_statement
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_min_messages
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_parser_stats
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_planner_stats
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_rotation_age
- required
- type: string
/software/postgresql/postgresql_mainconfig/log_rotation_size
- required
- type: long
/software/postgresql/postgresql_mainconfig/log_statement
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_statement_stats
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/log_temp_files
- optional
- type: long
/software/postgresql/postgresql_mainconfig/log_timezone
- optional
- type: string
/software/postgresql/postgresql_mainconfig/log_truncate_on_rotation
- required
- type: boolean
/software/postgresql/postgresql_mainconfig/logging_collector
- required
- type: boolean
/software/postgresql/postgresql_mainconfig/maintenance_work_mem
- optional
- type: string
/software/postgresql/postgresql_mainconfig/max_connections
- optional
- type: long
/software/postgresql/postgresql_mainconfig/max_files_per_process
- optional
- type: long
/software/postgresql/postgresql_mainconfig/max_locks_per_transaction
- optional
- type: long
/software/postgresql/postgresql_mainconfig/max_pred_locks_per_transaction
- optional
- type: long
/software/postgresql/postgresql_mainconfig/max_prepared_transactions
- optional
- type: long
/software/postgresql/postgresql_mainconfig/max_stack_depth
- optional
- type: string
/software/postgresql/postgresql_mainconfig/max_standby_archive_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/max_standby_streaming_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/max_wal_senders
- optional
- type: long
/software/postgresql/postgresql_mainconfig/password_encryption
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/port
- optional
- type: long
/software/postgresql/postgresql_mainconfig/quote_all_identifiers
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/random_page_cost
- optional
- type: string
/software/postgresql/postgresql_mainconfig/replication_timeout
- optional
- type: string
/software/postgresql/postgresql_mainconfig/restart_after_crash
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/search_path
- optional
- type: string
/software/postgresql/postgresql_mainconfig/seq_page_cost
- optional
- type: string
/software/postgresql/postgresql_mainconfig/session_replication_role
- optional
- type: string
/software/postgresql/postgresql_mainconfig/shared_buffers
- optional
- type: string
/software/postgresql/postgresql_mainconfig/shared_preload_libraries
- optional
- type: string
/software/postgresql/postgresql_mainconfig/silent_mode
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/sql_inheritance
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/ssl
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/ssl_ciphers
- optional
- type: string
/software/postgresql/postgresql_mainconfig/ssl_renegotiation_limit
- optional
- type: string
/software/postgresql/postgresql_mainconfig/standard_conforming_strings
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/statement_timeout
- optional
- type: long
/software/postgresql/postgresql_mainconfig/stats_temp_directory
- optional
- type: string
/software/postgresql/postgresql_mainconfig/superuser_reserved_connections
- optional
- type: long
/software/postgresql/postgresql_mainconfig/synchronize_seqscans
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/synchronous_commit
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/synchronous_standby_names
- optional
- type: string
/software/postgresql/postgresql_mainconfig/syslog_facility
- optional
- type: string
/software/postgresql/postgresql_mainconfig/syslog_ident
- optional
- type: string
/software/postgresql/postgresql_mainconfig/tcp_keepalives_count
- optional
- type: long
/software/postgresql/postgresql_mainconfig/tcp_keepalives_idle
- optional
- type: long
/software/postgresql/postgresql_mainconfig/tcp_keepalives_interval
- optional
- type: long
/software/postgresql/postgresql_mainconfig/temp_buffers
- optional
- type: string
/software/postgresql/postgresql_mainconfig/temp_tablespaces
- optional
- type: string
/software/postgresql/postgresql_mainconfig/timezone
- optional
- type: string
/software/postgresql/postgresql_mainconfig/timezone_abbreviations
- optional
- type: string
/software/postgresql/postgresql_mainconfig/track_activities
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/track_activity_query_size
- optional
- type: long
/software/postgresql/postgresql_mainconfig/track_counts
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/track_functions
- optional
- type: string
/software/postgresql/postgresql_mainconfig/transform_null_equals
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/unix_socket_directory
- optional
- type: string
/software/postgresql/postgresql_mainconfig/unix_socket_group
- optional
- type: string
/software/postgresql/postgresql_mainconfig/unix_socket_permissions
- optional
- type: long
/software/postgresql/postgresql_mainconfig/update_process_title
- optional
- type: boolean
/software/postgresql/postgresql_mainconfig/vacuum_cost_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/vacuum_cost_limit
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_cost_page_dirty
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_cost_page_hit
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_cost_page_miss
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_defer_cleanup_age
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_freeze_min_age
- optional
- type: long
/software/postgresql/postgresql_mainconfig/vacuum_freeze_table_age
- optional
- type: long
/software/postgresql/postgresql_mainconfig/wal_buffers
- optional
- type: long
/software/postgresql/postgresql_mainconfig/wal_keep_segments
- optional
- type: long
/software/postgresql/postgresql_mainconfig/wal_level
- optional
- type: string
/software/postgresql/postgresql_mainconfig/wal_receiver_status_interval
- optional
- type: string
/software/postgresql/postgresql_mainconfig/wal_sender_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/wal_sync_method
- optional
- type: string
/software/postgresql/postgresql_mainconfig/wal_writer_delay
- optional
- type: string
/software/postgresql/postgresql_mainconfig/work_mem
- optional
- type: string
/software/postgresql/postgresql_mainconfig/xmlbinary
- optional
- type: string
/software/postgresql/postgresql_mainconfig/xmloption
- optional
- type: string
/software/postgresql/postgresql_db
- decription: this file is used to initialise the database (using the pgsql -f option)
- decription: sets the pg language for the db (using createlang), this runs after installfile.
- decription: this file is used to add procedures in certain lang (using pgsql -f option), this runs after successful lang is added
- decription: apply the installfile with this user (if not defined, the owner is used)
- decription: database owner
/software/postgresql/postgresql_db/installfile
- optional
- type: string
/software/postgresql/postgresql_db/lang
- optional
- type: string
/software/postgresql/postgresql_db/langfile
- optional
- type: string
/software/postgresql/postgresql_db/sql_user
- optional
- type: string
/software/postgresql/postgresql_db/user
- required
- type: string
/software/postgresql/postgresql_config
/software/postgresql/postgresql_config/hba
- optional
- type: postgresql_hba
/software/postgresql/postgresql_config/main
- optional
- type: postgresql_mainconfig
/software/postgresql/postgresql_config/debug_print
- optional
- type: long
/software/postgresql/postgresql_role_sql
- decription: The raw ALTER ROLE sql (cannot contain a ';'; use ENCRYPTED PASSWORD instead)
-
-
/software/postgresql/component_postgresql
- decription: Databases are only added/created, never updated, modified or removed.
- decription: role name with ROLE ALTER SQL command. Roles are only added and updated, never removed.
/software/postgresql/component_postgresql/commands
- optional
- type: string
/software/postgresql/component_postgresql/config
- optional
- type: postgresql_config
/software/postgresql/component_postgresql/databases
- optional
- type: postgresql_db
/software/postgresql/component_postgresql/pg_dir
- optional
- type: string
/software/postgresql/component_postgresql/pg_engine
- optional
- type: string
/software/postgresql/component_postgresql/pg_hba
- optional
- type: string
/software/postgresql/component_postgresql/pg_port
- optional
- type: string
/software/postgresql/component_postgresql/pg_script_name
- optional
- type: string
/software/postgresql/component_postgresql/pg_version
- optional
- type: string
/software/postgresql/component_postgresql/postgresql_conf
- optional
- type: string
/software/postgresql/component_postgresql/roles
- optional
- type: postgresql_role_sql
Functions
- postgresql_is_hba_db
- postgresql_is_hba_address