How to configure postgresql to accept TCP/IP connections

From: "amit kumar awasthi" <amit_awasthi5(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to configure postgresql to accept TCP/IP connections
Date: 2005-04-20 12:31:47
Message-ID: 20050420123147.22620.qmail@webmail28.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello sir
actually i am working with Qt using postgresql i have to get connection
{(database("trainee"),user("trainee"))}
from the network (database remote accessing) so i have configured

postgresql.conf and pg_hba.conf upto some extents

the fields that i have configured r as follows even then

while connecting by giving any address (even localhost) it flashes error

no pg_hba.conf entry for host 127.0.0.1 user"trainee" database "trainee"
SSL off
QPSQL:Unable to connect

in pg_hba.conf

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
local all all ident sameuser
#local all all 127.0.0.1 sameuser
only this entry i have made

in postgresql.conf

# - Connection Settings -

tcpip_socket = true
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
#port = 5432
#unix_socket_directory = '/home/trainee/trainee'
#unix_socket_group = 'trainee'

#authentication_timeout = 60 # 1-600, in seconds
#ssl =true

if i do ssl true active then even ir is not giving psql prompt

please help me i am in trouble

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-04-20 12:41:50 Function to either return one or all records
Previous Message Ramakrishnan Muralidharan 2005-04-20 10:21:25 Re: 'Select INTO" in Execute (dynamic query )