Thread: Install two different versions of postgres which should run in parallel

Hi all,

I need to have two different vesions of postgres running in parallel on
different ports. Does anyone knows how to install two different versions
of postgres (7.4.5 and 8.2.4) on the same computer? I am using Linux
operating system.

Any information would greatly be appreciated.

Loredana

Loredana Curugiu wrote:
> Hi all,
>
> I need to have two different vesions of postgres running in parallel on
> different ports. Does anyone knows how to install two different versions
> of postgres (7.4.5 and 8.2.4) on the same computer? I am using Linux
> operating system.

You can install from source and provide the --prefix argument to the
configure command.

Sean

Loredana Curugiu wrote:

>Hi all,
>
>I need to have two different vesions of postgres running in parallel on
>different ports. Does anyone knows how to install two different versions
>of postgres (7.4.5 and 8.2.4) on the same computer? I am using Linux
>operating system.
>
>Any information would greatly be appreciated.
>
>Loredana
>
>  
>
Shure. You just have to take care about --prefix (executable path) and 
--with-pgport (default port) when you ./configure, and also take care of 
the datadir you chose when executing initdb.

Good luck.
Gerardo

On 8/10/07, Loredana Curugiu <loredana.curugiu@gmail.com> wrote:
> Hi all,
>
>  I need to have two different vesions of postgres running in parallel on
>  different ports. Does anyone knows how to install two different versions
>  of postgres (7.4.5 and 8.2.4) on the same computer? I am using Linux
>  operating system.

FYI, Linux isn't an OS, it's a kernel.

With RedHat, you'll either need to build your own RPMs from source
where each goes to a different directory etc OR compile from source
using a different --prefix and then use separate startup scripts that
set LD_LIBRARY_PATH and PATH etc... for each install on startup.

If you're running Debian, you can install >1 version of pgsql side by
side.  Not sure how it's done exactly, but I've heard it repeated
enough to believe it's true.

On Fri, 2007-08-10 at 14:33 +0300, Loredana Curugiu wrote:
> Hi all,
>
> I need to have two different vesions of postgres running in parallel
> on
> different ports. Does anyone knows how to install two different
> versions
> of postgres (7.4.5 and 8.2.4) on the same computer? I am using Linux
> operating system.

If you run Debian or Ubuntu you can do this with the package system.

  apt-get install postgresql-8.2 postgresql-7.4

The two versions are automatically installed to run on different ports.
Look at the docs and manpages for the postgresql-common package to see
how it works.

If you can't do that, you can install a different version from source in
a different directory tree; then have its postmaster run on a different
port.  Specify the port number when connecting so as to get to the
postmaster you want.

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

I didn't succeed installing the two versions of postgres.
For installing I am running the "configure" script as follows:

./configure --prefix=/usr/local/pgsql-7.4.5 --with-java --with-pgport=6947

Although I specify a different port than the default one, the postgres it is installed with the
default port. The port must be specified also in another configuration files?

Regards,
      Loredana

Check the postgresql.conf in the $prefix/data dir. Also post the exact 
error log (which in this case should be some like "address already in 
use", because port 5432 is in use by the 8.2.4 version), and also the 
exact command you are executing.

Cheers.
Gerardo

>I didn't succeed installing the two versions of postgres.
>For installing I am running the "configure" script as follows:
>
> ./configure --prefix=/usr/local/pgsql-7.4.5 --with-java --with-pgport=6947
>
>Although I specify a different port than the default one, the postgres it is
>installed with the
>default port. The port must be specified also in another configuration
>files?
>
>Regards,
>      Loredana
>
>  
>

"Loredana Curugiu" <loredana.curugiu@gmail.com> writes:
> For installing I am running the "configure" script as follows:

>  ./configure --prefix=/usr/local/pgsql-7.4.5 --with-java --with-pgport=6947

> Although I specify a different port than the default one, the postgres it is
> installed with the default port.

On what grounds do you conclude that?  I use --with-pgport every day.
It works fine.

            regards, tom lane