From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: General Postgresql List <pgsql-sql@postgresql.org>
Subject: Re: hi i need to connect database from my system to another system
Date: Mon, 3 Jul 2006 05:26:34 -0700 (PDT)
Message-ID: <20060703122634.35398.qmail@web31808.mail.mud.yahoo.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906950835@venus.infics.com>
> 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.
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: rabroersma@yahoo.com, penchalaiahp@infics.com
Subject: Re: hi i need to connect database from my system to another system
In-Reply-To: <20060703122634.35398.qmail@web31808.mail.mud.yahoo.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