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

Install two different versions of postgres which should run in parallel

From
"Loredana Curugiu"
Date:
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

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

From
Sean Davis
Date:
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

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

From
Oliver Elphick
Date:
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.


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

From
"Loredana Curugiu"
Date:
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

Re: [JDBC] Install two different versions of postgres which should run in parallel

From
"Loredana Curugiu"
Date:


On 8/15/07, Markus Schaber <schabi@logix-tt.com> wrote:
Hi, Loredana,

"Loredana Curugiu" <loredana.curugiu@gmail.com> wrote:

> 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.

Which Linux distribution are you using?

Debian supports running multiple PostgreSQL major versions out of the
box.

Hi Markus,

I am using  Mandrake 2006. I have succeded in instalation of the two versions
of postgres.

Greetings,
     Loredana