From: | Peter T Mount <pgint(at)maidast(dot)demon(dot)co(dot)uk> |
---|---|
To: | "Stephan B(dot) Doliov" <doliov(at)statsol(dot)com> |
Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc -i not the problem |
Date: | 1998-03-15 08:59:30 |
Message-ID: | Pine.LNX.3.95.980315085618.21425B-100000@maidast |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Fri, 13 Mar 1998, The Hermit Hacker wrote:
>
> Redirected to 'the proper list' - pgsql-interfaces(at)postgresql(dot)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(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-03-15 09:08:57 | Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc - grief |
Previous Message | Constantin Teodorescu | 1998-03-14 12:23:54 | Re: [INTERFACES] pgaccess: I can't save a view |