X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4ED7E9FA357 for ; Mon, 3 Jul 2006 08:58:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84383-02 for ; Mon, 3 Jul 2006 08:58:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31805.mail.mud.yahoo.com (web31805.mail.mud.yahoo.com [68.142.207.68]) by postgresql.org (Postfix) with SMTP id A27C99FA232 for ; Mon, 3 Jul 2006 08:58:01 -0300 (ADT) Received: (qmail 89398 invoked by uid 60001); 3 Jul 2006 11:58:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=fDBorYbzpKOq1VmS1Ty9+E2KDVD5RN9vREEuXinGw281qtaQ8T21mWpQjGqca003kogNlO5w/nr55dKArIBCgc1SsDLZB4pPcvripUOW44keaKFJ0IZGnD14GIzFLSRKdT1iPP/a2LkhYT/6EXYZUMGo4/9g0P+uM3WKWrDctRI= ; Message-ID: <20060703115800.89396.qmail@web31805.mail.mud.yahoo.com> Received: from [24.54.196.198] by web31805.mail.mud.yahoo.com via HTTP; Mon, 03 Jul 2006 04:58:00 PDT Date: Mon, 3 Jul 2006 04:58:00 -0700 (PDT) From: Richard Broersma Jr Subject: Re: hi i need to connect database from my system to another system To: "Penchalaiah P." , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/25 X-Sequence-Number: 25599 > 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.