Whoa! You mean these aren't already separate database clusters or even separate
systems? I am very shocked, you can't do a proper Dev --> QAT --> Prod
environment if all three systems are run by the same postmaster, or on the same
host imo. But maybe I'm just over cautious, or worked on systems wh
On Sun, Nov 16, 2003 at 10:47:22AM -0800, Joshua D. Drake wrote:
>
> >Whoa! You mean these aren't already separate database clusters or
> >even separate systems? I am very shocked, you can't do a proper Dev
> >--> QAT --> Prod environment if all three systems are run by the same
> >postmaster, or
> Whoa! You mean these aren't already separate database clusters or even
> separate systems? I am very shocked, you can't do a proper Dev --> QAT
> --> Prod environment if all three systems are run by the same
> postmaster, or on the same host imo.
I can see having separate clusters would save me
> On Fri, 14 Nov 2003 10:01:51 -0500 (EST), <[EMAIL PROTECTED]>
> wrote:
>>The Production database is the "real" data, and we periodically take a
>> back up from Prod and re-instantiate QAT and DEV by dropping them and
>> then restoring from the Prod backup.
>
>> Not that OID's are in short supply
[EMAIL PROTECTED] writes:
> Follow-up question: Are different ports really necessary?
Yes.
> I currently have the three different databases defined all in the same
> cluster, and differentiated by name, e.g., mydb, mydbqat, and mydbdev.
> If I have the postmaster start these three instances in s
>
> If you're really concerned, you can initdb separate clusters for QAT
> and DEV and run three postmasters using three different ports.
>
Follow-up question: Are different ports really necessary? I currently
have the three different databases defined all in the same cluster, and
differentiated b
On Fri, 14 Nov 2003 10:01:51 -0500 (EST), <[EMAIL PROTECTED]>
wrote:
>The Production database is the "real" data, and we periodically take a
>back up from Prod and re-instantiate QAT and DEV by dropping them and
>then restoring from the Prod backup.
> Not that OID's are in short supply,
>but I'm a
