Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group