pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNot connect to server!
5+ messages / 3 participants
[nested] [flat]
* Not connect to server!
@ 2004-12-30 13:46 Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 14:20 ` Re: Not connect to server! Scott Marlowe <smarlowe@g2switchworks.com>
2004-12-30 14:35 ` Re: Not connect to server! Jason Dixon <jason@dixongroup.net>
0 siblings, 2 replies; 5+ messages in thread
From: Amauri Pimenta @ 2004-12-30 13:46 UTC (permalink / raw)
To: pgsql-admin
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?"
Just look documentation and follow the steps and the error continue!
Please, help me! its urgent!
Regards,
Amauri Pimenta Junior
Consultor BI
Softtek Brasil
Batera banda Riffy
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Not connect to server!
2004-12-30 13:46 Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
@ 2004-12-30 14:20 ` Scott Marlowe <smarlowe@g2switchworks.com>
1 sibling, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2004-12-30 14:20 UTC (permalink / raw)
To: Amauri Pimenta <amauripimenta@gmail.com>; +Cc: pgsql-admin
On Thu, 2004-12-30 at 07:46, 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?"
>
> Just look documentation and follow the steps and the error continue!
>
> Please, help me! its urgent!
Are you starting your database with pg_ctl or by typing postmaster by
hand? If you're using pg_ctl, edit your $PGDATA/postgresql.conf file to
have tcpip_socket = true, and edit $PGDATA/pg_hba.conf to allow your
machine to connect. Look for a line that looks like this:
host all all 127.0.0.1 255.255.255.0 trust
and edit accordingly, then restart your server.
If you're starting postmaster by hand, I'd recommend switching to using
pg_ctl. Generally running postmaster by hand is done by people more
expert at running postgresql than folks not sure why they can't get
TCP/IP connections to work. :)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Not connect to server!
2004-12-30 13:46 Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
@ 2004-12-30 14:35 ` Jason Dixon <jason@dixongroup.net>
2004-12-30 16:05 ` Re: Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Jason Dixon @ 2004-12-30 14:35 UTC (permalink / raw)
To: Amauri Pimenta <amauripimenta@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Not connect to server!
2004-12-30 13:46 Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 14:35 ` Re: Not connect to server! Jason Dixon <jason@dixongroup.net>
@ 2004-12-30 16:05 ` Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 16:47 ` Re: Not connect to server! Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 5+ messages in thread
From: Amauri Pimenta @ 2004-12-30 16:05 UTC (permalink / raw)
To: Jason Dixon <jason@dixongroup.net>; +Cc: pgsql-admin
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 <jason@dixongroup.net> 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
Attachments:
pg_hba.conf (text/plain, 2.9K) download
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# 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
# (between 0 and 32 (IPv6) or 128(IPv6) inclusive) that specifies
# the number of significant bits in the mask Also, you can use a
# separate IP address and netmask to specify the set of hosts.
#
# METHOD can be "trust", "reject", "md5", "crypt", "password",
# "krb4", "krb5", "ident", or "pam". Note that "password" uses
# clear-text passwords; "md5" is preferred for encrypted passwords.
# OPTION is the ident map or the name of the PAM service.
#
# Database and user names containing spaces, commas, quotes and other special
# characters can be quoted. Quoting one of the keywords "all", "sameuser" or
# "samegroup" makes the name lose its special character, and just match a
# 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
postgresql.conf (text/plain, 10.8K) download
#-----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' 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=on'. 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
# to SIGHUP the postmaster for the changes to take effect, or use
# "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 = 'ConfigDir' # use data in another directory
# hba_file = 'ConfigDir/pg_hba.conf' # the host-based authentication file
# ident_file = '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 = '(none)' # write an extra pid file
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
#listen_addresses = '172.22.0.23'# what IP interface(s) to listen on;
# defaults to stkrj-trn01, '*' = any
#tcpip_socket = true
port = 5432
max_connections = 100
# note: increasing max_connections costs about 500 bytes of shared
# memory per connection slot, in addition to costs from shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#rendezvous_name = '' # defaults to the computer name
# - Security & Authentication -
#authentication_timeout = 60 # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false
#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------
# - Memory -
shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each
#work_mem = 1024 # min 64, size in KB
#maintenance_work_mem = 16384 # min 1024, size in KB
#max_stack_depth = 2048 # min 100, size in KB
# - Free Space Map -
#max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~50 bytes each
# - Kernel Resource Usage -
#max_files_per_process = 1000 # min 25
#preload_libraries = ''
# - Cost-Based Vacuum Delay -
#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 0-10000 credits
# - Background writer -
#bgwriter_delay = 200 # 10-10000 milliseconds between rounds
#bgwriter_percent = 1 # 0-100% of dirty buffers in each round
#bgwriter_maxpages = 100 # 0-1000 buffers max per round
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------
# - Settings -
#fsync = true # turns forced synchronization on or off
#wal_sync_method = fsync # the default varies across platforms:
# fsync, fdatasync, open_sync, or open_datasync
#wal_buffers = 8 # min 4, 8KB each
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000
# - Checkpoints -
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in seconds
#checkpoint_warning = 30 # 0 is off, in seconds
# - Archiving -
#archive_command = '' # command to use to archive a logfile segment
#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------
# - Planner Method Configuration -
#enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true
# - Planner Cost Constants -
#effective_cache_size = 1000 # typically 8KB each
#random_page_cost = 4 # units are one sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)
# - Genetic Query Optimizer -
#geqo = true
#geqo_threshold = 12
#geqo_effort = 5 # range 1-10
#geqo_pool_size = 0 # selects default based on effort
#geqo_generations = 0 # selects default based on effort
#geqo_selection_bias = 2.0 # range 1.5-2.0
# - Other Planner Options -
#default_statistics_target = 10 # range 1-1000
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit JOINs
#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------
# - Where to Log -
log_destination = 'stderr' # Valid values are combinations of stderr,
# syslog and eventlog, depending on
# platform.
# This is relevant when logging to stderr:
redirect_stderr = true # Enable capturing of stderr into log files.
# These are only relevant if redirect_stderr is true:
#log_directory = 'pg_log' # Directory where log files are written.
# May be specified absolute or relative to PGDATA
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
# May include strftime() escapes
#log_truncate_on_rotation = false # If true, any existing log file of the
# same name as the new log file will be truncated
# 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
# files in all cases.
#log_rotation_age = 1440 # Automatic rotation of logfiles will happen after
# so many minutes. 0 to disable.
#log_rotation_size = 10240 # Automatic rotation of logfiles will happen after
# so many kilobytes of log output. 0 to disable.
# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
# - When to Log -
#client_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error
#log_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
#log_error_verbosity = default # terse, default, or verbose messages
#log_min_error_statement = panic # Values in order of increasing severity:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, panic(off)
#log_min_duration_statement = -1 # -1 is disabled, in milliseconds.
#silent_mode = false # DO NOT USE without syslog or redirect_stderr
# - What to Log -
#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
#log_disconnections = false
#log_duration = false
log_line_prefix = '%t ' # e.g. '<%u%%%d> '
# %u=user name %d=database name
# %r=remote host and port
# %p=PID %t=timestamp %i=command tag
# %c=session id %l=session line number
# %s=session start timestamp %x=transaction id
# %q=stop here in non-session processes
# %%='%'
#log_statement = 'none' # none, mod, ddl, all
#log_hostname = false
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------
# - Statistics Monitoring -
#log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false
# - Query/Index Statistics Collector -
#stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------
# - Statement Behavior -
#search_path = '$user,public' # schema names
#default_tablespace = '' # a tablespace name, or '' for default
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0 # 0 is disabled, in milliseconds
# - Locale and Formatting -
#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults to TZ environment setting
#australian_timezones = false
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults to database encoding
# These settings are initialized by initdb -- they might be changed
lc_messages = 'English_United States' # locale for system error message strings
lc_monetary = 'English_United States' # locale for monetary formatting
lc_numeric = 'English_United States' # locale for number formatting
lc_time = 'English_United States' # locale for time formatting
# - Other Defaults -
#explain_pretty_print = true
#dynamic_library_path = '$libdir'
#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------
#deadlock_timeout = 1000 # in milliseconds
#max_locks_per_transaction = 64 # min 10, ~200*max_connections bytes each
#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------
# - Previous Postgres Versions -
#add_missing_from = true
#regex_flavor = advanced # advanced, extended, or basic
#sql_inheritance = true
#default_with_oids = true
# - Other Platforms & Clients -
#transform_null_equals = false
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Not connect to server!
2004-12-30 13:46 Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 14:35 ` Re: Not connect to server! Jason Dixon <jason@dixongroup.net>
2004-12-30 16:05 ` Re: Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
@ 2004-12-30 16:47 ` Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2004-12-30 16:47 UTC (permalink / raw)
To: Amauri Pimenta <amauripimenta@gmail.com>; +Cc: Jason Dixon <jason@dixongroup.net>; pgsql-admin
You need to restart your server after the changes. If you're not sure
how to do that:
su - postgres (from the root account usually)
pg_ctl restart
On Thu, 2004-12-30 at 10:05, Amauri Pimenta wrote:
> 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 <jason@dixongroup.net> 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
> >
> >
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-12-30 16:47 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-30 13:46 Not connect to server! Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 14:20 ` Scott Marlowe <smarlowe@g2switchworks.com>
2004-12-30 14:35 ` Jason Dixon <jason@dixongroup.net>
2004-12-30 16:05 ` Amauri Pimenta <amauripimenta@gmail.com>
2004-12-30 16:47 ` Scott Marlowe <smarlowe@g2switchworks.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox