Re: Embedding Postgres in Java Application

On Sun, 16 Jan 2005, Jasper Potts wrote:

> Is there a way of creating a JDBC connection to the db not over a
> network socket?

No.  Java does not have support for unix sockets.

> The other way is going to be to start/stop the database from Java by
> calling "pg_ctl start/stop". But that issues with this because of the
> windows restrictions that postgres can't be run as a user with admin
> privileges. Any Ideas?
>

Even if Java did support unix sockets you would still have to start the
server running.  PostgreSQL is not designed to be an embedded database
(especially not by Java).  This doesn't seem like a great idea, perhaps
one of the Java databases would be more appropriate for this task?

Kris Jurka