Scott, We will try the single PostgreSQL instance with 3 databases configured in it. Nigel D. Henry State of New Mexico Computer Software Engineer Children, Youth, & Family Division [EMAIL PROTECTED] (505) 841-6631 Confidentiality Notice: This e-mail, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided for under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message.
________________________________ From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Fri 2/16/2007 4:10 PM To: Henry, Nigel, CYFD Cc: pgsql-admin@postgresql.org Subject: RE: [ADMIN] Isolated databases or instances On Fri, 2007-02-16 at 16:30, Henry, Nigel, CYFD wrote: > More information: > > As stated, this is going to be a SLES 9.3 environment -- 64-bit. > VMWare, for now, is out of the question because we currently only have > IBM HS20 blades which are unable to host the 64-bit environment in > VMWare. So we're running the OS on bare metal. As I mentioned in my > original post, we are trying to use our blades wisely by creating the > three separate, isolated environments across the blades. Much like > this: # > separate install instances of the HTTP server (3 -- DEV/Test/UAT) 1st > blade; > separate install instances of the application server > (3 -- DEV/Test/UAT) 2nd blade -- the HTTP server will be installed > from the application build rather than as a separate install; and > three PostgreSQL database instances (3 -- DEV/Test/UAT) on the last > blade. > This is the only way we can create three environments since even > though we have three blades, the blade housing databases belongs to > the DBA group. The application being developed is in Java and is not > a transaction-intensive application. So, would you need to do things like upgrade postgresql one environment at a time, or would you be ok with all three environments sharing one pgsql instance with three separate databases in it? One instance is much easier to setup and maintain, and it is often the case in a dev/uat/test environment that only one instance is ever working hard, so the performance will likely be better on a single instance than on multiples. You could also have pg_hba.conf set to only let certain users connect from certain ips to certain databases, limiting the possibility of one layer (uat/test/dev) hitting the wrong database. If you need the isolation provided by three separate instances, then you can easily do it by creating a couple extra users, and putting the dbs in their home directories running on different ports. That way, the pg82dev user and the pg82uat user and the pg82test user all run on, say, ports 5433, 5434, and 5435, and they can't accidentally mess each other up, because they're completely different. You don't need a special install or anything. Just keep in mind you'll need to allocate enough shared memory to make all three instances happy. Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.
