Quanto às configurações "não padrão". "application_name";"pgAdmin III - Query Tool";"client" "archive_command";"cp /var/lib/pgsql/9.1/data/%p /backup/wal/%f";"configuration file" "archive_mode";"on";"configuration file" "archive_timeout";"10min";"configuration file" "autovacuum_analyze_scale_factor";"0.02";"configuration file" "autovacuum_max_workers";"10";"configuration file" "autovacuum_vacuum_scale_factor";"0.05";"configuration file" "bytea_output";"escape";"session" "checkpoint_segments";"10";"configuration file" "checkpoint_timeout";"10min";"configuration file" "client_encoding";"UNICODE";"session" "client_min_messages";"notice";"session" "DateStyle";"ISO, MDY";"session" "default_text_search_config";"pg_catalog.english";"configuration file" "effective_cache_size";"20GB";"configuration file" "lc_messages";"en_US.UTF-8";"configuration file" "lc_monetary";"en_US.UTF-8";"configuration file" "lc_numeric";"en_US.UTF-8";"configuration file" "lc_time";"en_US.UTF-8";"configuration file" "listen_addresses";"*";"configuration file" "log_autovacuum_min_duration";"0";"configuration file" "log_checkpoints";"on";"configuration file" "log_connections";"on";"configuration file" "log_destination";"stderr";"configuration file" "log_directory";"pg_log";"configuration file" "log_disconnections";"on";"configuration file" "log_filename";"postgresql-%Y%m%d.log";"configuration file" "log_line_prefix";"%t [%p]: [%l-1] db=%d,user=%u@%r %x:%v ";"configuration file" "log_lock_waits";"on";"configuration file" "log_min_duration_statement";"1min";"configuration file" "log_rotation_age";"1d";"configuration file" "log_rotation_size";"100MB";"configuration file" "log_statement";"ddl";"configuration file" "log_temp_files";"0";"configuration file" "log_timezone";"America/Recife";"environment variable" "log_truncate_on_rotation";"on";"configuration file" "logging_collector";"on";"configuration file" "maintenance_work_mem";"3GB";"configuration file" "max_connections";"200";"configuration file" "max_prepared_transactions";"2000";"configuration file" "max_stack_depth";"2MB";"environment variable" "max_wal_senders";"10";"configuration file" "port";"5432";"command line" "shared_buffers";"6GB";"configuration file" "statement_timeout";"5min";"configuration file" "superuser_reserved_connections";"5";"configuration file" "tcp_keepalives_count";"2";"configuration file" "tcp_keepalives_idle";"60";"configuration file" "tcp_keepalives_interval";"30";"configuration file" "temp_buffers";"80MB";"configuration file" "TimeZone";"America/Recife";"environment variable" "wal_level";"archive";"configuration file" "wal_sync_method";"fdatasync";"configuration file" "work_mem";"10MB";"configuration file" - mudei isso agora e só dei um reload
Luiz carlos
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral