Hi

I Installed postgresql-8.0.3-1PGDG and postgresql-jdbc-8.0.3-1PGDG on
Redhat 9. Configuration as is, no changes.

java version is 1.4.2_08.

Set up a user with:

# su - postgres -c "createuser mysuer -d -A"

Created a database with:
# su - postgres -c "createdb -O myuser mydatabase"

Created some tables with:
su - myuser -c "psql -f myfile.sql -d mydatabase -U myuser"

All above ran well.

myuser does not have a password set - I don't think I need one.
If I had to use one that would be fine.

When I use Java to connect to the database then I get:

FATAL: IDENT authentication failed for user "myuser"

This was discussed earlier for version 7 in this group.

I tried -Djava.net.preferIPv4Stack=true as suggested before - with no
luck. I am not sure whether I should do this because I don't know what
other consequences that would have in the application (Tomcat).

My humble question is:

For the most straightforward, default installation, what would you
recommend as the most portable and practical way to connect via jdbc?

I am sure that the documentation lists client authentication methods
correctly and I could take it from there but I am not sure and I don't
want to create combinations that I will regret later.

Many thanks for your help.

Bernard