X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA1FC3A2987 for ; Thu, 30 Dec 2004 16:33:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08517-06 for ; Thu, 30 Dec 2004 16:32:46 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 13CC83A2B97 for ; Thu, 30 Dec 2004 16:28:09 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr4.postgresql.org (Postfix) with ESMTP id E96035AF5C7 for ; Thu, 30 Dec 2004 16:07:13 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id r35so46861rna for ; Thu, 30 Dec 2004 08:05:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=i3AtWygaLoRxa6zlrUXSbylZntWHSM8PK3ShIw9NOre0BcCzjWN/aRuygyU6do2OWBCEQhzxnt4vfbNSvI9O0pb/zEBmO6ri2EWCTO9bXVvWYx1QPbo6MJJMbzBNe102OO7fAreRxc6hUhJhiOQA5/+m1mfdLl1cmHcdn+wbY9Q= Received: by 10.38.73.54 with SMTP id v54mr120512rna; Thu, 30 Dec 2004 08:05:13 -0800 (PST) Received: by 10.38.152.1 with HTTP; Thu, 30 Dec 2004 08:05:13 -0800 (PST) Message-ID: <8718db2404123008051d9db301@mail.gmail.com> Date: Thu, 30 Dec 2004 13:05:13 -0300 From: Amauri Pimenta Reply-To: Amauri Pimenta To: Jason Dixon Subject: Re: Not connect to server! Cc: pgsql-admin@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_232_3179578.1104422713160" References: <8718db24041230054625d4021e@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/268 X-Sequence-Number: 15854 ------=_Part_232_3179578.1104422713160 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline Hey Guys, I am total novice at the postgresql( hehehhe) Had changed config files, but the error continue! The files are atached. Please, help me! =) I use a version 8.0.0 Thanks a lot! Amauri Junior On Thu, 30 Dec 2004 09:35:02 -0500, Jason Dixon wrote: > On Dec 30, 2004, at 8:46 AM, Amauri Pimenta wrote: > > > Hello! > > > > Well, i just try to connect to server, but without successfull! > > > > the error is "Is the server running on host "172.22.0.23" and > > accepting TCP/IP Connections on port 5432?" > > First, check for a listening port: > > netstat -vant | grep 5432 > > If you don't get any responses, then you'll probably need to edit your > postgresql.conf: > > tcpip_socket = true > > Mine is located at /var/lib/pgsql/data/postgresql.conf, your location > may vary. Then do a pg_ctl reload to effect the changes. Hope this > helps! > > -- > Jason Dixon > DixonGroup Consulting > http://www.dixongroup.net > > -- Amauri Pimenta Junior Consultor BI Softtek Brasil Batera banda Riffy ------=_Part_232_3179578.1104422713160 Content-Type: text/plain; name="pg_hba.conf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="pg_hba.conf" # PostgreSQL Client Authentication Configuration File # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D # # Refer to the PostgreSQL Administrator's Guide, chapter "Client # Authentication" for a complete description. A short synopsis # follows. # # This file controls: which hosts are allowed to connect, how clients # are authenticated, which PostgreSQL user names they can use, which # databases they can access. Records take one of seven forms: # # local DATABASE USER METHOD [OPTION] # host DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # # (The uppercase quantities should be replaced by actual values.) # The first field is the connection type: "local" is a Unix-domain socket, # "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an # SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket. # DATABASE can be "all", "sameuser", "samegroup", a database name (or # a comma-separated list thereof), or a file name prefixed with "@". # USER can be "all", an actual user name or a group name prefixed with # "+" or a list containing either. # # CIDR-ADDRESS specifies the set of hosts the record matches. # It is made up of an IP address and a CIDR mask that is an integer=20 # (between 0 and 32 (IPv6) or 128(IPv6) inclusive) that specifies=20 # the number of significant bits in the mask Also, you can use a=20 # separate IP address and netmask to specify the set of hosts. # # METHOD can be "trust", "reject", "md5", "crypt", "password",=20 # "krb4", "krb5", "ident", or "pam". Note that "password" uses=20 # clear-text passwords; "md5" is preferred for encrypted passwords. =20 # OPTION is the ident map or the name of the PAM service. # # Database and user names containing spaces, commas, quotes and other speci= al # characters can be quoted. Quoting one of the keywords "all", "sameuser" o= r # "samegroup" makes the name lose its special character, and just match a= =20 # database or username with that name. # # This file is read on server startup and when the postmaster receives # a SIGHUP signal. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect, or use # "pg_ctl reload". # Put your actual configuration here # ---------------------------------- # # If you want to allow non-local connections, you need to add more # "host" records. In that case you will also need to make PostgreSQL listen # on a non-local interface via the listen_addresses configuration parameter= , or # the -i or -h command line switches. # # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: #host all all ::1/128 md5 #host all all 172.22.0.23 255.255.255.0 ------=_Part_232_3179578.1104422713160 Content-Type: text/plain; name="postgresql.conf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="postgresql.conf" #----------------------------- # PostgreSQL configuration file # ----------------------------- # # This file consists of lines of the form: # # name =3D value # # (The '=3D' is optional.) White space may be used. Comments are introduced # with '#' anywhere on a line. The complete list of option names and # allowed values can be found in the PostgreSQL documentation. The # commented-out settings shown in this file represent the default values. # # Please note that re-commenting a setting is NOT sufficient to revert it # to the default value, unless you restart the postmaster. # # Any option can also be given as a command line switch to the # postmaster, e.g. 'postmaster -c log_connections=3Don'. Some options # can be changed at run-time with the 'SET' SQL command. # # This file is read on postmaster startup and when the postmaster # receives a SIGHUP. If you edit the file on a running system, you have=20 # to SIGHUP the postmaster for the changes to take effect, or use=20 # "pg_ctl reload". Some settings, such as listen_address, require # a postmaster shutdown and restart to take effect. #--------------------------------------------------------------------------= - # FILE LOCATIONS #--------------------------------------------------------------------------= - # The default values of these variables are driven from the -D command line # switch or PGDATA environment variable, represented here as ConfigDir. # data_directory =3D 'ConfigDir'=09=09# use data in another directory # hba_file =3D 'ConfigDir/pg_hba.conf'=09# the host-based authentication fi= le # ident_file =3D 'ConfigDir/pg_ident.conf' # the IDENT configuration file # If external_pid_file is not explicitly set, no extra pid file is written. # external_pid_file =3D '(none)'=09=09# write an extra pid file #--------------------------------------------------------------------------= - # CONNECTIONS AND AUTHENTICATION #--------------------------------------------------------------------------= - # - Connection Settings - #listen_addresses =3D '172.22.0.23'# what IP interface(s) to listen on;=20 =09=09=09=09# defaults to stkrj-trn01, '*' =3D any #tcpip_socket =3D true port =3D 5432 max_connections =3D 100 =09# note: increasing max_connections costs about 500 bytes of shared =09# memory per connection slot, in addition to costs from shared_buffers =09# and max_locks_per_transaction. #superuser_reserved_connections =3D 2 #unix_socket_directory =3D '' #unix_socket_group =3D '' #unix_socket_permissions =3D 0777=09# octal #rendezvous_name =3D ''=09=09# defaults to the computer name # - Security & Authentication - #authentication_timeout =3D 60=09# 1-600, in seconds #ssl =3D false #password_encryption =3D true #krb_server_keyfile =3D '' #db_user_namespace =3D false #--------------------------------------------------------------------------= - # RESOURCE USAGE (except WAL) #--------------------------------------------------------------------------= - # - Memory - shared_buffers =3D 1000=09=09# min 16, at least max_connections*2, 8KB each #work_mem =3D 1024=09=09# min 64, size in KB #maintenance_work_mem =3D 16384=09# min 1024, size in KB #max_stack_depth =3D 2048=09=09# min 100, size in KB # - Free Space Map - #max_fsm_pages =3D 20000=09=09# min max_fsm_relations*16, 6 bytes each #max_fsm_relations =3D 1000=09# min 100, ~50 bytes each # - Kernel Resource Usage - #max_files_per_process =3D 1000=09# min 25 #preload_libraries =3D '' # - Cost-Based Vacuum Delay - #vacuum_cost_delay =3D 0=09=09# 0-1000 milliseconds #vacuum_cost_page_hit =3D 1=09# 0-10000 credits #vacuum_cost_page_miss =3D 10=09# 0-10000 credits #vacuum_cost_page_dirty =3D 20=09# 0-10000 credits #vacuum_cost_limit =3D 200=09# 0-10000 credits # - Background writer - #bgwriter_delay =3D 200=09=09# 10-10000 milliseconds between rounds #bgwriter_percent =3D 1=09=09# 0-100% of dirty buffers in each round #bgwriter_maxpages =3D 100=09# 0-1000 buffers max per round #--------------------------------------------------------------------------= - # WRITE AHEAD LOG #--------------------------------------------------------------------------= - # - Settings - #fsync =3D true=09=09=09# turns forced synchronization on or off #wal_sync_method =3D fsync=09# the default varies across platforms: =09=09=09=09# fsync, fdatasync, open_sync, or open_datasync #wal_buffers =3D 8=09=09# min 4, 8KB each #commit_delay =3D 0=09=09# range 0-100000, in microseconds #commit_siblings =3D 5=09=09# range 1-1000 # - Checkpoints - #checkpoint_segments =3D 3=09# in logfile segments, min 1, 16MB each #checkpoint_timeout =3D 300=09# range 30-3600, in seconds #checkpoint_warning =3D 30=09# 0 is off, in seconds # - Archiving - #archive_command =3D ''=09=09# command to use to archive a logfile segment #--------------------------------------------------------------------------= - # QUERY TUNING #--------------------------------------------------------------------------= - # - Planner Method Configuration - #enable_hashagg =3D true #enable_hashjoin =3D true #enable_indexscan =3D true #enable_mergejoin =3D true #enable_nestloop =3D true #enable_seqscan =3D true #enable_sort =3D true #enable_tidscan =3D true # - Planner Cost Constants - #effective_cache_size =3D 1000=09# typically 8KB each #random_page_cost =3D 4=09=09# units are one sequential page fetch cost #cpu_tuple_cost =3D 0.01=09=09# (same) #cpu_index_tuple_cost =3D 0.001=09# (same) #cpu_operator_cost =3D 0.0025=09# (same) # - Genetic Query Optimizer - #geqo =3D true #geqo_threshold =3D 12 #geqo_effort =3D 5=09=09# range 1-10 #geqo_pool_size =3D 0=09=09# selects default based on effort #geqo_generations =3D 0=09=09# selects default based on effort #geqo_selection_bias =3D 2.0=09# range 1.5-2.0 # - Other Planner Options - #default_statistics_target =3D 10=09# range 1-1000 #from_collapse_limit =3D 8 #join_collapse_limit =3D 8=09# 1 disables collapsing of explicit JOINs #--------------------------------------------------------------------------= - # ERROR REPORTING AND LOGGING #--------------------------------------------------------------------------= - # - Where to Log - log_destination =3D 'stderr'=09# Valid values are combinations of stderr, # syslog and eventlog, depending on # platform. # This is relevant when logging to stderr: redirect_stderr =3D true # Enable capturing of stderr into log files. # These are only relevant if redirect_stderr is true: #log_directory =3D 'pg_log' # Directory where log files are written. # May be specified absolute or relative to PGDA= TA #log_filename =3D 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern. # May include strftime() escapes #log_truncate_on_rotation =3D false # If true, any existing log file of th= e=20 # same name as the new log file will be truncat= ed # rather than appended to. But such truncation # only occurs on time-driven rotation, # not on restarts or size-driven rotation. # Default is false, meaning append to existing= =20 # files in all cases. #log_rotation_age =3D 1440 # Automatic rotation of logfiles will happen = after # so many minutes. 0 to disable. #log_rotation_size =3D 10240 # Automatic rotation of logfiles will happen = after # so many kilobytes of log output. 0 to disabl= e. # These are relevant when logging to syslog: #syslog_facility =3D 'LOCAL0' #syslog_ident =3D 'postgres' # - When to Log - #client_min_messages =3D notice=09# Values, in order of decreasing detail: =09=09=09=09# debug5, debug4, debug3, debug2, debug1, =09=09=09=09# log, notice, warning, error #log_min_messages =3D notice=09# Values, in order of decreasing detail: =09=09=09=09# debug5, debug4, debug3, debug2, debug1, =09=09=09=09# info, notice, warning, error, log, fatal, =09=09=09=09# panic #log_error_verbosity =3D default=09# terse, default, or verbose messages #log_min_error_statement =3D panic # Values in order of increasing severity= : =09=09=09=09 # debug5, debug4, debug3, debug2, debug1, =09=09=09=09 # info, notice, warning, error, panic(off) =09=09=09=09=20 #log_min_duration_statement =3D -1 # -1 is disabled, in milliseconds. #silent_mode =3D false=09=09 # DO NOT USE without syslog or redirect_stderr # - What to Log - #debug_print_parse =3D false #debug_print_rewritten =3D false #debug_print_plan =3D false #debug_pretty_print =3D false #log_connections =3D false #log_disconnections =3D false #log_duration =3D false log_line_prefix =3D '%t '=09=09# e.g. '<%u%%%d> '=20 =09=09=09=09# %u=3Duser name %d=3Ddatabase name =09=09=09=09# %r=3Dremote host and port =09=09=09=09# %p=3DPID %t=3Dtimestamp %i=3Dcommand tag =09=09=09=09# %c=3Dsession id %l=3Dsession line number =09=09=09=09# %s=3Dsession start timestamp %x=3Dtransaction id =09=09=09=09# %q=3Dstop here in non-session processes =09=09=09=09# %%=3D'%' #log_statement =3D 'none'=09=09# none, mod, ddl, all #log_hostname =3D false #--------------------------------------------------------------------------= - # RUNTIME STATISTICS #--------------------------------------------------------------------------= - # - Statistics Monitoring - #log_parser_stats =3D false #log_planner_stats =3D false #log_executor_stats =3D false #log_statement_stats =3D false # - Query/Index Statistics Collector - #stats_start_collector =3D true #stats_command_string =3D false #stats_block_level =3D false #stats_row_level =3D false #stats_reset_on_server_start =3D true #--------------------------------------------------------------------------= - # CLIENT CONNECTION DEFAULTS #--------------------------------------------------------------------------= - # - Statement Behavior - #search_path =3D '$user,public'=09# schema names #default_tablespace =3D ''=09# a tablespace name, or '' for default #check_function_bodies =3D true #default_transaction_isolation =3D 'read committed' #default_transaction_read_only =3D false #statement_timeout =3D 0=09=09# 0 is disabled, in milliseconds # - Locale and Formatting - #datestyle =3D 'iso, mdy' #timezone =3D unknown=09=09# actually, defaults to TZ environment setting #australian_timezones =3D false #extra_float_digits =3D 0=09=09# min -15, max 2 #client_encoding =3D sql_ascii=09# actually, defaults to database encoding # These settings are initialized by initdb -- they might be changed lc_messages =3D 'English_United States'=09=09# locale for system error mess= age strings lc_monetary =3D 'English_United States'=09=09# locale for monetary formatti= ng lc_numeric =3D 'English_United States'=09=09# locale for number formatting lc_time =3D 'English_United States'=09=09=09# locale for time formatting # - Other Defaults - #explain_pretty_print =3D true #dynamic_library_path =3D '$libdir' #--------------------------------------------------------------------------= - # LOCK MANAGEMENT #--------------------------------------------------------------------------= - #deadlock_timeout =3D 1000=09# in milliseconds #max_locks_per_transaction =3D 64=09# min 10, ~200*max_connections bytes ea= ch #--------------------------------------------------------------------------= - # VERSION/PLATFORM COMPATIBILITY #--------------------------------------------------------------------------= - # - Previous Postgres Versions - #add_missing_from =3D true #regex_flavor =3D advanced=09# advanced, extended, or basic #sql_inheritance =3D true #default_with_oids =3D true # - Other Platforms & Clients - #transform_null_equals =3D false ------=_Part_232_3179578.1104422713160--