X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C5D343A235D for ; Thu, 30 Dec 2004 14:20:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63345-01 for ; Thu, 30 Dec 2004 14:20:03 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 3B94D3A218E for ; Thu, 30 Dec 2004 14:20:05 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Dec 2004 08:20:06 -0600 Subject: Re: Not connect to server! From: Scott Marlowe To: Amauri Pimenta Cc: pgsql-admin@postgresql.org In-Reply-To: <8718db24041230054625d4021e@mail.gmail.com> References: <8718db24041230054625d4021e@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1104416406.5893.57.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 30 Dec 2004 08:20:06 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/266 X-Sequence-Number: 15852 On Thu, 2004-12-30 at 07:46, Amauri Pimenta wrote: > Hello! > > Well, i just try to connect to server, but without successfull! > > the error is "Is the server running on host "172.22.0.23" and > accepting TCP/IP Connections on port 5432?" > > Just look documentation and follow the steps and the error continue! > > Please, help me! its urgent! Are you starting your database with pg_ctl or by typing postmaster by hand? If you're using pg_ctl, edit your $PGDATA/postgresql.conf file to have tcpip_socket = true, and edit $PGDATA/pg_hba.conf to allow your machine to connect. Look for a line that looks like this: host all all 127.0.0.1 255.255.255.0 trust and edit accordingly, then restart your server. If you're starting postmaster by hand, I'd recommend switching to using pg_ctl. Generally running postmaster by hand is done by people more expert at running postgresql than folks not sure why they can't get TCP/IP connections to work. :)