X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4A8225352C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Apr 2005 09:30:23 -0300 (ADT)
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 56574-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Apr 2005 12:30:14 +0000 (GMT)
Received: from rediffmail.com (unknown [203.199.83.38])
	by svr1.postgresql.org (Postfix) with SMTP id E159353428
	for <pgsql-sql@postgresql.org>; Wed, 20 Apr 2005 09:30:13 -0300 (ADT)
Received: (qmail 22621 invoked by uid 510); 20 Apr 2005 12:31:47 -0000
Date: 20 Apr 2005 12:31:47 -0000
Message-ID: <20050420123147.22620.qmail@webmail28.rediffmail.com>
Received: from unknown (203.197.42.2) by rediffmail.com via HTTP;
	20 apr 2005 12:31:47 -0000
MIME-Version: 1.0
From: "amit kumar awasthi" <amit_awasthi5@rediffmail.com>
Reply-To: "amit kumar awasthi" <amit_awasthi5@rediffmail.com>
To: pgsql-sql@postgresql.org
Subject: How to configure postgresql to accept TCP/IP connections
Content-type: multipart/alternative;
	boundary="Next_1114000307---0-203.199.83.38-21539"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.635 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, FROM_HAS_ULINE_NUMS, HTML_30_40,
	HTML_IMAGE_ONLY_20, HTML_MESSAGE, MSGID_FROM_MTA_HEADER
X-Spam-Level: *
X-Archive-Number: 200504/339
X-Sequence-Number: 21232

 This is a multipart mime message


--Next_1114000307---0-203.199.83.38-21539
Content-type: text/plain;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

  =0AHello sir =0Aactually i am working with Qt using postgresql i have to =
get connection =0A{(database("trainee"),user("trainee"))}=0Afrom the networ=
k (database remote accessing) so i have configured=0A=0Apostgresql.conf and=
 pg_hba.conf upto some extents=0A=0Athe fields that i  have configured r as=
 follows even then =0A=0Awhile connecting by giving any address (even local=
host) it flashes error=0A=0Ano pg_hba.conf entry for host 127.0.0.1 user"tr=
ainee" database "trainee"=0ASSL off =0AQPSQL:Unable to connect=0A=0Ain pg_h=
ba.conf=0A=0A# Using sockets credentials for improved security. Not availab=
le everywhere,=0A# but works on Linux, *BSD (and probably some others)=0Alo=
cal  all    all             ident   sameuser=0A#local  all    all          =
   127.0.0.1   sameuser=0Aonly this entry i have made=0A=0Ain postgresql.co=
nf=0A=0A# - Connection Settings -=0A=0Atcpip_socket =3D true=0Amax_connecti=
ons =3D 100=0A	# note: increasing max_connections costs about 500 bytes of =
shared=0A	# memory per connection slot, in addition to costs from shared_bu=
ffers=0A        # and max_locks_per_transaction.=0Asuperuser_reserved_conne=
ctions =3D 2=0A#port =3D 5432=0A#unix_socket_directory =3D '/home/trainee/t=
rainee'=0A#unix_socket_group =3D 'trainee'=0A=0A=0A#authentication_timeout =
=3D 60	# 1-600, in seconds=0A#ssl =3Dtrue=0A=0Aif i do ssl true active then=
 even ir is not giving psql prompt=0A=0A=0Aplease help me i am in trouble=0A
--Next_1114000307---0-203.199.83.38-21539
Content-type: text/html;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<P>=0A&nbsp; <BR>=0AHello sir <BR>=0Aactually i am working with Qt using po=
stgresql i have to get connection <BR>=0A{(database(&quot;trainee&quot;),us=
er(&quot;trainee&quot;))}<BR>=0Afrom the network (database remote accessing=
) so i have configured<BR>=0A<BR>=0Apostgresql.conf and pg_hba.conf upto so=
me extents<BR>=0A<BR>=0Athe fields that i&nbsp; have configured r as follow=
s even then <BR>=0A<BR>=0Awhile connecting by giving any address (even loca=
lhost) it flashes error<BR>=0A<BR>=0Ano pg_hba.conf entry for host 127.0.0.=
1 user&quot;trainee&quot; database &quot;trainee&quot;<BR>=0ASSL off <BR>=
=0AQPSQL:Unable to connect<BR>=0A<BR>=0Ain pg_hba.conf<BR>=0A<BR>=0A# Using=
 sockets credentials for improved security. Not available everywhere,<BR>=
=0A# but works on Linux, *BSD (and probably some others)<BR>=0Alocal&nbsp; =
all&nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ident&nbsp; =
 sameuser<BR>=0A#local&nbsp; all&nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp=
; &nbsp; &nbsp;  127.0.0.1&nbsp;  sameuser<BR>=0Aonly this entry i have mad=
e<BR>=0A<BR>=0Ain postgresql.conf<BR>=0A<BR>=0A# - Connection Settings -<BR=
>=0A<BR>=0Atcpip_socket =3D true<BR>=0Amax_connections =3D 100<BR>=0A&nbsp;=
 &nbsp; &nbsp;# note: increasing max_connections costs about 500 bytes of s=
hared<BR>=0A&nbsp; &nbsp; &nbsp;# memory per connection slot, in addition t=
o costs from shared_buffers<BR>=0A&nbsp; &nbsp; &nbsp; &nbsp; # and max_loc=
ks_per_transaction.<BR>=0Asuperuser_reserved_connections =3D 2<BR>=0A#port =
=3D 5432<BR>=0A#unix_socket_directory =3D '/home/trainee/trainee'<BR>=0A#un=
ix_socket_group =3D 'trainee'<BR>=0A<BR>=0A<BR>=0A#authentication_timeout =
=3D 60&nbsp; &nbsp; &nbsp;# 1-600, in seconds<BR>=0A#ssl =3Dtrue<BR>=0A<BR>=
=0Aif i do ssl true active then even ir is not giving psql prompt<BR>=0A<BR=
>=0A<BR>=0Aplease help me i am in trouble<BR>=0A=0A</P>=0A<br><br>=0A<A tar=
get=3D"_blank" HREF=3D"http://clients.rediff.com/signature/track_sig.asp"><=
IMG SRC=3D"http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffma=
il.com/inbox.htm@Bottom" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1114000307---0-203.199.83.38-21539--