373
373
custom_variable_classes = 'foo'
376
$fullconf{'8.2'} = "external_pid_file = '(none)'
377
listen_addresses = 'localhost'
379
max_connections = 100
380
superuser_reserved_connections = 3
381
unix_socket_directory = ''
382
unix_socket_group = ''
383
unix_socket_permissions = 0777
385
authentication_timeout = 1min
387
password_encryption = on
388
db_user_namespace = off
389
krb_server_keyfile = ''
390
krb_srvname = 'postgres'
391
krb_server_hostname = ''
392
krb_caseins_users = off
393
tcp_keepalives_idle = 0
394
tcp_keepalives_interval = 0
395
tcp_keepalives_count = 0
396
shared_buffers = 1000
398
max_prepared_transactions = 5
400
maintenance_work_mem = 16MB
401
max_stack_depth = 2MB
402
max_fsm_pages = 1638400
403
max_fsm_relations = 1000
404
max_files_per_process = 1000
405
shared_preload_libraries = ''
406
vacuum_cost_delay = 0
407
vacuum_cost_page_hit = 1
408
vacuum_cost_page_miss = 10
409
vacuum_cost_page_dirty = 20
410
vacuum_cost_limit = 200
411
bgwriter_delay = 200ms
412
bgwriter_lru_percent = 1.0
413
bgwriter_lru_maxpages = 5
414
bgwriter_all_percent = 0.333
415
bgwriter_all_maxpages = 5
417
wal_sync_method = fsync
418
full_page_writes = on
422
checkpoint_segments = 3
423
checkpoint_timeout = 5min
424
checkpoint_warning = 30s
427
enable_bitmapscan = on
430
enable_indexscan = on
431
enable_mergejoin = on
437
random_page_cost = 4.0
438
cpu_tuple_cost = 0.01
439
cpu_index_tuple_cost = 0.005
440
cpu_operator_cost = 0.0025
441
effective_cache_size = 128MB
447
geqo_selection_bias = 2.0
448
default_statistics_target = 10
449
constraint_exclusion = off
450
from_collapse_limit = 8
451
join_collapse_limit = 8
452
log_destination = 'stderr'
455
log_filename = 'postgresql-%Y-%m-%d_%H%M'
456
log_truncate_on_rotation = off
457
log_rotation_age = 1d
458
log_rotation_size = 10MB
459
syslog_facility = 'LOCAL0'
460
syslog_ident = 'postgres'
461
client_min_messages = notice
462
log_min_messages = notice
463
log_error_verbosity = default
464
log_min_error_statement = error
465
log_min_duration_statement = -1
467
debug_print_parse = off
468
debug_print_rewritten = off
469
debug_print_plan = off
470
debug_pretty_print = off
471
log_connections = off
472
log_disconnections = off
475
log_statement = 'none'
477
stats_command_string = on
478
update_process_title = on
479
stats_start_collector = on
480
stats_block_level = off
481
stats_row_level = off
482
stats_reset_on_server_start = off
483
log_parser_stats = off
484
log_planner_stats = off
485
log_executor_stats = off
486
log_statement_stats = off
488
autovacuum_naptime = 1min
489
autovacuum_vacuum_threshold = 500
490
autovacuum_analyze_threshold = 250
491
autovacuum_vacuum_scale_factor = 0.2
492
autovacuum_analyze_scale_factor = 0.1
493
autovacuum_freeze_max_age = 200000000
494
autovacuum_vacuum_cost_delay = -1
495
autovacuum_vacuum_cost_limit = -1
496
search_path = '\"\$user\",public'
497
default_tablespace = ''
498
check_function_bodies = on
499
default_transaction_isolation = 'read committed'
500
default_transaction_read_only = off
501
statement_timeout = 0
502
vacuum_freeze_min_age = 100000000
503
datestyle = 'iso, mdy'
505
timezone_abbreviations = 'Default'
506
extra_float_digits = 0
507
client_encoding = sql_ascii
512
explain_pretty_print = on
513
dynamic_library_path = '\$libdir'
514
local_preload_libraries = ''
515
deadlock_timeout = 1s
516
max_locks_per_transaction = 64
517
add_missing_from = off
519
backslash_quote = safe_encoding
520
default_with_oids = off
521
escape_string_warning = on
522
standard_conforming_strings = off
523
regex_flavor = advanced
525
transform_null_equals = off
526
custom_variable_classes = 'foo'
376
529
# create cluster for oldest version
377
530
is ((system "pg_createcluster $MAJORS[0] main >/dev/null"), 0, "pg_createcluster $MAJORS[0] main");
383
536
my $new = $testversions[0];
385
538
# Write configuration file and start
539
my $datadir = PgCommon::cluster_data_directory $cur, 'main';
386
540
open F, ">/etc/postgresql/$cur/main/postgresql.conf" or
387
541
die "could not open /etc/postgresql/$cur/main/postgresql.conf";
388
542
die "\$fullconf{$cur} is not defined" unless exists $fullconf{$cur};
389
543
print F $fullconf{$cur};
390
is ((exec_as 'postgres', "pg_ctlcluster $cur main start 2>/dev/null"), 0,
545
# restore data directory, we just scribbled over it
547
PgCommon::set_conf_value $cur, 'main', 'postgresql.conf', 'data_directory', $datadir;
550
is ((exec_as 'postgres', "pg_ctlcluster $cur main start"), 0,
391
551
'pg_ctlcluster start');
392
552
like_program_out 'postgres', 'pg_lsclusters -h', 0, qr/$cur.*online/,
393
553
"Old $cur cluster is online";