Thread: Redhat Database ???

Redhat Database ???

From
Brian Scandale
Date:
Does anyone know what the supposed enhancements are to the Redhat database? It is called an enhanced version of pgSQL
7.2.3by Redhat. 

Can't seem to find specifics on the Redhat site.

thanks,
Brian


Re: Redhat Database ???

From
Josh Berkus
Date:
Brian,

> Does anyone know what the supposed enhancements are to the Redhat database?
It is called an enhanced version of pgSQL 7.2.3 by Redhat.
>
> Can't seem to find specifics on the Redhat site.

I'd suggest e-mailing them.  I *think* the main enhancement is Red hat
Support, especially for Postgres on clusters and RH Advanced server.
However, I'm not really sure.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Re: Redhat Database ???

From
Tom Lane
Date:
Brian Scandale <Brrrian@Excite.com> writes:
> Does anyone know what the supposed enhancements are to the Redhat database? It is called an enhanced version of pgSQL
7.2.3by Redhat. 

Most of the value-added is in the GUI tools (RHDB Admin and Visual Explain).
The server itself contains a few additional bugfixes beyond what's in
the standard 7.2.3 release, but nothing earthshaking AFAIR.

> Can't seem to find specifics on the Redhat site.

Not sure where you looked, but the primary public page for RHDB is

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

            regards, tom lane
            Red Hat Database project

Re: Redhat Database ???

From
Brian Scandale
Date:
Thanks guys!

At 01:41 PM 12/16/02, you wrote:
>Brian Scandale <Brrrian@Excite.com> writes:
>> Does anyone know what the supposed enhancements are to the Redhat database? It is called an enhanced version of
pgSQL7.2.3 by Redhat. 
>
>Most of the value-added is in the GUI tools (RHDB Admin and Visual Explain).
>The server itself contains a few additional bugfixes beyond what's in
>the standard 7.2.3 release, but nothing earthshaking AFAIR.
>
>> Can't seem to find specifics on the Redhat site.
>
>Not sure where you looked, but the primary public page for RHDB is
>
>http://sources.redhat.com/rhdb/
>
>                        regards, tom lane
>                        Red Hat Database project


Apache and Postgres modules

From
Brian Scandale
Date:
Someone is building a Linux/Apache/Postgres/ColdFusion box and is asking me if he should compile the Postgres modules
inwith Apache... 

I have always just downloaded binaries and used the RPM tool with RedHat... Perhaps he is trying to build pg7.3 ???

Is it necessary to compile in support to Apache... ColdFusion is doing all the database work I think.

Thanks,
Brian


Re: Apache and Postgres modules

From
Aarni Ruuhimäki
Date:
Hi !

I have a LinuxRH7.3/Apache1.3.27/Postgres7.2/ColdFusion5.0ProLinux box. And
some experience with this stuff. I will gladly help anyhow I can.

For starters, I installed a custom ( i.e. 'hand-picked' packs ) from RH 7.3
distro cd:s, nothing fancy, just leave out anything you dare and choose the
essentials. And ofcourse Apache, Pg + their devels, gcc etc. and other libs
for compiling various components. Then install cf and verify it's ok and
running. Upgrading to pg 7.3 should be no problem, nor absolutely necessary
if all db-work is going to be via cf. Then it really depends on cf-code and
cf-server settings + perhaps some adjustment to pg-settings and start
swithces and naturally apache settings, as cf is, i'm afraid, quite a monster
when it comes to memory usage etc.

First thing to do, after installing everything, is to register your box in RHN
and update everything - kernel, apache + other packs. Unless you want to do
this by hand.

What kind of site ? How much traffic expected ? Hardware ? How many dbs (
their size ? ) and maybe virtual domains ?

Best regards,

aarni





On Tuesday 17 December 2002 07:22 pm, you wrote:
> Someone is building a Linux/Apache/Postgres/ColdFusion box and is asking me
> if he should compile the Postgres modules in with Apache...
>
> I have always just downloaded binaries and used the RPM tool with RedHat...
> Perhaps he is trying to build pg7.3 ???
>
> Is it necessary to compile in support to Apache... ColdFusion is doing all
> the database work I think.
>
> Thanks,
> Brian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



Re: Apache and Postgres modules

From
Aarni Ruuhimäki
Date:
Hi !

Yes, I mean no, I did not compile Apache. Just rpm and then some tuning.

Building this kind of box by hand and heart is not so easy task, take my word
for it. Unless, of course, you are a guru.

Best regards,

aarni


On Tuesday 17 December 2002 09:10 pm, you wrote:
> Hi Aarni, thanks for replying.... but, I'm still confused... my primary
question was:
> >> Someone is building a Linux/Apache/Postgres/ColdFusion box and is asking
> >> me if he should he compile the Postgres modules in with Apache...
>
> So... you are saying that you did not compile Apache?
>
> thanks,
> Brian
>
> At 10:19 AM 12/17/02, Aarni Ruuhimäki wrote:
> >Hi !
> >
> >I have a LinuxRH7.3/Apache1.3.27/Postgres7.2/ColdFusion5.0ProLinux box.
> > And some experience with this stuff. I will gladly help anyhow I can.
> >
> >For starters, I installed a custom ( i.e. 'hand-picked' packs ) from RH
> > 7.3 distro cd:s, nothing fancy, just leave out anything you dare and
> > choose the essentials. And ofcourse Apache, Pg + their devels, gcc etc.
> > and other libs for compiling various components. Then install cf and
> > verify it's ok and running. Upgrading to pg 7.3 should be no problem, nor
> > absolutely necessary if all db-work is going to be via cf. Then it really
> > depends on cf-code and cf-server settings + perhaps some adjustment to
> > pg-settings and start swithces and naturally apache settings, as cf is,
> > i'm afraid, quite a monster when it comes to memory usage etc.
> >
> >First thing to do, after installing everything, is to register your box in
> > RHN and update everything - kernel, apache + other packs. Unless you want
> > to do this by hand.
> >
> >What kind of site ? How much traffic expected ? Hardware ? How many dbs (
> >their size ? ) and maybe virtual domains ?
> >
> >Best regards,
> >
> >aarni
> >
> >On Tuesday 17 December 2002 07:22 pm, you wrote:
> >> Someone is building a Linux/Apache/Postgres/ColdFusion box and is asking
> >> me if he should compile the Postgres modules in with Apache...
> >>
> >> I have always just downloaded binaries and used the RPM tool with
> >> RedHat... Perhaps he is trying to build pg7.3 ???
> >>
> >> Is it necessary to compile in support to Apache... ColdFusion is doing
> >> all the database work I think.
> >>
> >> Thanks,
> >> Brian
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 4: Don't 'kill -9' the postmaster
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >http://www.postgresql.org/users-lounge/docs/faq.html