Re: [JDBC] JDBC connection problem

All,

Thanks for the time and tips. Turned out to be a really stupid error - there was on old version of postres on the server that had taken port 5432, and my app was trying to connect to it (hence why the database wasn't being found), when it should have been connecting to the correct, newer instance of postres

I found this out by doing this command as Tom recommended:

$ psql -h localhost -l
psql: could not connect to server: Connection refused

        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5433?

And noticing the 5433...

A colleague of mine also noticed the multiple ports, and we now have things cleared up.

Thanks again everyone for the replies/comments

Brian

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

On Feb 5, 2008 12:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Brian Tomaszewski" <brianbanjo@gmail.com> writes:
> > Does "it" refer to the postgres server? if so, how do I check that it is
> > listening on a TCPIP port? (sorry if this sounds trivial, I am
> relatively
> > new to postgres on linux)
>
> try psql -h localhost -l
>
> regards, tom lane
>
Received on Tue Feb 5 16:23:34 2008