(* Module: Test_Postgresql Provides unit tests and examples for the <Postgresql> lens. *) module Test_Postgresql = (* "=" separator is optional *) let missing_equal = "fsync on\n" test Postgresql.lns get missing_equal = { "fsync" = "on" } test Postgresql.lns put missing_equal after set "fsync" "off" = "fsync off\n" (* extra whitespace is valid anywhere *) let extra_whitespace = " fsync = on # trailing comment \n" test Postgresql.lns get extra_whitespace = { "fsync" = "on" { "#comment" = "trailing comment" } } test Postgresql.lns put extra_whitespace after set "fsync" "off" = " fsync = off # trailing comment \n" (* no whitespace at all is also valid *) let no_whitespace = "fsync=on\n" test Postgresql.lns get no_whitespace = { "fsync" = "on" } test Postgresql.lns put no_whitespace after set "fsync" "off" = "fsync=off\n" (* Some settings specify a memory or time value. [...] Valid memory units are kB (kilobytes), MB (megabytes), and GB (gigabytes); valid time units are ms (milliseconds), s (seconds), min (minutes), h (hours), and d (days). *) let numeric_suffix_quotes = "shared_buffers = 24MB archive_timeout = 2min deadlock_timeout = '1s' " test Postgresql.lns get numeric_suffix_quotes = { "shared_buffers" = "24MB" } { "archive_timeout" = "2min" } { "deadlock_timeout" = "1s" } test Postgresql.lns put numeric_suffix_quotes after set "deadlock_timeout" "2s"; set "max_stack_depth" "2MB"; set "shared_buffers" "48MB" = "shared_buffers = 48MB archive_timeout = 2min deadlock_timeout = '2s' max_stack_depth = '2MB' " (* floats and ints can be single quoted or not *) let float_quotes = "seq_page_cost = 2.0 random_page_cost = '4.0' vacuum_freeze_min_age = 50000000 vacuum_freeze_table_age = '150000000' wal_buffers = -1 " test Postgresql.lns get float_quotes = { "seq_page_cost" = "2.0" } { "random_page_cost" = "4.0" } { "vacuum_freeze_min_age" = "50000000" } { "vacuum_freeze_table_age" = "150000000" } { "wal_buffers" = "-1" } test Postgresql.lns put float_quotes after set "seq_page_cost" "5.0"; set "vacuum_cost_limit" "200"; set "bgwriter_lru_multiplier" "2.0"; set "log_temp_files" "-1"; set "wal_buffers" "1" = "seq_page_cost = 5.0 random_page_cost = '4.0' vacuum_freeze_min_age = 50000000 vacuum_freeze_table_age = '150000000' wal_buffers = 1 vacuum_cost_limit = '200' bgwriter_lru_multiplier = '2.0' log_temp_files = '-1' " (* Boolean values can be written as on, off, true, false, yes, no, 1, 0 (all case-insensitive) or any unambiguous prefix of these. *) let bool_quotes = "log_connections = yes transform_null_equals = OFF sql_inheritance = 'on' synchronize_seqscans = 1 standard_conforming_strings = fal " test Postgresql.lns get bool_quotes = { "log_connections" = "yes" } { "transform_null_equals" = "OFF" } { "sql_inheritance" = "on" } { "synchronize_seqscans" = "1" } { "standard_conforming_strings" = "fal" } test Postgresql.lns put bool_quotes after set "sql_inheritance" "off"; set "log_lock_waits" "off" = "log_connections = yes transform_null_equals = OFF sql_inheritance = 'off' synchronize_seqscans = 1 standard_conforming_strings = fal log_lock_waits = 'off' " (* Strings must be single-quoted, except if they have no special character *) let string_quotes = "listen_addresses = 'localhost' stats_temp_directory = pg_stat_tmp lc_messages = 'en_US.UTF-8' log_filename = log archive_command = 'tar \'quoted option\'' search_path = '\"$user\",public' " test Postgresql.lns get string_quotes = { "listen_addresses" = "localhost" } { "stats_temp_directory" = "pg_stat_tmp" } { "lc_messages" = "en_US.UTF-8" } { "log_filename" = "log" } { "archive_command" = "tar \'quoted option\'" } { "search_path" = "\"$user\",public" } test Postgresql.lns put string_quotes after set "stats_temp_directory" "foo_bar"; set "log_filename" "postgresql-%Y-%m-%d_%H%M%S.log"; set "log_statement" "none" = "listen_addresses = 'localhost' stats_temp_directory = foo_bar lc_messages = 'en_US.UTF-8' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' archive_command = 'tar \'quoted option\'' search_path = '\"$user\",public' log_statement = 'none' " (* external files can be included more than once *) let include_keyword = "Include 'foo.conf' # can appear several times Include 'bar.conf' " test Postgresql.lns get include_keyword = { "Include" = "foo.conf" } { "#comment" = "can appear several times" } { "Include" = "bar.conf" } (* Variable: conf A full configuration file *) let conf = "data_directory = '/var/lib/postgresql/8.4/main' # use data in another directory hba_file = '/etc/postgresql/8.4/main/pg_hba.conf' # host-based authentication file ident_file = '/etc/postgresql/8.4/main/pg_ident.conf' # ident configuration file # If external_pid_file is not explicitly set, no extra PID file is written. external_pid_file = '/var/run/postgresql/8.4-main.pid' # write an extra PID file listen_addresses = 'localhost' # what IP address(es) to listen on; port = 5432 # (change requires restart) max_connections = 100 # (change requires restart) superuser_reserved_connections = 3 # (change requires restart) unix_socket_directory = '/var/run/postgresql' # (change requires restart) unix_socket_group = '' # (change requires restart) unix_socket_permissions = 0777 # begin with 0 to use octal notation # (change requires restart) bonjour_name = '' # defaults to the computer name authentication_timeout = 1min # 1s-600s ssl = true # (change requires restart) ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers ssl_renegotiation_limit = 512MB # amount of data between renegotiations password_encryption = on db_user_namespace = off search_path = '\"$user\",public' # schema names default_tablespace = '' # a tablespace name, '' uses the default temp_tablespaces = '' # a list of tablespace names, '' uses datestyle = 'iso, mdy' intervalstyle = 'postgres' timezone = unknown # actually, defaults to TZ environment " (* Test: Postgresql.lns *) test Postgresql.lns get conf = { "data_directory" = "/var/lib/postgresql/8.4/main" { "#comment" = "use data in another directory" } } { "hba_file" = "/etc/postgresql/8.4/main/pg_hba.conf" { "#comment" = "host-based authentication file" } } { "ident_file" = "/etc/postgresql/8.4/main/pg_ident.conf" { "#comment" = "ident configuration file" } } { } { "#comment" = "If external_pid_file is not explicitly set, no extra PID file is written." } { "external_pid_file" = "/var/run/postgresql/8.4-main.pid" { "#comment" = "write an extra PID file" } } { "listen_addresses" = "localhost" { "#comment" = "what IP address(es) to listen on;" } } { "port" = "5432" { "#comment" = "(change requires restart)" } } { "max_connections" = "100" { "#comment" = "(change requires restart)" } } { "superuser_reserved_connections" = "3" { "#comment" = "(change requires restart)" } } { "unix_socket_directory" = "/var/run/postgresql" { "#comment" = "(change requires restart)" } } { "unix_socket_group" = "" { "#comment" = "(change requires restart)" } } { "unix_socket_permissions" = "0777" { "#comment" = "begin with 0 to use octal notation" } } { "#comment" = "(change requires restart)" } { "bonjour_name" = "" { "#comment" = "defaults to the computer name" } } { } { "authentication_timeout" = "1min" { "#comment" = "1s-600s" } } { "ssl" = "true" { "#comment" = "(change requires restart)" } } { "ssl_ciphers" = "ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH" { "#comment" = "allowed SSL ciphers" } } { "ssl_renegotiation_limit" = "512MB" { "#comment" = "amount of data between renegotiations" } } { "password_encryption" = "on" } { "db_user_namespace" = "off" } { } { "search_path" = "\"$user\",public" { "#comment" = "schema names" } } { "default_tablespace" = "" { "#comment" = "a tablespace name, '' uses the default" } } { "temp_tablespaces" = "" { "#comment" = "a list of tablespace names, '' uses" } } { } { "datestyle" = "iso, mdy" } { "intervalstyle" = "postgres" } { "timezone" = "unknown" { "#comment" = "actually, defaults to TZ environment" } }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
test_access.aug | File | 3.44 KB | 0644 |
|
test_activemq_conf.aug | File | 758 B | 0644 |
|
test_activemq_xml.aug | File | 1.63 KB | 0644 |
|
test_afs_cellalias.aug | File | 1.31 KB | 0644 |
|
test_aliases.aug | File | 2.99 KB | 0644 |
|
test_anacron.aug | File | 1.21 KB | 0644 |
|
test_approx.aug | File | 1.44 KB | 0644 |
|
test_apt_update_manager.aug | File | 1.12 KB | 0644 |
|
test_aptcacherngsecurity.aug | File | 1.17 KB | 0644 |
|
test_aptconf.aug | File | 5.26 KB | 0644 |
|
test_aptpreferences.aug | File | 1.86 KB | 0644 |
|
test_aptsources.aug | File | 3.42 KB | 0644 |
|
test_authorized_keys.aug | File | 4.47 KB | 0644 |
|
test_automaster.aug | File | 1.53 KB | 0644 |
|
test_automounter.aug | File | 5.2 KB | 0644 |
|
test_avahi.aug | File | 545 B | 0644 |
|
test_backuppchosts.aug | File | 623 B | 0644 |
|
test_bbhosts.aug | File | 3.68 KB | 0644 |
|
test_bootconf.aug | File | 980 B | 0644 |
|
test_build.aug | File | 8.12 KB | 0644 |
|
test_cachefilesd.aug | File | 579 B | 0644 |
|
test_carbon.aug | File | 2.54 KB | 0644 |
|
test_ceph.aug | File | 4.86 KB | 0644 |
|
test_cgconfig.aug | File | 5.93 KB | 0644 |
|
test_cgrules.aug | File | 903 B | 0644 |
|
test_channels.aug | File | 4.72 KB | 0644 |
|
test_chrony.aug | File | 5.49 KB | 0644 |
|
test_clamav.aug | File | 8.48 KB | 0644 |
|
test_cobblermodules.aug | File | 620 B | 0644 |
|
test_cobblersettings.aug | File | 1.34 KB | 0644 |
|
test_collectd.aug | File | 1.3 KB | 0644 |
|
test_cpanel.aug | File | 1.62 KB | 0644 |
|
test_cron.aug | File | 1.96 KB | 0644 |
|
test_cron_user.aug | File | 779 B | 0644 |
|
test_crypttab.aug | File | 1.28 KB | 0644 |
|
test_csv.aug | File | 1.56 KB | 0644 |
|
test_cups.aug | File | 13.93 KB | 0644 |
|
test_cyrus_imapd.aug | File | 1.33 KB | 0644 |
|
test_darkice.aug | File | 575 B | 0644 |
|
test_debctrl.aug | File | 13.94 KB | 0644 |
|
test_desktop.aug | File | 1.23 KB | 0644 |
|
test_device_map.aug | File | 797 B | 0644 |
|
test_dhclient.aug | File | 4.75 KB | 0644 |
|
test_dhcpd.aug | File | 15.07 KB | 0644 |
|
test_dns_zone.aug | File | 10.33 KB | 0644 |
|
test_dnsmasq.aug | File | 1.19 KB | 0644 |
|
test_dovecot.aug | File | 22.15 KB | 0644 |
|
test_dpkg.aug | File | 322 B | 0644 |
|
test_dput.aug | File | 3.37 KB | 0644 |
|
test_erlang.aug | File | 2.58 KB | 0644 |
|
test_ethers.aug | File | 1.4 KB | 0644 |
|
test_exports.aug | File | 1.69 KB | 0644 |
|
test_fai_diskconfig.aug | File | 15.04 KB | 0644 |
|
test_fonts.aug | File | 19.45 KB | 0644 |
|
test_fstab.aug | File | 4.32 KB | 0644 |
|
test_fuse.aug | File | 590 B | 0644 |
|
test_gdm.aug | File | 620 B | 0644 |
|
test_getcap.aug | File | 3.77 KB | 0644 |
|
test_group.aug | File | 1.09 KB | 0644 |
|
test_grub.aug | File | 9.4 KB | 0644 |
|
test_grubenv.aug | File | 2.44 KB | 0644 |
|
test_gshadow.aug | File | 359 B | 0644 |
|
test_gtkbookmarks.aug | File | 820 B | 0644 |
|
test_host_conf.aug | File | 834 B | 0644 |
|
test_hostname.aug | File | 103 B | 0644 |
|
test_hosts.aug | File | 1.78 KB | 0644 |
|
test_hosts_access.aug | File | 6.12 KB | 0644 |
|
test_htpasswd.aug | File | 468 B | 0644 |
|
test_httpd.aug | File | 15.71 KB | 0644 |
|
test_inetd.aug | File | 4.51 KB | 0644 |
|
test_inifile.aug | File | 11.64 KB | 0644 |
|
test_inittab.aug | File | 1.82 KB | 0644 |
|
test_inputrc.aug | File | 5.13 KB | 0644 |
|
test_interfaces.aug | File | 3.65 KB | 0644 |
|
test_iproute2.aug | File | 945 B | 0644 |
|
test_iptables.aug | File | 7.39 KB | 0644 |
|
test_iscsid.aug | File | 2.45 KB | 0644 |
|
test_jaas.aug | File | 5.35 KB | 0644 |
|
test_jettyrealm.aug | File | 982 B | 0644 |
|
test_jmxaccess.aug | File | 637 B | 0644 |
|
test_jmxpassword.aug | File | 653 B | 0644 |
|
test_json.aug | File | 16.85 KB | 0644 |
|
test_kdump.aug | File | 2.84 KB | 0644 |
|
test_keepalived.aug | File | 14.33 KB | 0644 |
|
test_known_hosts.aug | File | 1.79 KB | 0644 |
|
test_koji.aug | File | 1.65 KB | 0644 |
|
test_krb5.aug | File | 28.56 KB | 0644 |
|
test_ldap.aug | File | 398 B | 0644 |
|
test_ldif.aug | File | 3.88 KB | 0644 |
|
test_ldso.aug | File | 486 B | 0644 |
|
test_lightdm.aug | File | 3.98 KB | 0644 |
|
test_limits.aug | File | 924 B | 0644 |
|
test_login_defs.aug | File | 528 B | 0644 |
|
test_logrotate.aug | File | 7.81 KB | 0644 |
|
test_logwatch.aug | File | 322 B | 0644 |
|
test_lokkit.aug | File | 2.1 KB | 0644 |
|
test_lvm.aug | File | 4.56 KB | 0644 |
|
test_mailscanner.aug | File | 32.15 KB | 0644 |
|
test_mailscanner_rules.aug | File | 2.6 KB | 0644 |
|
test_masterpasswd.aug | File | 3.21 KB | 0644 |
|
test_mcollective.aug | File | 1.2 KB | 0644 |
|
test_mdadm_conf.aug | File | 2.52 KB | 0644 |
|
test_memcached.aug | File | 1.15 KB | 0644 |
|
test_mke2fs.aug | File | 2.13 KB | 0644 |
|
test_modprobe.aug | File | 4.07 KB | 0644 |
|
test_modules.aug | File | 229 B | 0644 |
|
test_modules_conf.aug | File | 3.23 KB | 0644 |
|
test_mongodbserver.aug | File | 775 B | 0644 |
|
test_monit.aug | File | 1.03 KB | 0644 |
|
test_multipath.aug | File | 5.21 KB | 0644 |
|
test_mysql.aug | File | 8.75 KB | 0644 |
|
test_nagioscfg.aug | File | 2.95 KB | 0644 |
|
test_nagiosobjects.aug | File | 1.69 KB | 0644 |
|
test_netmasks.aug | File | 640 B | 0644 |
|
test_networkmanager.aug | File | 1.27 KB | 0644 |
|
test_networks.aug | File | 1.16 KB | 0644 |
|
test_nginx.aug | File | 7.04 KB | 0644 |
|
test_nrpe.aug | File | 2.13 KB | 0644 |
|
test_nslcd.aug | File | 12.84 KB | 0644 |
|
test_nsswitch.aug | File | 1.54 KB | 0644 |
|
test_ntp.aug | File | 5.09 KB | 0644 |
|
test_ntpd.aug | File | 1.87 KB | 0644 |
|
test_odbc.aug | File | 1.62 KB | 0644 |
|
test_opendkim.aug | File | 5.66 KB | 0644 |
|
test_openshift_config.aug | File | 3.64 KB | 0644 |
|
test_openshift_http.aug | File | 2.16 KB | 0644 |
|
test_openshift_quickstarts.aug | File | 12.42 KB | 0644 |
|
test_openvpn.aug | File | 28.09 KB | 0644 |
|
test_oz.aug | File | 611 B | 0644 |
|
test_pagekite.aug | File | 2.75 KB | 0644 |
|
test_pam.aug | File | 1.54 KB | 0644 |
|
test_pamconf.aug | File | 1010 B | 0644 |
|
test_passwd.aug | File | 2.44 KB | 0644 |
|
test_pbuilder.aug | File | 531 B | 0644 |
|
test_pg_hba.aug | File | 6.1 KB | 0644 |
|
test_pgbouncer.aug | File | 1.97 KB | 0644 |
|
test_php.aug | File | 1.4 KB | 0644 |
|
test_phpvars.aug | File | 1.63 KB | 0644 |
|
test_postfix_access.aug | File | 1.52 KB | 0644 |
|
test_postfix_main.aug | File | 1.03 KB | 0644 |
|
test_postfix_master.aug | File | 3.77 KB | 0644 |
|
test_postfix_passwordmap.aug | File | 1.31 KB | 0644 |
|
test_postfix_sasl_smtpd.aug | File | 530 B | 0644 |
|
test_postfix_transport.aug | File | 1.58 KB | 0644 |
|
test_postfix_virtual.aug | File | 1.23 KB | 0644 |
|
test_postgresql.aug | File | 8.07 KB | 0644 |
|
test_properties.aug | File | 3.51 KB | 0644 |
|
test_protocols.aug | File | 1.3 KB | 0644 |
|
test_puppet.aug | File | 547 B | 0644 |
|
test_puppet_auth.aug | File | 1.1 KB | 0644 |
|
test_puppetfile.aug | File | 1.73 KB | 0644 |
|
test_puppetfileserver.aug | File | 949 B | 0644 |
|
test_pylonspaste.aug | File | 1.73 KB | 0644 |
|
test_pythonpaste.aug | File | 1.23 KB | 0644 |
|
test_qpid.aug | File | 1.3 KB | 0644 |
|
test_quote.aug | File | 8.66 KB | 0644 |
|
test_rabbitmq.aug | File | 3.66 KB | 0644 |
|
test_radicale.aug | File | 1.04 KB | 0644 |
|
test_rancid.aug | File | 706 B | 0644 |
|
test_redis.aug | File | 5.81 KB | 0644 |
|
test_reprepro_uploaders.aug | File | 4.68 KB | 0644 |
|
test_resolv.aug | File | 1.46 KB | 0644 |
|
test_rhsm.aug | File | 4.46 KB | 0644 |
|
test_rmt.aug | File | 826 B | 0644 |
|
test_rsyncd.aug | File | 1.27 KB | 0644 |
|
test_rsyslog.aug | File | 5.44 KB | 0644 |
|
test_rtadvd.aug | File | 859 B | 0644 |
|
test_rx.aug | File | 3.33 KB | 0644 |
|
test_samba.aug | File | 3.52 KB | 0644 |
|
test_schroot.aug | File | 2.25 KB | 0644 |
|
test_securetty.aug | File | 636 B | 0644 |
|
test_services.aug | File | 2.87 KB | 0644 |
|
test_shadow.aug | File | 2.01 KB | 0644 |
|
test_shells.aug | File | 348 B | 0644 |
|
test_shellvars.aug | File | 18.33 KB | 0644 |
|
test_shellvars_list.aug | File | 4.18 KB | 0644 |
|
test_simplelines.aug | File | 724 B | 0644 |
|
test_simplevars.aug | File | 994 B | 0644 |
|
test_sip_conf.aug | File | 3.61 KB | 0644 |
|
test_slapd.aug | File | 3.03 KB | 0644 |
|
test_smbusers.aug | File | 664 B | 0644 |
|
test_solaris_system.aug | File | 2.48 KB | 0644 |
|
test_soma.aug | File | 424 B | 0644 |
|
test_spacevars.aug | File | 431 B | 0644 |
|
test_splunk.aug | File | 2.96 KB | 0644 |
|
test_squid.aug | File | 5.09 KB | 0644 |
|
test_ssh.aug | File | 2.92 KB | 0644 |
|
test_sshd.aug | File | 5.04 KB | 0644 |
|
test_sssd.aug | File | 896 B | 0644 |
|
test_star.aug | File | 1.56 KB | 0644 |
|
test_stunnel.aug | File | 791 B | 0644 |
|
test_subversion.aug | File | 3.06 KB | 0644 |
|
test_sudoers.aug | File | 9.9 KB | 0644 |
|
test_sysconfig.aug | File | 4.1 KB | 0644 |
|
test_sysconfig_route.aug | File | 522 B | 0644 |
|
test_sysctl.aug | File | 1.34 KB | 0644 |
|
test_syslog.aug | File | 10.96 KB | 0644 |
|
test_systemd.aug | File | 7.95 KB | 0644 |
|
test_termcap.aug | File | 16.69 KB | 0644 |
|
test_thttpd.aug | File | 1.17 KB | 0644 |
|
test_tmpfiles.aug | File | 9.94 KB | 0644 |
|
test_trapperkeeper.aug | File | 4.15 KB | 0644 |
|
test_tuned.aug | File | 259 B | 0644 |
|
test_up2date.aug | File | 6.23 KB | 0644 |
|
test_updatedb.aug | File | 855 B | 0644 |
|
test_util.aug | File | 428 B | 0644 |
|
test_vfstab.aug | File | 2.79 KB | 0644 |
|
test_vmware_config.aug | File | 1.7 KB | 0644 |
|
test_vsftpd.aug | File | 2.49 KB | 0644 |
|
test_webmin.aug | File | 195 B | 0644 |
|
test_wine.aug | File | 5.58 KB | 0644 |
|
test_xendconfsxp.aug | File | 7.74 KB | 0644 |
|
test_xinetd.aug | File | 2.78 KB | 0644 |
|
test_xml.aug | File | 20.04 KB | 0644 |
|
test_xorg.aug | File | 2.41 KB | 0644 |
|
test_xymon.aug | File | 4.29 KB | 0644 |
|
test_xymon_alerting.aug | File | 7.44 KB | 0644 |
|
test_yaml.aug | File | 1.34 KB | 0644 |
|
test_yum.aug | File | 7.28 KB | 0644 |
|