Hi

Thanks for the tips. Locale are the same ... unless I don`t look at the right thing...


Production ENV ----------------- lc_collate | C lc_ctype | C lc_messages | C lc_monetary | C lc_numeric | C lc_time | C


Dev ENV ---------- "lc_collate";"C" "lc_ctype";"C" "lc_messages";"C" "lc_monetary";"C" "lc_numeric";"C" "lc_time";"C"


Thanks for your help /David

PROD ALL VARIABLES
---------------------------
"add_missing_from";"on"
"australian_timezones";"off"
"authentication_timeout";"60"
"check_function_bodies";"on"
"checkpoint_segments";"3"
"checkpoint_timeout";"300"
"checkpoint_warning";"30"
"client_encoding";"UNICODE"
"client_min_messages";"notice"
"commit_delay";"0"
"commit_siblings";"5"
"cpu_index_tuple_cost";"0.001"
"cpu_operator_cost";"0.0025"
"cpu_tuple_cost";"0.01"
"DateStyle";"ISO, MDY"
"db_user_namespace";"off"
"deadlock_timeout";"1000"
"debug_pretty_print";"off"
"debug_print_parse";"off"
"debug_print_plan";"off"
"debug_print_rewritten";"off"
"default_statistics_target";"10"
"default_transaction_isolation";"read committed"
"default_transaction_read_only";"off"
"dynamic_library_path";"$libdir"
"effective_cache_size";"1000"
"enable_hashagg";"on"
"enable_hashjoin";"on"
"enable_indexscan";"on"
"enable_mergejoin";"on"
"enable_nestloop";"on"
"enable_seqscan";"on"
"enable_sort";"on"
"enable_tidscan";"on"
"explain_pretty_print";"on"
"extra_float_digits";"0"
"from_collapse_limit";"8"
"fsync";"on"
"geqo";"on"
"geqo_effort";"1"
"geqo_generations";"0"
"geqo_pool_size";"0"
"geqo_selection_bias";"2"
"geqo_threshold";"11"
"join_collapse_limit";"8"
"krb_server_keyfile";"FILE:/etc/sysconfig/pgsql/krb5.keytab"
"lc_collate";"C"
"lc_ctype";"C"
"lc_messages";"C"
"lc_monetary";"C"
"lc_numeric";"C"
"lc_time";"C"
"log_connections";"off"
"log_duration";"off"
"log_error_verbosity";"default"
"log_executor_stats";"off"
"log_hostname";"off"
"log_min_duration_statement";"-1"
"log_min_error_statement";"panic"
"log_min_messages";"notice"
"log_parser_stats";"off"
"log_pid";"off"
"log_planner_stats";"off"
"log_source_port";"off"
"log_statement";"off"
"log_statement_stats";"off"
"log_timestamp";"off"
"max_connections";"100"
"max_expr_depth";"10000"
"max_files_per_process";"1000"
"max_fsm_pages";"20000"
"max_fsm_relations";"1000"
"max_locks_per_transaction";"64"
"password_encryption";"on"
"port";"5432"
"pre_auth_delay";"0"
"preload_libraries";"unset"
"random_page_cost";"4"
"regex_flavor";"advanced"
"rendezvous_name";"unset"
"search_path";"$user,public"
"server_encoding";"UNICODE"
"server_version";"7.4.7"
"shared_buffers";"1000"
"silent_mode";"off"
"sort_mem";"1024"
"sql_inheritance";"on"
"ssl";"off"
"statement_timeout";"0"
"stats_block_level";"off"
"stats_command_string";"off"
"stats_reset_on_server_start";"on"
"stats_row_level";"off"
"stats_start_collector";"on"
"superuser_reserved_connections";"2"
"syslog";"0"
"syslog_facility";"LOCAL0"
"syslog_ident";"postgres"
"tcpip_socket";"on"
"TimeZone";"unknown"
"trace_notify";"off"
"transaction_isolation";"read committed"
"transaction_read_only";"off"
"transform_null_equals";"off"
"unix_socket_directory";"unset"
"unix_socket_group";"unset"
"unix_socket_permissions";"511"
"vacuum_mem";"8192"
"virtual_host";"unset"
"wal_buffers";"8"
"wal_debug";"0"
"wal_sync_method";"fdatasync"
"zero_damaged_pages";"off"


DEV ENV FULL VARIABLE ------------------------------- "add_missing_from";"on" "australian_timezones";"off" "authentication_timeout";"60" "check_function_bodies";"on" "checkpoint_segments";"3" "checkpoint_timeout";"300" "checkpoint_warning";"30" "client_encoding";"UNICODE" "client_min_messages";"notice" "commit_delay";"0" "commit_siblings";"5" "cpu_index_tuple_cost";"0.001" "cpu_operator_cost";"0.0025" "cpu_tuple_cost";"0.01" "DateStyle";"ISO, MDY" "db_user_namespace";"off" "deadlock_timeout";"1000" "debug_pretty_print";"off" "debug_print_parse";"off" "debug_print_plan";"off" "debug_print_rewritten";"off" "default_statistics_target";"10" "default_transaction_isolation";"read committed" "default_transaction_read_only";"off" "dynamic_library_path";"$libdir" "effective_cache_size";"1000" "enable_hashagg";"on" "enable_hashjoin";"on" "enable_indexscan";"on" "enable_mergejoin";"on" "enable_nestloop";"on" "enable_seqscan";"on" "enable_sort";"on" "enable_tidscan";"on" "explain_pretty_print";"on" "extra_float_digits";"0" "from_collapse_limit";"8" "fsync";"on" "geqo";"on" "geqo_effort";"1" "geqo_generations";"0" "geqo_pool_size";"0" "geqo_selection_bias";"2" "geqo_threshold";"11" "join_collapse_limit";"8" "krb_server_keyfile";"unset" "lc_collate";"C" "lc_ctype";"C" "lc_messages";"C" "lc_monetary";"C" "lc_numeric";"C" "lc_time";"C" "log_connections";"off" "log_duration";"off" "log_error_verbosity";"default" "log_executor_stats";"off" "log_hostname";"off" "log_min_duration_statement";"-1" "log_min_error_statement";"panic" "log_min_messages";"notice" "log_parser_stats";"off" "log_pid";"off" "log_planner_stats";"off" "log_source_port";"off" "log_statement";"off" "log_statement_stats";"off" "log_timestamp";"off" "max_connections";"40" "max_expr_depth";"10000" "max_files_per_process";"1000" "max_fsm_pages";"20000" "max_fsm_relations";"1000" "max_locks_per_transaction";"64" "password_encryption";"on" "port";"5432" "pre_auth_delay";"0" "preload_libraries";"unset" "random_page_cost";"4" "regex_flavor";"advanced" "rendezvous_name";"unset" "search_path";"$user,public" "server_encoding";"UNICODE" "server_version";"7.4.5" "shared_buffers";"1000" "silent_mode";"off" "sort_mem";"1024" "sql_inheritance";"on" "ssl";"off" "statement_timeout";"0" "stats_block_level";"off" "stats_command_string";"off" "stats_reset_on_server_start";"on" "stats_row_level";"off" "stats_start_collector";"on" "superuser_reserved_connections";"2" "syslog";"0" "syslog_facility";"LOCAL0" "syslog_ident";"postgres" "tcpip_socket";"on" "TimeZone";" 5 4,M4.1.0/2,M10.5.0/2" "trace_notify";"off" "transaction_isolation";"read committed" "transaction_read_only";"off" "transform_null_equals";"off" "unix_socket_directory";"unset" "unix_socket_group";"unset" "unix_socket_permissions";"511" "vacuum_mem";"8192" "virtual_host";"unset" "wal_buffers";"8" "wal_debug";"0" "wal_sync_method";"fsync" "zero_damaged_pages";"off"







Miroslav Åulc wrote:

David Gagnon wrote:

Thanks for your answer.

The ISP created the db fom me .. So I don't have this information. I search the web to know how to get this info via PgadminIII and I haven't found :-( Is there a way to get this information once the database have been created ? I looked via psql .. I haven`t found either


David, you can try 'SHOW ALL' command.


Thanks /David


Miroslav



---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Reply via email to