> -----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.
pgsql-odbc by date
|Next:||From: Dave Page||Date: 2002-09-11 12:55:44|
|Subject: Re: [HACKERS] ODBC problem/question|
|Previous:||From: Jai Beales||Date: 2002-09-11 10:31:06|
|Subject: A few questions|