From: amit kumar awasthi <amit_awasthi5@rediffmail.com>
To: pgsql-sql@postgresql.org
Subject: How to configure postgresql to accept TCP/IP connections
Date: 20 Apr 2005 12:31:47 -0000
Message-ID: <20050420123147.22620.qmail@webmail28.rediffmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: amit_awasthi5@rediffmail.com
Subject: Re: How to configure postgresql to accept TCP/IP connections
In-Reply-To: <20050420123147.22620.qmail@webmail28.rediffmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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