# Copyright (C) 2008 Ioannis Tambouras . All rights reserved. # LICENSE: GPLv3, eead licensing terms at http://www.fsf.org . package Pg::Pcurse::Defaults; use 5.008008; our $VERSION = '0.15'; use warnings; use strict; our @EXPORT = qw( $bucardo_defaults $pg_default ); our $pg_default = { listen_addresses => 'localhost', max_connections => 100 , unix_socket_group => '' , unix_socket_permissions => 0777 , bonjour_name => '' , authentication_timeout => '1min' , ssl_ciphers => 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' , password_encryption => 'on' , db_user_namespace => 'off' , krb_server_keyfile => '' , krb_srvname => 'postgres' , krb_server_hostname => '' , krb_caseins_users => 'off' , krb_realm => '' , tcp_keepalives_idle => 0 , tcp_keepalives_interval => 0 , tcp_keepalives_count => 0 , temp_buffers => '8MB' , max_prepared_transactions => 5 , work_mem => '1MB' , maintenance_work_mem => '16MB' , max_stack_depth => '2MB' , max_fsm_relations => 1000 , max_files_per_process => 1000 , shared_preload_libraries => '' , vacuum_cost_delay => 0 , vacuum_cost_page_hit => 1 , vacuum_cost_page_miss => 10 , vacuum_cost_page_dirty => 20 , vacuum_cost_limit => 200 , bgwriter_delay => '200ms' , bgwriter_lru_maxpages => 100 , bgwriter_lru_multiplier => 2.0 , fsync => 'on' , wal_sync_method => 'fsync' , full_page_writes => 'on' , wal_buffers => '64kB' , wal_writer_delay => '200ms' , commit_delay => 0 , commit_siblings => 5 , checkpoint_segments => 3 , checkpoint_timeout => '5min' , checkpoint_completion_target => 0.5 , checkpoint_warning => '30s' , archive_mode => 'off' , archive_command => '' , archive_timeout => 0 , enable_bitmapscan => 'on' , enable_hashagg => 'on' , enable_hashjoin => 'on' , enable_indexscan => 'on' , enable_mergejoin => 'on' , enable_nestloop => 'on' , enable_seqscan => 'on' , enable_sort => 'on' , enable_tidscan => 'on' , seq_page_cost => 1.0 , random_page_cost => 4.0 , cpu_tuple_cost => 0.01 , cpu_index_tuple_cost => 0.005 , cpu_operator_cost => 0.0025 , effective_cache_size => '128MB' , geqo => 'on' , geqo_threshold => 12 , geqo_effort => 5 , geqo_pool_size => 0 , geqo_generations => 0 , geqo_selection_bias => 2.0 , default_statistics_target => 10 , constraint_exclusion => 'off' , from_collapse_limit => 8 , join_collapse_limit => 8 , logging_collector => 'off' , log_destination => 'stderr' , log_directory => '/var/log/postgres' , log_filename => 'postgresql-8.3.log' , log_directory => 'pg_log' , log_filename => 'postgresql-%Y-%m-%d_%H%M%S.log' , log_truncate_on_rotation => 'off' , log_rotation_age => '1d' , log_rotation_size => '10MB' , client_min_messages => 'notice' , log_min_messages => 'notice' , log_error_verbosity => 'default' , log_min_error_statement => 'error' , log_min_duration_statement => -1 , silent_mode => 'off' , debug_print_parse => 'off' , debug_print_rewritten => 'off' , debug_print_plan => 'off' , debug_pretty_print => 'off' , log_checkpoints => 'off' , log_connections => 'off' , log_disconnections => 'off' , log_duration => 'off' , log_hostname => 'off' , log_line_prefix => '' , log_lock_waits => 'off' , log_statement => 'none' , log_temp_files => -1 , log_timezone => 'unknown' , track_activities => 'on' , track_counts => 'on' , update_process_title => 'on' , log_parser_stats => 'off' , log_planner_stats => 'off' , log_executor_stats => 'off' , log_statement_stats => 'off' , autovacuum => 'on' , log_autovacuum_min_duration => -1 , autovacuum_max_workers => 3 , autovacuum_naptime => '1min' , autovacuum_vacuum_threshold => 50 , autovacuum_analyze_threshold => 50 , autovacuum_vacuum_scale_factor => 0.2 , autovacuum_analyze_scale_factor => 0.1 , autovacuum_freeze_max_age => 200000000 , autovacuum_vacuum_cost_delay => '20ms' , autovacuum_vacuum_cost_limit => -1 , search_path => '"$user",public', default_tablespace => '' , temp_tablespaces => '' , check_function_bodies => 'on' , default_transaction_isolation => 'read committed', default_transaction_read_only => 'off' , statement_timeout => 0 , session_replication_role => 'origin' , vacuum_freeze_min_age => 100000000 , xmlbinary => 'base64' , xmloption => 'content' , timezone => 'unknown' , timezone_abbreviations => 'Default' , extra_float_digits => 0 , client_encoding => 'sql_ascii' , explain_pretty_print => 'on' , dynamic_library_path => '$libdir' , local_preload_libraries => '' , deadlock_timeout => '1s' , max_locks_per_transaction => 64 , add_missing_from => 'off' , array_nulls => 'on' , backslash_quote => 'safe_encoding' , default_with_oids => 'off' , escape_string_warning => 'on' , standard_conforming_strings => 'off' , port => 5432 , regex_flavor => 'advanced' , sql_inheritance => 'on' , transform_null_equals => 'off' , custom_variable_classes => '' , ssl => 'off' , shared_buffers => '32MB' , max_fsm_pages => 204800 , log_destination => 'stderr' , datestyle => 'iso, mdy' , lc_messages => 'en_US' , lc_monetary => 'en_US' , lc_numeric => 'en_US' , lc_time => 'en_US' , syslog_facility => 'LOCAL0' , syslog_ident => 'postgres' , default_text_search_config => 'pg_catalog.english', }; 1; __END__