Best way to install postgres? RPM/Source Code Build

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Best way to install postgres? RPM/Source Code Build
Date: 2009-04-29 00:00:25
Message-ID: eae6a62a0904281700r712c3943u84d54d5fe37beb28@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi All,
What is the best way to Install postgres database?

We have installed (2) versions of the postgres on th server using source
code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is more than 100GB. Currently we are running 8.3.6. When
we upgraded from 8.3.3 to 8.3.6, we pointed the data directory of 8.3.3 to
8.3.6.

Ops team want to install postgres as (usr/local/bin) using RPM, and want to
keep the data directory under (/var/lib/data/pgsql) and they say that we
cannot have two versions at the same time using RPM.
They say that red hat standard is to install all binaries of the database
under /usr/local/bin and by using RPM only.

What is the best way to install postgres? Is it by RPM or using Source code
(Build). Could postgres experts comment on this please.

Thanks
Deepak

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John R Pierce 2009-04-29 00:08:32 Re: [GENERAL] Best way to install postgres? RPM/Source Code Build
Previous Message dx k9 2009-04-28 20:47:25 yast sles9.3 stopped all postgres instance

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-04-29 00:08:32 Re: [GENERAL] Best way to install postgres? RPM/Source Code Build
Previous Message Tom Lane 2009-04-28 21:51:55 Re: Restore Crashes Postgres