From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
To: pgsql-sql@postgresql.org
Subject: Re: hi i need to connect database from my system to another system
Date: Mon, 3 Jul 2006 04:58:00 -0700 (PDT)
Message-ID: <20060703115800.89396.qmail@web31805.mail.mud.yahoo.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C9069505D6@venus.infics.com>
> 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.html#AUTH-PG-HBA-CONF
Also, secure shell also works well when connecting from another system.
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: <20060703115800.89396.qmail@web31805.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