pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddatabase not found
5+ messages / 3 participants
[nested] [flat]
* database not found
@ 2012-08-12 21:13 Richard Harper <drrwharper@gmail.com>
2012-08-13 08:50 ` Re: database not found Laszlo Nagy <gandalf@shopzeus.com>
0 siblings, 1 reply; 5+ messages in thread
From: Richard Harper @ 2012-08-12 21:13 UTC (permalink / raw)
To: pgsql-admin
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.
Dick
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: database not found
2012-08-12 21:13 database not found Richard Harper <drrwharper@gmail.com>
@ 2012-08-13 08:50 ` Laszlo Nagy <gandalf@shopzeus.com>
0 siblings, 0 replies; 5+ messages in thread
From: Laszlo Nagy @ 2012-08-13 08:50 UTC (permalink / raw)
To: Richard Harper <drrwharper@gmail.com>; pgsql-admin
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: database not found
@ 2012-08-13 14:18 Richard Harper <drrwharper@gmail.com>
2012-08-13 14:32 ` Re: database not found Laszlo Nagy <gandalf@shopzeus.com>
2012-08-13 17:29 ` Re: database not found Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Richard Harper @ 2012-08-13 14:18 UTC (permalink / raw)
To: pgsql-admin
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.
Dick
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: database not found
2012-08-13 14:18 Re: database not found Richard Harper <drrwharper@gmail.com>
@ 2012-08-13 14:32 ` Laszlo Nagy <gandalf@shopzeus.com>
1 sibling, 0 replies; 5+ messages in thread
From: Laszlo Nagy @ 2012-08-13 14:32 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: database not found
2012-08-13 14:18 Re: database not found Richard Harper <drrwharper@gmail.com>
@ 2012-08-13 17:29 ` Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2012-08-13 17:29 UTC (permalink / raw)
To: Richard Harper <drrwharper@gmail.com>; +Cc: pgsql-admin
On Mon, Aug 13, 2012 at 8:18 AM, Richard Harper <drrwharper@gmail.com> 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.
Any upper case characters in there and it's case folding maybe?
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-08-13 17:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-12 21:13 database not found Richard Harper <drrwharper@gmail.com>
2012-08-13 08:50 ` Laszlo Nagy <gandalf@shopzeus.com>
2012-08-13 14:18 Re: database not found Richard Harper <drrwharper@gmail.com>
2012-08-13 14:32 ` Laszlo Nagy <gandalf@shopzeus.com>
2012-08-13 17:29 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox