Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Sean Davis'" <sdavis2@mail.nih.gov>,
	"'Frank Habermann'" <postgres@lordlamer.de>, <pgsql-sql@postgresql.org>
Subject: Re: user connection over tcp
Date: Mon, 18 Apr 2005 19:17:36 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcVEHRBpN5VTza6MRmGm6UNj/gG/CgAABTCg
In-reply-to: <012701c5441c$8916e800$5179f345@WATSON>
Message-Id: <20050418135117.7E5E653818@svr1.postgresql.org>

Edit "postgres.conf" and "pg_hba.conf" to access database from a remote
machine

Edit "postgres.conf":
------------------------------------------
listen_addresse='*'

Edit "pg_hba.conf":
------------------------------------------
host	all	    all 	10.1.11.54	255.255.255.0
trust


Thanks
Dinesh Pandey


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Sean Davis
Sent: Monday, April 18, 2005 7:13 PM
To: Frank Habermann; pgsql-sql@postgresql.org
Subject: Re: [SQL] user connection over tcp

Did you start the postmaster with -i to allow tcp connections?  What is the 
error that you get when you try to connect?

Sean

----- Original Message ----- 
From: "Frank Habermann" <postgres@lordlamer.de>
To: <pgsql-sql@postgresql.org>
Sent: Monday, April 18, 2005 9:31 AM
Subject: [SQL] user connection over tcp


> hello!
>
> i have some problems to understand the manual with pg_hba.conf.
>
> i use a tcp connection with phppgadmin to connect to the db. in my 
> pg_hba.conf i say for this connection trust! in phppgadmin i need the for 
> my user the right password to connect. but the manual says that every 
> password will accepted. why isnt that work at me?
>
> i also try password in pg_hba.conf for my tcpconnections. but after this i

> cant connect to the db. but the manual says that users with right password

> can connect. but this doesnt work here.
>
> can somebody explain me whats wrong with me or my postgre?!
>
> thx
>
> frank habermann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
> 


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly