Re: A few questions

> -----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.