On Fri, 13 Mar 1998, The Hermit Hacker wrote:
>
> Redirected to 'the proper list' - pgsql-interfaces@postgresql.org
>
> On Fri, 13 Mar 1998, Stephan B. Doliov wrote:
>
> > On Fri, 13 Mar 1998, e. lambrecht wrote:
> >
> > > Start the postmaster with the '-i' option to enable connections via
> > > sockets. The new server defaults to using unix domain sockets, which
> > > jdbc doesn't use. I had the same problem - drove me crazy for a while.
> > >
> > ugh. i thought i said in the post that i was using the -i option, still
> > the same problem though.
> >
> > ps -ef | grep postm
> > postgres 4038 1 0 13:50:16 pts/4 0:00
> > /opt/postgres/bin/postmaster -i
> >
> > so there you have it. am i specifying the url incorrectly. i am trying
> > java basic.java jdbc:postgresql:funnystuff doliov xxxxxx
Idealy this should be:
java example.basic jdbc:postgresql:funnystuff doliov xxxxxx
note: no .java, and all the examples are in a package example.
Apart from that, it looks ok.
> >
> > also trying
> > java basic.java jdbc:postgresl:funnystuff?auth=password doliov xxxxxx
This is the old style URL - auth is no longer required in 6.3
> > results in the same error message (connection refused). and the postmaster
> > log confirms the authentication failure with:
> > User authentication failed
What have you got set in $PGDATA/pg_hba.conf for the client?
> > (btw, i am running the java program from the jdbc/example directory, with
> > calss path set approately. java has no problem loading the driver).
Again, they should be run in the jdbc not jdbc/example directories.
--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk