RHEL

[Darryl W. DeLao Jr]

Im currently on red hat 7.3 running postgres. Everything is running fine.
Obviously, Im going to have to upgrade to RHEL 3 in order to receive
updates, etc. Does anyone know of any problems with postgres running on
RHEL 2.1 or RHEL 3?



Thanks,

Darryl

[Richard Huxton]

Re: RHEL

On Tuesday 11 November 2003 14:56, Darryl W. DeLao Jr wrote:[color=blue]
> Im currently on red hat 7.3 running postgres. Everything is running fine.
> Obviously, Im going to have to upgrade to RHEL 3 in order to receive
> updates, etc. Does anyone know of any problems with postgres running on
> RHEL 2.1 or RHEL 3?[/color]

Since RedHat repackage and sell PG along with some visual tools, and they
employ one of the core developers, I would be very surprised if there were
issues.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

[Joshua D. Drake]

Re: RHEL

Darryl W. DeLao Jr wrote:
[color=blue]
> -->
>
> Im currently on red hat 7.3 running postgres. Everything is running
> fine. Obviously, Im going to have to upgrade to RHEL 3 in order to
> receive updates, etc. Does anyone know of any problems with postgres
> running on RHEL 2.1 or RHEL 3?
>
>
>[/color]
Hello,

It will work fine. However, if you do not wish to ride the license
bandwagon of RedHat there are a couple of things to remember:

1. All updates for RHEL are made avaialable for free as src rpm's. If
you understand rpm-build (or can) it is very easy to keep
your box updated.

2. Fedora will maintain updates as well... and the above applies to
Fedora as well.

It really just depends on your needs.

Sincerely,

Joshua Drake


[color=blue]
> Thanks,
>
> Darryl
>
>
>[/color]


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandpromp t.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Adam Haberlach]

Re: RHEL

On Tue, Nov 11, 2003 at 08:56:29AM -0600, Darryl W. DeLao Jr wrote:[color=blue]
> Im currently on red hat 7.3 running postgres. Everything is running fine.
> Obviously, Im going to have to upgrade to RHEL 3 in order to receive
> updates, etc. Does anyone know of any problems with postgres running on
> RHEL 2.1 or RHEL 3?[/color]

I was, a few minutes ago, stunned to discover that as far as I can
tell, the postgres server is not part of Red Hat Server ES (I'm not sure
if it is in Advanced Server). They have the clients and dev libs,
but I don't see any hint of a server.

(If I'm wrong, I'd love to be corrected)

On that note, does anyone have suggestions for which version of
the server I should run? I see that there are seperate binary RPMS
for different Linux versions, but nothing for version 3 -- should I
spend some time doing a full install, building, and contributing
one, or is this not necessary?

--
Adam Haberlach | "We spent the 90's all trying to figure out
adam@mediariffi c.com | how to get email and the 00's trying to
http://mediariffic.com | figure out how to not get email."
| -- Joe Gross

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Rich Shepard]

Re: RHEL

On Tue, 11 Nov 2003, Adam Haberlach wrote:
[color=blue]
> On that note, does anyone have suggestions for which version of the
> server I should run? I see that there are seperate binary RPMS for
> different Linux versions, but nothing for version 3 -- should I spend some
> time doing a full install, building, and contributing one, or is this not
> necessary?[/color]

Adam,

While I still have a couple of Red Hat 7.3 boxes, I'm migrating to
Slackware. I have found that I have much better results by building
PostgreSQL from source than installing from rpms. It doesn't take much time
and it has always worked for me, faster and with less hassle than trying to
upgrade via the packages.

That said, I also use checkinstall (rather than 'make install') and build
the package (your choice of Slackware, Red Hat or Debian) from the source
tarball. Consider trying that.

Rich

Dr. Richard B. Shepard, President

Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@ap pl-ecosys.com

http://www.appl-ecosys.com/

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

[Adam Haberlach]

Re: RHEL

On Tue, Nov 11, 2003 at 04:03:44PM -0800, Rich Shepard wrote:[color=blue]
> On Tue, 11 Nov 2003, Adam Haberlach wrote:
>[color=green]
> > On that note, does anyone have suggestions for which version of the
> > server I should run? I see that there are seperate binary RPMS for
> > different Linux versions, but nothing for version 3 -- should I spend some
> > time doing a full install, building, and contributing one, or is this not
> > necessary?[/color]
>
> Adam,
>
> While I still have a couple of Red Hat 7.3 boxes, I'm migrating to
> Slackware. I have found that I have much better results by building
> PostgreSQL from source than installing from rpms. It doesn't take much time
> and it has always worked for me, faster and with less hassle than trying to
> upgrade via the packages.[/color]

Well, we've got 50 or so customer boxes that we need to upgrade, so we
need the package management. I used to build my own from source, too,
and still do on my Solaris box, but I like being able to add and remove
things reliable. But to each their own.

--
Adam Haberlach | "We spent the 90's all trying to figure out
adam@mediariffi c.com | how to get email and the 00's trying to
http://mediariffic.com | figure out how to not get email."
| -- Joe Gross

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Joshua D. Drake]

Re: RHEL

[color=blue]
> Well, we've got 50 or so customer boxes that we need to upgrade, so we
>need the package management. I used to build my own from source, too,
>and still do on my Solaris box, but I like being able to add and remove
>things reliable. But to each their own.
>
>
>[/color]
apt and fedora.


'


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandpromp t.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Re: RHEL

Adam Haberlach <adam@newsnippl e.com> writes:[color=blue]
> I was, a few minutes ago, stunned to discover that as far as I can
> tell, the postgres server is not part of Red Hat Server ES[/color]

Feel free to let Red Hat know that you're unhappy about this.

(Not totally unbiased here ... I'm getting *very* tired about RH's
internal indecision about their extent of commitment to Postgres.
I think frequent whacks-upside-the-head from paying customers may
be the only way to get upper management to sit up and take notice.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Guy Fraser]

Re: RHEL

Thanx for the update.

I almost bought RHEL WS on RH's advice, claiming that bind, dhcp and
wine were
the only packages I needed to build myself.

I downloaded and installed fedora on yesterday, and it has PG 7.3.4
server, and everything
else I need except wine. I will investigate what will be required for me
to provide wine for
fedora. I need it for my workstations at home and at work, so I can run
FileMaker Pro.

I have heard a lot of good things about gentoo, but have not checked it
out yet. At work
we have moved all our servers to FreeBSD, I am testing FreeBSD 4.9 now,
and it has
7.3.4 in the ports now as well.

PgAdmin III is now in the ports tree on FreeBSD as well, I have just
built and installed
it.

Good luck with RH

Tom Lane wrote:
[color=blue]
>Adam Haberlach <adam@newsnippl e.com> writes:
>
>[color=green]
>> I was, a few minutes ago, stunned to discover that as far as I can
>>tell, the postgres server is not part of Red Hat Server ES
>>
>>[/color]
>
>Feel free to let Red Hat know that you're unhappy about this.
>
>(Not totally unbiased here ... I'm getting *very* tired about RH's
>internal indecision about their extent of commitment to Postgres.
>I think frequent whacks-upside-the-head from paying customers may
>be the only way to get upper management to sit up and take notice.)
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postg resql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>[/color]


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

http://www.postgresql.org/docs/faqs/FAQ.html

[Paul Thomas]

Re: RHEL


On 12/11/2003 18:13 Guy Fraser wrote:[color=blue]
> Thanx for the update.
>
> I almost bought RHEL WS on RH's advice, claiming that bind, dhcp and
> wine were
> the only packages I needed to build myself.
>
> I downloaded and installed fedora on yesterday, and it has PG 7.3.4
> server, and everything
> else I need except wine. I will investigate what will be required for me
> to provide wine for
> fedora. I need it for my workstations at home and at work, so I can run
> FileMaker Pro.[/color]

According to posts on the Fedora mailing list, the RH9 wine rpm from
Sourceforge works ok on fedora.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Lamar Owen]

Re: RHEL

On Tuesday 11 November 2003 11:57 pm, Tom Lane wrote:[color=blue]
> Adam Haberlach <adam@newsnippl e.com> writes:[color=green]
> > I was, a few minutes ago, stunned to discover that as far as I can
> > tell, the postgres server is not part of Red Hat Server ES[/color][/color]
[color=blue]
> Feel free to let Red Hat know that you're unhappy about this.[/color]
[color=blue]
> (Not totally unbiased here ... I'm getting *very* tired about RH's
> internal indecision about their extent of commitment to Postgres.
> I think frequent whacks-upside-the-head from paying customers may
> be the only way to get upper management to sit up and take notice.)[/color]

The RHEL3 beta (taroon) had rh-postgresql-server built and included. Does
RHEL3 not include this package?
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554

https://www.pari.edu

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

[Craig O'Shannessy]

Re: RHEL

So, what ever happened to the "RedHat database"? I though RH was going to
be hiring core PostgreSQL developers? Anyone got a URL to explain what
happened to this venture? Sorry if I'm getting a little OT here.

Craig

On Wed, 12 Nov 2003, Lamar Owen wrote:
[color=blue]
> On Tuesday 11 November 2003 11:57 pm, Tom Lane wrote:[color=green]
> > Adam Haberlach <adam@newsnippl e.com> writes:[color=darkred]
> > > I was, a few minutes ago, stunned to discover that as far as I can
> > > tell, the postgres server is not part of Red Hat Server ES[/color][/color]
>[color=green]
> > Feel free to let Red Hat know that you're unhappy about this.[/color]
>[color=green]
> > (Not totally unbiased here ... I'm getting *very* tired about RH's
> > internal indecision about their extent of commitment to Postgres.
> > I think frequent whacks-upside-the-head from paying customers may
> > be the only way to get upper management to sit up and take notice.)[/color]
>
> The RHEL3 beta (taroon) had rh-postgresql-server built and included. Does
> RHEL3 not include this package?
>[/color]


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

[Richard Huxton]

Re: RHEL

On Thursday 13 November 2003 04:52, Craig O'Shannessy wrote:[color=blue]
> So, what ever happened to the "RedHat database"? I though RH was going to
> be hiring core PostgreSQL developers? Anyone got a URL to explain what
> happened to this venture? Sorry if I'm getting a little OT here.[/color]

It exists, and they did hire. You get PG, some graphical utilities (java,
open-sourced) and some support for your money.

http://sources.redhat.com/rhdb/

--
Richard Huxton
Archonet Ltd

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

http://www.postgresql.org/docs/faqs/FAQ.html

[Lamar Owen]

Re: RHEL

On Wednesday 12 November 2003 11:52 pm, Craig O'Shannessy wrote:[color=blue]
> So, what ever happened to the "RedHat database"? I though RH was going to
> be hiring core PostgreSQL developers? Anyone got a URL to explain what
> happened to this venture? Sorry if I'm getting a little OT here.[/color]

Tom Lane is in a better position to answer that, but I understand that things
have realigned somewhat. The package is known as 'rh-postgresql' and has
some 'enhancements' of some sort. The graphical tools are nice, and are open
source.

Tom Lane was indeed hired by Red Hat, and he is a core developer. The tenor
of his last message would seem to imply some friction there; I hope I'm just
misunderstandin g.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554

https://www.pari.edu

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Alvaro Herrera]

Re: RHEL

On Thu, Nov 13, 2003 at 09:34:27AM +0000, Richard Huxton wrote:[color=blue]
> On Thursday 13 November 2003 04:52, Craig O'Shannessy wrote:[color=green]
> > So, what ever happened to the "RedHat database"? I though RH was going to
> > be hiring core PostgreSQL developers? Anyone got a URL to explain what
> > happened to this venture? Sorry if I'm getting a little OT here.[/color]
>
> It exists, and they did hire. You get PG, some graphical utilities (java,
> open-sourced) and some support for your money.[/color]

That means I could get Tom Lane to answer some question about Pg? Wow,
that's impressive.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido" (Papelucho)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org