Thread: 2 versions of Postgres on the same machine
Hi This is probably more like linux question but strictly related to PG so I hope somebody can help me. I need to have 8.3 & 8.4 installed on the same machine (for pg_migrator). As I'm not Linux guru I used to install/update Postgres using yum from PGDG. Is there any clever way to install parallel version of PG using yum or other way (without compilation please :D )
wstrzalka wrote: > Hi > > This is probably more like linux question but strictly related to > PG so I hope somebody can help me. > > I need to have 8.3 & 8.4 installed on the same machine (for > pg_migrator). As I'm not Linux guru I used to install/update Postgres > using yum from PGDG. > > Is there any clever way to install parallel version of PG using yum > or other way (without compilation please :D ) > not easily, the RPMs that yum fetches have the library paths hard coded. building postgres from source is actually very easy. just follow the README and/or INSTALL in the source tarball. build it for an alternate root path, like /usr/local/pgsql84/... (you'd specify this as an option on the ./configure step), then after its built and installed to that alternate path, and you've run initdb, you would edit postgresql.conf in this alternate ./data directory to change the port to a different port, such as 5433 instead of the default 5432.
On Tue, Aug 18, 2009 at 02:16:20AM -0700, wstrzalka wrote: > I need to have 8.3 & 8.4 installed on the same machine (for > pg_migrator). As I'm not Linux guru I used to install/update Postgres > using yum from PGDG. If you could use Debian or something based on it (e.g. Ubuntu) then this is how it works by default. You can have as many different "major" (i.e. 8.2, 8.3 and 8.4) versions installed and running at the same time as you want. Building from source isn't too hard though, it's the keeping it up to date that's more of a fiddle. -- Sam http://samason.me.uk/
On Tue, 2009-08-18 at 02:16 -0700, wstrzalka wrote: > Is there any clever way to install parallel version of PG using yum > or other way (without compilation please :D ) There is no way to do it with RPMS :( Install one of the versions using yum, and compile the other please. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org
Attachment
On 08/18/2009 10:34 PM, Devrim GÜNDÜZ wrote:
Or use EnterpriseDB's one-click installer for PostgreSQL 8.3 and PostgreSQL 8.4, you will have 2 parallel version of server running simultaneously without needing to compile from source.On Tue, 2009-08-18 at 02:16 -0700, wstrzalka wrote:Is there any clever way to install parallel version of PG using yum or other way (without compilation please :D )There is no way to do it with RPMS :( Install one of the versions using yum, and compile the other please.
-- Regards, Sachin Srivastava www.enterprisedb.com