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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

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