Re: A few questions

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Jai Beales" <JaiBeales(at)identilam(dot)co(dot)uk>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: A few questions
Date: 2002-09-11 10:46:41
Message-ID: 03AF4E498C591348A42FC93DEA9661B8845D@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Jai Beales [mailto:JaiBeales(at)identilam(dot)co(dot)uk]
> Sent: 11 September 2002 11:31
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] A few questions
>
>
> Hi. Any advice on the following would be much appreciated...
>
> Is it possible to run 2 instances of postgres on the same
> machine with different data directory, pg_hba.conf, port etc?
> I'm wondering this really for test reasons and anticipating
> having 2 postgres connections with different security
> implications which might eventually run on separate servers.

Yes, I've done this quite successfully. Just make sure that the port and
data directory are definately not the same.

> Are there any issues with the number of databases created? As
> well as one large one for browser access I would like to have
> many small client specific db's for direct ODBC connections.

Not to my knowledge.

> Has any one tried stress testing with many ODBC connections
> to postgres (obviously i can do this myself and will!)?

An ODBC connection isn't really any different from any other TCP/IP
connection. I'm sure others have more stressed systems than me, but I've
never had any trouble with up to 80 or so connections on a dual PIII
933MHz, 1Gb system. In fact, it barely breaks a sweat.

Regards, Dave.

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-09-11 12:55:44 Re: [HACKERS] ODBC problem/question
Previous Message Jai Beales 2002-09-11 10:31:06 A few questions