pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed2 PGSQL instances in the same server
6+ messages / 6 participants
[nested] [flat]
* 2 PGSQL instances in the same server
@ 2010-11-04 15:13 Ramiro Barreca <rbarreca@gmail.com>
2010-11-04 15:50 ` Re: 2 PGSQL instances in the same server Szymon Guz <mabewlun@gmail.com>
2010-11-04 16:20 ` Re: 2 PGSQL instances in the same server Devrim GÜNDÜZ <devrim@gunduz.org>
2010-11-04 16:38 ` Re: 2 PGSQL instances in the same server Chris Browne <cbbrowne@acm.org>
0 siblings, 3 replies; 6+ messages in thread
From: Ramiro Barreca @ 2010-11-04 15:13 UTC (permalink / raw)
To: pgsql-admin
We need to have, for migration, either an instance of our actual PG 8.4.4
and a new one of PG 9.0 for testing.
Where can we found a paper for helping us?
Our platform is Centos 5.4 x86 64 bits
--
Ramiro Barreca
rbarreca@gmail.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 2 PGSQL instances in the same server
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
@ 2010-11-04 15:50 ` Szymon Guz <mabewlun@gmail.com>
2010-11-04 16:04 ` Re: 2 PGSQL instances in the same server Gerhard Hintermayer <gerhard.hintermayer@gmail.com>
2010-11-04 17:27 ` Re: 2 PGSQL instances in the same server Lou Picciano <loupicciano@comcast.net>
2 siblings, 2 replies; 6+ messages in thread
From: Szymon Guz @ 2010-11-04 15:50 UTC (permalink / raw)
To: Ramiro Barreca <rbarreca@gmail.com>; +Cc: pgsql-admin
On 4 November 2010 16:13, Ramiro Barreca <rbarreca@gmail.com> wrote:
> We need to have, for migration, either an instance of our actual PG 8.4.4
> and a new one of PG 9.0 for testing.
> Where can we found a paper for helping us?
> Our platform is Centos 5.4 x86 64 bits
> --
> Ramiro Barreca
> rbarreca@gmail.com
>
I think there is no paper on that, that's just too simple. Install another
database, run it on another port (that needs changing one value in the
postgresql.conf).
regards
Szymon
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 2 PGSQL instances in the same server
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
2010-11-04 15:50 ` Re: 2 PGSQL instances in the same server Szymon Guz <mabewlun@gmail.com>
@ 2010-11-04 16:04 ` Gerhard Hintermayer <gerhard.hintermayer@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Gerhard Hintermayer @ 2010-11-04 16:04 UTC (permalink / raw)
To: pgsql-admin
and of course install binaries somewhere else, use a different PG_DATA
dir ... you're soon loosing simplicity ;-) . Some distros support this
natively. Gentoo supports this, don't know about Centos.
On Thu, Nov 4, 2010 at 4:50 PM, Szymon Guz <mabewlun@gmail.com> wrote:
>
>
> On 4 November 2010 16:13, Ramiro Barreca <rbarreca@gmail.com> wrote:
>>
>> We need to have, for migration, either an instance of our actual PG 8.4.4
>> and a new one of PG 9.0 for testing.
>> Where can we found a paper for helping us?
>> Our platform is Centos 5.4 x86 64 bits
>> --
>> Ramiro Barreca
>> rbarreca@gmail.com
>
> I think there is no paper on that, that's just too simple. Install another
> database, run it on another port (that needs changing one value in the
> postgresql.conf).
> regards
> Szymon
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 2 PGSQL instances in the same server
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
2010-11-04 15:50 ` Re: 2 PGSQL instances in the same server Szymon Guz <mabewlun@gmail.com>
@ 2010-11-04 17:27 ` Lou Picciano <loupicciano@comcast.net>
1 sibling, 0 replies; 6+ messages in thread
From: Lou Picciano @ 2010-11-04 17:27 UTC (permalink / raw)
To: pgsql-admin
Ramiro,
Yes, this will pose no problem. We do it commonly. You can simply install your v9.0 server, as Szymon has suggested, on another port to effect your testing. Be sure you've set up a 9.0-compatible cluster of course; you can't share data.
Lou Picciano
----- Original Message -----
From: "Szymon Guz" <mabewlun@gmail.com>
To: "Ramiro Barreca" <rbarreca@gmail.com>
Cc: "pgsql-admin" <pgsql-admin@postgresql.org>
Sent: Thursday, November 4, 2010 11:50:07 AM
Subject: Re: [ADMIN] 2 PGSQL instances in the same server
On 4 November 2010 16:13, Ramiro Barreca < rbarreca@gmail.com > wrote:
We need to have, for migration, either an instance of our actual PG 8.4.4 and a new one of PG 9.0 for testing.
Where can we found a paper for helping us?
Our platform is Centos 5.4 x86 64 bits
--
Ramiro Barreca
rbarreca@gmail.com
I think there is no paper on that, that's just too simple. Install another database, run it on another port (that needs changing one value in the postgresql.conf).
regards
Szymon
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 2 PGSQL instances in the same server
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
@ 2010-11-04 16:20 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2 siblings, 0 replies; 6+ messages in thread
From: Devrim GÜNDÜZ @ 2010-11-04 16:20 UTC (permalink / raw)
To: Ramiro Barreca <rbarreca@gmail.com>; +Cc: pgsql-admin
On Thu, 2010-11-04 at 12:13 -0300, Ramiro Barreca wrote:
> We need to have, for migration, either an instance of our actual PG
> 8.4.4 and a new one of PG 9.0 for testing.
> Where can we found a paper for helping us?
> Our platform is Centos 5.4 x86 64 bits
Barring a bug that prevents yum to install both of them to be installed
at the same time, you can install 8.4+9.0 RPMs on the same machine. See
this comment related to this bug, and how to workaround it:
http://people.planetpostgresql.org/devrim/index.php?/archives/48-What-is-new-in-PostgreSQL-9.0-RPMs....
(Actually it is not a bug, it was an oversight)
I have already fixed it in SVN, but I could not find time to build
updated packages (I'm at PgWest). I'll blog about it once the packages
are ready (maybe later today).
So download 9.0 RPMs from
http://yum.pgrpms.org/9.0/redhat/rhel-5-x86_64/
(The ones starting with postgresql90-*-9.0.1-* )
and install them manually as written in the comment above. That should
be enough.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 2 PGSQL instances in the same server
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
@ 2010-11-04 16:38 ` Chris Browne <cbbrowne@acm.org>
2 siblings, 0 replies; 6+ messages in thread
From: Chris Browne @ 2010-11-04 16:38 UTC (permalink / raw)
To: pgsql-admin
rbarreca@gmail.com (Ramiro Barreca) writes:
> We need to have, for migration, either an instance of our actual PG 8.4.4 and a
> new one of PG 9.0 for testing.
> Where can we found a paper for helping us?
> Our platform is Centos 5.4 x86 64 bits
The "complication" to this is that it is quite likely not simple to do
this using pre-packaged (e.g. - RPM files) Postgres builds.
Anyone that's involved with building Postgres tends to have tooling
handy to help have multiple versions of Postgres around.
I have a script I use for this sort of thing:
<https://github.com/cbbrowne/pginit;
Greg Smith has something analagous, though more sophisticated:
<https://github.com/gregs1104/peg;
It amounts to:
1. Installing both versions of software;
2. Possibly using scripts to help manage where the results get
installed.
If you're accustomed to entrusting installation totally to RPM-based
installations of Postgres, you're headed into new territory to have to
choose and configure where the installations are done. But it's really
no big deal - it's not unusual for me to install several different
instances of Postgres in the course of an hour, refreshing some
instances I use to test Slony-I.
--
output = ("cbbrowne" "@" "linuxfinances.info")
"In the free software world, a rising tide DOES lift all boats, and
once the user has tasted Unix it's easy for them to switch between
Unices." -- david parsons
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-11-04 17:27 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-04 15:13 2 PGSQL instances in the same server Ramiro Barreca <rbarreca@gmail.com>
2010-11-04 15:50 ` Szymon Guz <mabewlun@gmail.com>
2010-11-04 16:04 ` Gerhard Hintermayer <gerhard.hintermayer@gmail.com>
2010-11-04 17:27 ` Lou Picciano <loupicciano@comcast.net>
2010-11-04 16:20 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-11-04 16:38 ` Chris Browne <cbbrowne@acm.org>
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