pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInstall two different versions of postgres which should run in parallel
13+ messages / 8 participants
[nested] [flat]
* Install two different versions of postgres which should run in parallel
@ 2007-08-10 11:33 Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-10 11:46 ` Re: [NOVICE] Install two different versions of postgres which should run in parallel Sean Davis <sdavis2@mail.nih.gov>
2007-08-10 12:44 ` Re: Install two different versions of postgres which should run in parallel Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
2007-08-10 15:11 ` Re: Install two different versions of postgres which should run in parallel Gerardo Herzig <gherzig@fmed.uba.ar>
2007-08-10 15:21 ` Re: [SQL] Install two different versions of postgres which should run in parallel Scott Marlowe <scott.marlowe@gmail.com>
2007-08-10 16:12 ` Re: [NOVICE] Install two different versions of postgres which should run in parallel Oliver Elphick <olly@lfix.co.uk>
2007-08-13 08:19 ` Re: Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-15 11:58 ` Re: Install two different versions of postgres which should run in parallel Markus Schaber <schabi@logix-tt.com>
0 siblings, 7 replies; 13+ messages in thread
From: Loredana Curugiu @ 2007-08-10 11:33 UTC (permalink / raw)
To: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [NOVICE] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-10 11:46 ` Sean Davis <sdavis2@mail.nih.gov>
6 siblings, 0 replies; 13+ messages in thread
From: Sean Davis @ 2007-08-10 11:46 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-10 12:44 ` Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
6 siblings, 0 replies; 13+ messages in thread
From: Giuseppe Sacco @ 2007-08-10 12:44 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-10 15:11 ` Gerardo Herzig <gherzig@fmed.uba.ar>
6 siblings, 0 replies; 13+ messages in thread
From: Gerardo Herzig @ 2007-08-10 15:11 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-10 15:21 ` Scott Marlowe <scott.marlowe@gmail.com>
6 siblings, 0 replies; 13+ messages in thread
From: Scott Marlowe @ 2007-08-10 15:21 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [NOVICE] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-10 16:12 ` Oliver Elphick <olly@lfix.co.uk>
6 siblings, 0 replies; 13+ messages in thread
From: Oliver Elphick @ 2007-08-10 16:12 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-13 08:19 ` Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 09:11 ` Re: Install two different versions of postgres which should run in parallel Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
2007-08-13 13:14 ` Re: Install two different versions of postgres which should run in parallel Gerardo Herzig <gherzig@fmed.uba.ar>
2007-08-13 13:37 ` Re: [NOVICE] Install two different versions of postgres which should run in parallel Tom Lane <tgl@sss.pgh.pa.us>
6 siblings, 3 replies; 13+ messages in thread
From: Loredana Curugiu @ 2007-08-13 08:19 UTC (permalink / raw)
To: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 08:19 ` Re: Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-13 09:11 ` Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
2 siblings, 0 replies; 13+ messages in thread
From: Giuseppe Sacco @ 2007-08-13 09:11 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 08:19 ` Re: Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-13 13:14 ` Gerardo Herzig <gherzig@fmed.uba.ar>
2 siblings, 0 replies; 13+ messages in thread
From: Gerardo Herzig @ 2007-08-13 13:14 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-sql
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
>
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [NOVICE] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 08:19 ` Re: Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-13 13:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-14 07:37 ` Re: [NOVICE] Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2 siblings, 1 reply; 13+ messages in thread
From: Tom Lane @ 2007-08-13 13:37 UTC (permalink / raw)
To: Loredana Curugiu <loredana.curugiu@gmail.com>; +Cc: pgsql-novice@postgresql.org; pgsql-sql; pgsql-jdbc@postgresql.org
"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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [NOVICE] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 08:19 ` Re: Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 13:37 ` Re: [NOVICE] Install two different versions of postgres which should run in parallel Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-08-14 07:37 ` Loredana Curugiu <loredana.curugiu@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Loredana Curugiu @ 2007-08-14 07:37 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql; pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
@ 2007-08-15 11:58 ` Markus Schaber <schabi@logix-tt.com>
2007-08-15 12:42 ` Re: [JDBC] Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
6 siblings, 1 reply; 13+ messages in thread
From: Markus Schaber @ 2007-08-15 11:58 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [JDBC] Install two different versions of postgres which should run in parallel
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-15 11:58 ` Re: Install two different versions of postgres which should run in parallel Markus Schaber <schabi@logix-tt.com>
@ 2007-08-15 12:42 ` Loredana Curugiu <loredana.curugiu@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Loredana Curugiu @ 2007-08-15 12:42 UTC (permalink / raw)
To: Markus Schaber <schabi@logix-tt.com>; pgsql-novice@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2007-08-15 12:42 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-10 11:33 Install two different versions of postgres which should run in parallel Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-10 11:46 ` Sean Davis <sdavis2@mail.nih.gov>
2007-08-10 12:44 ` Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
2007-08-10 15:11 ` Gerardo Herzig <gherzig@fmed.uba.ar>
2007-08-10 15:21 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-08-10 16:12 ` Oliver Elphick <olly@lfix.co.uk>
2007-08-13 08:19 ` Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-13 09:11 ` Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
2007-08-13 13:14 ` Gerardo Herzig <gherzig@fmed.uba.ar>
2007-08-13 13:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-14 07:37 ` Loredana Curugiu <loredana.curugiu@gmail.com>
2007-08-15 11:58 ` Markus Schaber <schabi@logix-tt.com>
2007-08-15 12:42 ` Loredana Curugiu <loredana.curugiu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox