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?