pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mike Engelhart <aengelhart@austin.rr.com>
To: pgsql-interfaces@postgresql.org
Subject: postmaster & JDBC
Date: Tue, 06 Jul 1999 19:49:29 -0500
Message-ID: <00cb90949000779SM1@mail.austin.rr.com> (raw)

Hi -
I'm a little confused at how the JDBC driver and the postmaster get along.
I have a servlet system built that uses connection pooling to create a
number of Connection objects to a PostgreSQL (6.5) database.   I start out
by creating 5 connections and up that by 3 new ones if it runs out of
connections (which hasn't been an issue yet).  Anyway, I just read the man
page for postmaster this evening and noticed this comment:
*****
       Only one postmaster should be running at a time in a given Postgres
installation."  Here, an  installation  means  a database directory and
postmaster port number.  You can run more than one postmaster on a machine
only if each one has a separate directory and port number.

*******

As I haven't been doing either of the aforementioned things (separate
directory and port number for each postmaster), is the JDBC driver doing
this for me?  It seems that they must be all running on the same port
because I'm calling a DriverManager.getConnection() with the same URL.

Thanks for any explanation into how this works.

Mike



view thread (2+ messages)  latest in thread

Message-ID: <00cb90949000779SM1@mail.austin.rr.com>
Permalink:  ../00cb90949000779SM1@mail.austin.rr.com/
Also on:    postgresql.org/message-id/00cb90949000779SM1@mail.austin.rr.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: aengelhart@austin.rr.com
  Subject: Re: postmaster & JDBC
  In-Reply-To: <00cb90949000779SM1@mail.austin.rr.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox