DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=i3EM4vRk7zTqGFnLpbifWOzmQwxufgA/rTDKWdwXTZwuPcRzkehBv14SoCQ0Ge8qvhHwWa+dS1qmW5TpnQLI2xg2JVrRUsoiWQm9hkNP45O1nXP1InyZESVaQ/plDnJgZQUWR5FFwwkQi+Qn7WD0hDR10NNQsXy+yrJiHTmtSqw=
	;
Message-ID: <20060703122634.35398.qmail@web31808.mail.mud.yahoo.com>
Date: Mon, 3 Jul 2006 05:26:34 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: hi i need to connect database from my system to another  system
To: "Penchalaiah P." <penchalaiahp@infics.com>
Cc: General Postgresql List <pgsql-sql@postgresql.org>
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906950835@venus.infics.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> If u don't mind can u please tell me clearly.. where I have start -I or
> how to start postgresql with -I

> > I am using postgresql database server... in my system.. if I want to
> > connect to this database server from other system..Or how can I use
> this
> > database server  in other machine ..
> >
> > How can I do this..if any one have idea about this please give me
> brief
> > description
> 
> You need to start the postgresql server with the "-i" option to allow
> TCP/IP connections.  Then
> you need to configure your pg_hba.conf file to set the permissions about
> which users can connect
> to which databases.
> 
> Notice the pg_ctl section for starting postgresql.
> http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html
> 
> Notice the -o "options" section that can be set. (in this case you want
> -i)
> http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html
> 
> Finally notice, the section on the pg_hba.conf file.
> http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm
> l#AUTH-PG-HBA-CONF
> 
> Also, secure shell also works well when connecting from another system.

Don't forget to include the pgsql-sql list in your reply's. :-)  The individuals on this list have
varying degree of experience and knowledge of postgresql.  So if you only respond to me, you would
be limiting yourself to my meager experience and knowledge. ;-)

To start off with, it would be helpful to know which OS version of PostgreSQL you are using.  The
windows versions is pre-configured to start with the "-i" option for allowing TCP/IP connections.

Secondly,  how are you trying to connect to your postgresql server from another system?  What
error messages are you getting.

Regards,

Richard Broersma Jr.