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

Isolated databases or instances

From: "Henry, Nigel, CYFD" <nigel(dot)henry(at)state(dot)nm(dot)us>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Isolated databases or instances
Date: 2007-02-16 19:18:37
Message-ID: 2488267002735E4293095085A7B5D86401446CAA@CEXMB4.nmes.lcl (view raw or flat)
Thread:
Lists: pgsql-admin
We are at the beginning of the building of a 3-tier development/test/uat environment.   We would like some advice on how the PostgreSQL database should be configured for this environment. 
 
The environments will be installed on three blades of an IBM Blade Center.  Due to budget restrictions, we are building the three environments with separate install instances of the HTTP server (3) 1st blade; separate install instances of the application server (3) 2nd blade -- the HTTP server will be installed from the application build rather than as a separate install; and three PostgreSQL database instances on the last blade.
 
My concern is that building the PostgreSQL databases as instances from a single binary could lead to problems in a development environment.  My recommendation is to create three isolated databases (3 binaries) for each environment to mitigate an unforeseen mishaps.
 
I would like some advice on what would be the best practice for building a development environment, such as described above, in the type of environment described above.
 
Nigel D. Henry 
State of New Mexico 
Computer Software Engineer 
Children, Youth, & Family Division 
Nigel(dot)Henry(at)state(dot)nm(dot)us 
(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.


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. 



Responses

pgsql-admin by date

Next:From: Henry, Nigel, CYFDDate: 2007-02-16 19:32:35
Subject: Isolated databases or instances
Previous:From: Ezequias Rodrigues da RochaDate: 2007-02-16 19:11:39
Subject: Fwd: [ADMIN] Debug (is it PostgreSQL?)

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