Re: 2 servers with 1 database cluster

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Mark Cubitt <mark(dot)cubitt(at)applegate(dot)co(dot)uk>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: 2 servers with 1 database cluster
Date: 2003-06-10 14:25:36
Message-ID: Pine.LNX.4.33.0306100820430.13190-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As another poster already pointed out, running two postmasters against the
same storage is officially a Very Bad Idea.

Also, it sounded like you might be looking at network attached storage
etc. to put your database on. While isn't a Very Bad Idea, it is a path
fraught with danger. For a database server, you're probably better off
having one very fast box that's either replicated or simply hot backed up
nightly from the live box. Any dual CPU machine with a gig of memory and
a stack of drives underneath it can handle two front end application
servers handily.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-10 15:00:07 Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Previous Message Jonathan Bartlett 2003-06-10 14:25:07 Re: Pg_dumpall