Unix Technical Forum

Giving up multiple postmaster + RPM issue

This is a discussion on Giving up multiple postmaster + RPM issue within the pgsql Hackers forums, part of the PostgreSQL category; --> Hello, As some of you already know, I have been working on multiple postmaster + RPM issue for some ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 06:35 AM
Devrim GUNDUZ
 
Posts: n/a
Default Giving up multiple postmaster + RPM issue


Hello,

As some of you already know, I have been working on multiple postmaster
+ RPM issue for some time. We are approaching 8.2.0, and I still could
not complete this.

Also, I'm having problems with my eyes which prevents me working (for
long hours) (Vision Fatigue); so I want to give up this issue at least
for now.

I will create a new branch for this; and use the old spec file format
for 8.2.

Here is the spec file that I plan to use for 8.2:

http://cvs.pgfoundry.org/cgi-bin/cvs...-cvsweb-markup

Revisions greater then 1.8 are prototypes for multiple postmaster issue,
so should not be used for 8.2 final.

I *hope* to release 8.2 SRPM next week so that people will test it.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/





-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBFVfKTpme12CBXnxERArlJAJ0S4lUghMVYEbkX0Pe3zN PlfvBpQACfZVwQ
9SwtPUw3U7Uwg+CZjdutnYU=
=chEH
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-12-2008, 06:35 AM
Paul Lindner
 
Posts: n/a
Default Re: Giving up multiple postmaster + RPM issue

On Sat, Nov 11, 2006 at 05:56:03PM +0200, Devrim GUNDUZ wrote:
>
> Hello,
>
> As some of you already know, I have been working on multiple postmaster
> + RPM issue for some time. We are approaching 8.2.0, and I still could
> not complete this.
>
> Also, I'm having problems with my eyes which prevents me working (for
> long hours) (Vision Fatigue); so I want to give up this issue at least
> for now.
>
> I will create a new branch for this; and use the old spec file format
> for 8.2.
>
> Here is the spec file that I plan to use for 8.2:
>
> http://cvs.pgfoundry.org/cgi-bin/cvs...-cvsweb-markup
>
> Revisions greater then 1.8 are prototypes for multiple postmaster issue,
> so should not be used for 8.2 final.
>
> I *hope* to release 8.2 SRPM next week so that people will test it.


I tried to implement the same type of thing with other RPM packages.
Having multiple versioned RPMs installed is not so easy. Most of the
tools like yum assume you want to upgrade, not install new versions
thus you get lots of problems. (You can designate packages
install-only in yum.conf, but then you have to be sure that everything
works...)

My solution was to create RPMs with the version number embedded in the
name. Thus for 7.4.13 and 8.1.5 I have:

postgres7.4-13-1_fc6.x86_64.rpm
postgres8.1-5-1_fc6.x86_64.rpm

Everything goes into /usr/local/pg7.4 and /usr/local/pg8.1, init
scripts are /etc/init.d/postgres8.1, /etc/init.d/postgres7.4

That combined with some 'alternatives' magic makes things work well
for the hosts at my current job.

spec file(s) available on request...

--
Paul Lindner ||||| | | | | | | | | |
lindner@inuus.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFVuj++FkoUnP1gFQRAqlTAJsGJK0j+v9zI141s7iR07 nBfHNQ9ACgisC2
9iiaY/JSR12M5UmkCJP2OaE=
=9jXJ
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-12-2008, 06:35 AM
Martijn van Oosterhout
 
Posts: n/a
Default Re: Giving up multiple postmaster + RPM issue

On Sun, Nov 12, 2006 at 01:27:26AM -0800, Paul Lindner wrote:
> My solution was to create RPMs with the version number embedded in the
> name. Thus for 7.4.13 and 8.1.5 I have:
>
> postgres7.4-13-1_fc6.x86_64.rpm
> postgres8.1-5-1_fc6.x86_64.rpm
>
> Everything goes into /usr/local/pg7.4 and /usr/local/pg8.1, init
> scripts are /etc/init.d/postgres8.1, /etc/init.d/postgres7.4


That's the apporaich the debian packages take too, although they also
add a layer so you can have multiple clusters also, each with whatever
version you like.

Have a ncie day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFVyOiIB7bNG8LQkwRAj/7AJ9IA6AO+H0rrvXFl7O8L9+L+rpGeACeP2RB
NfXRuUt7/N38eNSs7xfT9Mw=
=RQW7
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-12-2008, 06:35 AM
Devrim GUNDUZ
 
Posts: n/a
Default Re: Giving up multiple postmaster + RPM issue

Hi,

On Sun, 2006-11-12 at 01:27 -0800, Paul Lindner wrote:
> Everything goes into /usr/local/pg7.4 and /usr/local/pg8.1, init
> scripts are /etc/init.d/postgres8.1, /etc/init.d/postgres7.4


/usr/local is not the right place for a database server, per Linux FSH.

> spec file(s) available on request.


I'll be happy if you send me the spec.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/





-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBFV4Cfpme12CBXnxERAjTaAJ49iQe5bbCDWNEME1qK67 1mhhJ1wwCbBFFp
8hKScVqO5cRYogxQPfpurWI=
=Qbhm
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:11 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com