Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T0qMa-0001vR-KU for pgsql-admin@postgresql.org; Mon, 13 Aug 2012 08:51:04 +0000 Received: from 10610.x.rootbsd.net ([204.109.60.69] helo=vps001.shopzeus.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T0qMZ-0001nI-MX for pgsql-admin@postgresql.org; Mon, 13 Aug 2012 08:51:04 +0000 Received: from [192.168.1.105] (localhost [127.0.0.1]) by vps001.shopzeus.com (8.14.3/8.14.3) with ESMTP id q7D8p5FY046254; Mon, 13 Aug 2012 04:51:05 -0400 (EDT) (envelope-from gandalf@shopzeus.com) Message-ID: <5028BFF3.1090508@shopzeus.com> Date: Mon, 13 Aug 2012 10:50:59 +0200 From: Laszlo Nagy User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120714 Thunderbird/14.0 MIME-Version: 1.0 To: Richard Harper , pgsql-admin@postgresql.org Subject: Re: database not found References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/84 X-Sequence-Number: 39905 On 2012-08-12 23:13, Richard Harper wrote: > Thanks for the help (server not running). The server is running and > accepting connections, but when I attempt a tcp/ip connection I get > the message: FATAL: database "d3_jchem" does not exist > I can connect using psql. I seems not to be finding the database. > Perhaps I have something wrong in the pg_hba.conf. I defined PGDATA > and listen_address (= '*') in postgresql.conf. Are you sure that you are trying to connect to the same database server? Are you running psql and the other program on the same computer? Did you try to use -h for psql with your host? psql -h 127.0.0.1 -d d3_jchem Do you have ports forwarded on any of the machines?