Re: server install recommendations?

From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: server install recommendations?
Date: 2008-10-18 09:50:07
Message-ID: gdcbgh$64k$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Roberto Scattini wrote:

> in a couple of days i will reinstall an offline database server. It's
> a old HP Proliant DL580 G3 with three disks (147 GB each). Currently
> it has a debian Sarge in a RAID5 hardware array ( with HP Smart Array
> 6i, [RAID bus controller: Compaq Computer Corporation Smart Array 64xx
> (rev 01)] ).

Make sure you do a test installation first. I'm currently tinkering with
a slightly older ProLiant and find that when I move from Debian "Sarge"
to "Lenny" it won't recognise SMP. This is almost certainly a kernel
issue and is probably something that won't get fixed, I suspect that 2.6
quite simply doesn't like the machine's SMBIOS structure.

> -should i ask my boss to buy another disk? (it will be difficult, but
> if i can demonstrate It worth it...)

With this type of hardware you should have a good stock of identical
disc drives before you start. You are very likely to find that the array
firmware will reject any disc which isn't within 5 or 10% of the size of
the existing ones, when hardware vendors rebadge (e.g. Seagate) disc
drives they knock the apparent size down to a standard value.

> our application (running on separate webserver) is of the type "OLTP",
> the server will be entirely dedicated to postgresql. i will configure
> a warm-standby server, so the WAL files will be forwarded to another
> server.

Again, make sure that you have spare compatible hardware- not ncessarily
the same model but certainly using the same drive hardware, PSUs etc. If
your boss won't spend the sort of money that these machines go for on
eBay then your company isn't serious about running a service for its
customers.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2008-10-18 10:37:38 Re: auto insert data every one minute
Previous Message Grzegorz Jaśkiewicz 2008-10-18 09:42:01 Re: auto insert data every one minute