question

On Friday 19 January 2001 20:28, Cameron Laird wrote:

I am a Comp. Sci. student at Ryerson Polytechnic University in toronto. I

am in the midst of a software engineering project that involves the
development of a (possibly) relational database on a RedHat 6.2 development
environment, we are coding in C. now my question is, how closely related
are Postgre and MySQL, and are the necessary PostgreSQL libraries included
in RedHat 6.2?

AFAIK, PostgreSQL and MySQL are from totally different codebases (never
shared any code). PostgreSQL is BSD license and MySQL is now GNU GPL. They
both implement SQL to varying levels of conformance. PostgreSQL has some
object-oriented features, like table inheritance. Try them both and see what
you like, but I think you'll find PostgreSQL more interesting. For instance,
Postgres can load C functions from shared objects and use them as functions
in SQL, user defined aggregates, procedural language call handlers, and to
create user defined data types (and possibly other things). The 7.1 beta has
implemented some great new features, like write-ahead logging (WAL) and
complete support for SQL table joins, among other things. A C project can do
a lot with Postgres.

RPM packages of PostgreSQL are available at:

http://www.postgresql.org/sites.html

You'll have to check redhat.com or do an rpm query to see if it should be or
is installed on RedHat 6.2.

thanks,

Cameron Laird

----------------------------------------
Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description:
----------------------------------------

--
-------- Robert B. Easter reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------

"Robert B. Easter" <reaster@comptechnews.com> writes:

You'll have to check redhat.com or do an rpm query to see if it should be or
is installed on RedHat 6.2.

I believe redhat does ship Postgres RPMs, but they're PG version
6.5.something, which is pretty old --- ie, fewer features and more bugs
than later versions. You really ought to install PG 7.0.3 (use RPMs
from www.postgresql.org) or if you're feeling bleeding edge, try out the
7.1 beta distribution.

regards, tom lane

Tom Lane wrote:

"Robert B. Easter" <reaster@comptechnews.com> writes:

You'll have to check redhat.com or do an rpm query to see if it should be or
is installed on RedHat 6.2.

I believe redhat does ship Postgres RPMs, but they're PG version
6.5.something, which is pretty old --- ie, fewer features and more bugs
than later versions. You really ought to install PG 7.0.3 (use RPMs
from www.postgresql.org) or if you're feeling bleeding edge, try out the
7.1 beta distribution.

RH 6.2 shipped with PostgreSQL 6.5.3, RPM release 6. PostgreSQL 7.0 was
in beta at the time.

PostgreSQL 7.0 was first shipped as 7.0.2, release 17, in RedHat 7.0.

RPMS for PostgreSQL 7.0.3 for RedHat 6.2 are available on
ftp.postgresql.org, as Tom mentioned, in
/pub/binary/v7.0.3/RPMS/RedHat-6.2

The upgrade from 6.5.3 RPM to 7.0.3 RPM is not the easiest in the world
-- please be sure to read the README.rpm-dist file in the main
postgresql RPM.

Also, you will need to read this file to see which packages you want --
for a full client-server install, install postgresql and
postgresql-server. Pick and choose the other clients and development
RPM's you need from there.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Ned Lilly wrote:

Great Bridge makes PostgreSQL 7.0.3 RPMs for 8 different Linux distros
at http://www.greatbridge.com/download ...

For the record (with permission of Great Bridge a few months back), I
want to thank Great Bridge for helping with the development of the
current Official RPMs, including financial assistance (:-)), servers
running the distributions in question for building/testing, and top-tier
professional feedback (when they say this release has been
professionally QA tested, they _mean_ it!) on my little project.

Kudos to GreatBridge!
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Great Bridge makes PostgreSQL 7.0.3 RPMs for 8 different Linux distros
at http://www.greatbridge.com/download ...

Tom Lane wrote:

"Robert B. Easter" <reaster@comptechnews.com> writes:

You'll have to check redhat.com or do an rpm query to see if it should be or
is installed on RedHat 6.2.

I believe redhat does ship Postgres RPMs, but they're PG version
6.5.something, which is pretty old --- ie, fewer features and more bugs
than later versions. You really ought to install PG 7.0.3 (use RPMs
from www.postgresql.org) or if you're feeling bleeding edge, try out the
7.1 beta distribution.

regards, tom lane

--
----------------------------------------------------
Ned Lilly e: ned@greatbridge.com
Vice President w: www.greatbridge.com
Evangelism / Hacker Relations v: 757.233.5523
Great Bridge, LLC f: 757.233.5555

I've just moved from Redhat to Mandrake.

But do I have to use the Mandrake RPM? Doesn't the standard RPM work on
mandrake?

What is the difference between these two RPM's?

I'd hate to wait for the Mandrake specific RPM for every release.

Poul L. Christiansen

On Tue, 23 Jan 2001, Lamar Owen wrote:

I'd hate to wait for the Mandrake specific RPM for every release.

I've been building the Mandrake RPMs, and there is currently a small
problem in the build which I haven't had time to pursue (yet). The
Mandrake distro should be available on the postgresql.org ftp site very
soon after release.

- Thomas

Poul Laust Christiansen writes:

I've just moved from Redhat to Mandrake.

But do I have to use the Mandrake RPM? Doesn't the standard RPM work on
mandrake?

In general, RPMs only work on systems that are the same as the one they
were built on, for various degrees of "same". If you're not picking up
the RPMs from your distributor or you're sure that the builder used the
same version as you have, it's always prudent to rebuild from the source
RPM. That should work, unless the package spec makes some unportable
assumptions, such as different file system layouts. But that is often
only an annoyance, not a real problem.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

On Tue, 23 Jan 2001, Peter Eisentraut wrote:

In general, RPMs only work on systems that are the same as the one they
were built on, for various degrees of "same". If you're not picking up
the RPMs from your distributor or you're sure that the builder used the
same version as you have, it's always prudent to rebuild from the source
RPM. That should work, unless the package spec makes some unportable
assumptions, such as different file system layouts. But that is often
only an annoyance, not a real problem.

While trying to get the FrontPage Extensions installed on a RedHat/Apache
system I ran into to different version numbering systems between RedHat
and Mandrake. Major pain. One called for perl 5.6.0-xxx and the other
perl 5.60-xxx. After several hours of screwing around with it I took a
break. Fortunately before I spent any more time on it the client I was
going to do it for decided to not run them with Apache.

I'm glad to see GreatBridge will be providing RPM's for many
distributions. Though I do tend to re-compile from source I've found that
those mdk's don't work too good with RHL.

Rod
--

"Roderick A. Anderson" wrote:

On Tue, 23 Jan 2001, Peter Eisentraut wrote:

RPM. That should work, unless the package spec makes some unportable
assumptions, such as different file system layouts. But that is often
only an annoyance, not a real problem.

I'm glad to see GreatBridge will be providing RPM's for many
distributions. Though I do tend to re-compile from source I've found that
those mdk's don't work too good with RHL.

And I _love_ to get feedback about the nonportable things I do in the
spec files (right, Peter ? :-)).

I am trying (and Great Bridge helped) to get a fully
distribution-independent source RPM working. I am closer than I was --
the same spec file now works on RedHat, Mandrake, Turbo, and (to a
lesser extent) Caldera, and soon will work seamlessly on SuSE. It may
very well work on others. The hooks are there now for SuSE -- just some
fill-in work left to be done.

Portability is hard. C programmers have known this for some time -- but
the RPM specfile doesn't really lend itself to vast portability.
Although, I am learning some real tricks that really help.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Ypu can always use the source to build and install it instead of the RPM.

At 07:18 PM 1/23/2001 +0000, Thomas Lockhart wrote:

Thomas Lockhart (lockhart@alumni.caltech.edu) wrote:

I'd hate to wait for the Mandrake specific RPM for every release.

I've been building the Mandrake RPMs, and there is currently a small
problem in the build which I haven't had time to pursue (yet). The
Mandrake distro should be available on the postgresql.org ftp site very
soon after release.

- Thomas

I use Mandrake 7.2 and since we are talking about mandrake RPMS . . .
The psql application that shipped with 7.2 was not compiled with ncurses
support, so the up-arrow key did not work. Could this be changed
with the next release? I recompiled postgres to upgrade to 7.0.3
(and compile perl support) and when I manually compiled it, the
up arrow worked in psql.
--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------