Thread: JDBC driver & local server

JDBC driver & local server

From
stm23
Date:
hi

i would have liked to install a new version of postgresql, but i haven't been
able to configure it, having tryed many times - i value my sanity too highly

however, i have discovered that i have version 7.3.2 installed.  this must be
the version that came with my Redhat 8.0 distribution. i need java support
(for a 3rd year databases uni course).  is it possible to build the JDBC
driver on top of my current version?  (maybe i have it, how could i find out?)

also, when i type the command: psql
i get:
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

how can i go about setting up a local server on this socket?

thanx, i really appreciate any advice u can offer
sam







Re: JDBC driver & local server

From
Christian Pöcher
Date:
----- Original Message -----
From: "stm23" <STM23@student.canterbury.ac.nz>
To: <pgsql-novice@postgresql.org>
Sent: Tuesday, March 09, 2004 7:14 AM
Subject: [NOVICE] JDBC driver & local server

> also, when i type the command: psql
> i get:
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Is the postmaster running on your system? It is the main process of the
server and psql is merely an interactive terminalclient to the server. Basic
documentation is here:
http://www.postgresql.org/docs/7.4/interactive/tutorial-start.html For the
beginning the first chapter should be suffice.

chris


Re: JDBC driver & local server

From
Mohan
Date:
Hi Sam,
Socket error:
You need to install any web server and start the service to come out of the socket
error.
Also you have to mention the localhost in the pg_hba.conf file.
Regards,
Mohan

stm23 wrote:

> hi
>
> i would have liked to install a new version of postgresql, but i haven't been
> able to configure it, having tryed many times - i value my sanity too highly
>
> however, i have discovered that i have version 7.3.2 installed.  this must be
> the version that came with my Redhat 8.0 distribution. i need java support
> (for a 3rd year databases uni course).  is it possible to build the JDBC
> driver on top of my current version?  (maybe i have it, how could i find out?)
>
> also, when i type the command: psql
> i get:
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> how can i go about setting up a local server on this socket?
>
> thanx, i really appreciate any advice u can offer
> sam
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings