Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gandalf@shopzeus.com>) id 1T0vhS-0006Cw-Bj
	for pgsql-admin@postgresql.org; Mon, 13 Aug 2012 14:32:58 +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 <gandalf@shopzeus.com>) id 1T0vhQ-0006ZQ-3h
	for pgsql-admin@postgresql.org; Mon, 13 Aug 2012 14:32:57 +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 q7DEWxWm070108
	for <pgsql-admin@postgresql.org>; Mon, 13 Aug 2012 10:33:00 -0400 (EDT)
	(envelope-from gandalf@shopzeus.com)
Message-ID: <50291015.1080608@shopzeus.com>
Date: Mon, 13 Aug 2012 16:32:53 +0200
From: Laszlo Nagy <gandalf@shopzeus.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120714 Thunderbird/14.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: database not found
References: 
 <CAHr-pYEvLFyQTknMyZsfHgGOcYSXad=SXLeXwDEuopqnio5esg@mail.gmail.com>
In-Reply-To: 
 <CAHr-pYEvLFyQTknMyZsfHgGOcYSXad=SXLeXwDEuopqnio5esg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201208/86
X-Sequence-Number: 39907

On 2012-08-13 16:18, Richard Harper wrote:
> All of the databases appear to be where they should be.  As an 
> experiment, I tried tcp/ip to the 'posgres' database.  That worked. 
>  Thanks to Ray, I worked that out.  Per the suggestion I tried:
> psql -h 127.0.0.1 -d d3_jchem.  It connected after requesting a 
> password (SSL).  I still cannot connect to d3_jchem.  Also, an 
> additional role I created (su) was not found.  Could it be a file 
> protection setting.  I notice that I cannot even ls the ..../base 
> directory without being superuser.  That does not seem right.  Thanks 
> for your patience and suggestions.
It is not a file protection setting. The postgresql server owns all the 
database files, and you can only access those files through the service. 
Your problem is that you have multiple postgresql server instances 
running. Either on the same machine, or on different machines.

Try to login with the postgresql superuser (pgsql or postgres). Then do 
these:

select inet_server_addr()
select version()

Do this from both programs (psql and the other program) and compare the 
results. Probably you will find out that you are connecting to two 
different database instances.

Can you please tell us more about the other (non-psql) program? What is 
that program? On what system have you installed that application? There 
are some programs that run their own embedded postgresql server. It is 
possible that you are running a program that uses an embedded PostgreSQL 
server.

Best,

    Laszlo