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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Il giorno ven, 10/08/2007 alle 14.33 +0300, Loredana Curugiu ha scritto:
> 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 may use different --prefix while running configure, and then provide
different TCP/IP ports. If you use Debian, you may install all packages
at the same time without problems.

Bye,
Giuseppe


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

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.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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

Il giorno lun, 13/08/2007 alle 11.19 +0300, Loredana Curugiu ha scritto:
> 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?

Once you installed postgresql, you may specify a TCP in file
postgresql.conf.

Bye,
Giuseppe


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

"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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 8/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "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.


For me it didn't work. I had to specify in postgresql.conf the port and
after that
it worked.

Thank you for the replys. Were very usefull.

Greetings,
Loredana

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.

Regards,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend