JDBC with POSTGRES
Hello,
I have a little problem with connecting a Java standalone application
and Postgresql 6.3.2. In fact it doesn't connect.
Before sending you the error output, is anybody can tell me if I have
to declare a user/password in the h_dba_conf if I want this to work?
I ask this because I can't test this now. Could you give me the way?
I use the JDBC of the distribution, so normally it works...
Many thanks.
PS: I heard some news about PostgreSQL crash. For me, I use Postgres from
the beginning (it was Postgres95) and I never see a backend crash. Ok I
don't do many things with my databases and there are small but never one
problem... All my gratitude to the contributors.
On Tue, 25 Aug 1998, Gilles Darold wrote:
Hello,
I have a little problem with connecting a Java standalone application
and Postgresql 6.3.2. In fact it doesn't connect.Before sending you the error output, is anybody can tell me if I have
to declare a user/password in the h_dba_conf if I want this to work?
I ask this because I can't test this now. Could you give me the way?
Three things:
1: Make sure you start the postmaster with -i (to enable TCP/IP)
2: have the clients ip/subnet-mask in pg_hba.conf (true for all
interfaces)
3: create the users within the database (login as the DBA, and use
CREATE USER)
Send the error, as it usually indicates where the problem lies.
PS: I heard some news about PostgreSQL crash. For me, I use Postgres from
the beginning (it was Postgres95) and I never see a backend crash. Ok I
don't do many things with my databases and there are small but never one
problem... All my gratitude to the contributors.
I get them occasionally with the stable releases, but it's usually when
I've done something stupid, or just hammered the server.
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf