Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A67EE9FB544 for ; Wed, 20 Jun 2007 10:04:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 61722-03 for ; Wed, 20 Jun 2007 10:04:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.224]) by postgresql.org (Postfix) with ESMTP id AB5249FBEB5 for ; Wed, 20 Jun 2007 10:04:45 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id m22so168316nzf for ; Wed, 20 Jun 2007 06:04:44 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EWeqWGSoc4H/R6XOvdctS5q7guPuueLoTqm5hlb83eG11VjzGdn8wMz0fDTRwfjP7Zvz/G+qnX+AxocJms5TbCEHycg8OwOkLij23QCLccy4H6MiHlpx9wlcYr3NLLFbaFVxfhct+/8+pS2h5AR1bWoQ/YUubWNTAQRhxvhRsGc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=deobtQOsZh9IFWcONLDpPSONXEry/c4GCuoKHaVu9Mwc0dsPaNnwkqmW1UpK3HtuUdCapwqAENxzbkvzv2tIPw44Fep9NYFCSNIQbw8P8mLdY1s2Vs9yOt7vp0TPxFeuZc1rgwAjOx9Ab03Wev0BW+vTK7h2MFBL5UDmid5Mzpg= Received: by 10.114.174.2 with SMTP id w2mr286101wae.1182344683543; Wed, 20 Jun 2007 06:04:43 -0700 (PDT) Received: by 10.114.111.12 with HTTP; Wed, 20 Jun 2007 06:04:43 -0700 (PDT) Message-ID: Date: Wed, 20 Jun 2007 09:04:43 -0400 From: "Sibte Abbas" To: "Ira Berdichevsky" Subject: Re: Problem with PostgreSQL 8.2 on Linux Redhat Cc: pgsql-admin@postgresql.org In-Reply-To: <2BCD90A464201D4C852B40DE14202C7E0262850F@dhost002-38.dex002.intermedia.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2BCD90A464201D4C852B40DE14202C7E0262850F@dhost002-38.dex002.intermedia.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/195 X-Sequence-Number: 25863 On 6/20/07, Ira Berdichevsky wrote: > > > Hi, > I have some problem to configure PostgreSQL . > My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL > version 8.2.4. > I configured database : initdb -D /var/lib/pgsql/data -U postgres . > I changed pg_hba.conf and postgresql.config files : > pg_hba.conf: > local all all trust > host all all 127.0.0.1/32 md5 > host all all 0.0.0./0 md5 > host all all 10.0.0.40/128 md5 > > postgresql.config: > listen_addresses = '*' > port = 5433 > > I started POstgreSQL and checked that it is run. > I checked with "psql -h 10.0.0.40 -p 5433" command and saw that PostgreSQL > respond it. > The problem is I still couldn't connect to PostgreSQL from Windows pgAdmin > agent. > I have this error connection: "Server doesn't listen". > I don't have problem with firewall. > Do you have any idea what is the problem? > Thanks. > Ira > Since you are not using the default port, have you configured pgAdmin's port to 5433? -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com