Re: minimum hardware for Postgresql Install

Michael wrote:

Whats the minimum hardware anyone has installed Postgresql on ?
Someone is thowing out some old pc's and thought I might make use of
one.

I'm running PostgreSQL 7.1.2. on a very ancient Pentium 120 Mhz with 64
Mb RAM and it's running just fine. Though I have to admit that building
in a new SCSI hard disk in stead of the old IDE harddisk boosted
performance. I thought that PostgreSQL runs even with as little as 32 Mb
RAM in the system, though you have to pay a performance price for that.

Regards,

Nils

--
Alles van waarde is weerloos
Lucebert

On Tue, 7 Aug 2001, Frank Joerdens wrote:

On Tue, Aug 07, 2001 at 08:25:49PM +1000, Michael wrote:

Whats the minimum hardware anyone has installed Postgresql on ?
Someone is thowing out some old pc's and thought I might make use of
one.

I tried once to compile some 6.x.x version of Postgresql on a 486SX with
33 Mhz and 8 MB RAM. This was a little too painful I thought to be
considered OK. Anything better than that (more RAM in particular) should
work though (my experience). A 486DX 66 with 16 MB worked fine for me.

You should probably compile it with a better machine, then you can run it
in your low-end machine. Remember to specify the correct machine-type
flags for gcc.

- Einar Karttunen

On Tue, Aug 07, 2001 at 01:48:40PM +0300, Einar Karttunen wrote:

On Tue, 7 Aug 2001, Frank Joerdens wrote:

On Tue, Aug 07, 2001 at 08:25:49PM +1000, Michael wrote:

Whats the minimum hardware anyone has installed Postgresql on ?
Someone is thowing out some old pc's and thought I might make use of
one.

I tried once to compile some 6.x.x version of Postgresql on a 486SX with
33 Mhz and 8 MB RAM. This was a little too painful I thought to be
considered OK. Anything better than that (more RAM in particular) should
work though (my experience). A 486DX 66 with 16 MB worked fine for me.

You should probably compile it with a better machine, then you can run it
in your low-end machine. Remember to specify the correct machine-type
flags for gcc.

True.

I've managed to compile and install it successfully on a P90 with 96MB of RAM.

Michael <mwaples%waples.net@interlock.lexmark.com> on 08/07/2001 06:25:49 AM

To: pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] minimum hardware for Postgresql Install

Whats the minimum hardware anyone has installed Postgresql on ?
Someone is thowing out some old pc's and thought I might make use of
one.

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

http://www.postgresql.org/search.mpl

Using RPM's I managed to run it on a very slow 486
I think it was 25mhz
The bigger problem is actually installing Linux and getting obsolete memory
if you need more
It's perfectly feasible if your data is not too big

MC.

--

NOTICE: The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential. If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.

Hi all,

Some of you dream of that, I just had nigthmare with that :-) So it's the first
draft of
the OpenLDAP/PostgreSQL HOWTO and it is available at the following URI:

http://www.samse.fr/GPL/

It was really hard to have it work but nothing impossible, I just write the howto

so there probably some miss or fault. I will review it in some days after a
submit
to the OpenLDAP team to have some patch integration. This howto will also be
submitted to the LDP.

Justin I think you can update your buggy link :-)

On Tue, 7 Aug 2001, Nils Zonneveld wrote:

I'm running PostgreSQL 7.1.2. on a very ancient Pentium 120 Mhz with 64
Mb RAM and it's running just fine. Though I have to admit that building
in a new SCSI hard disk in stead of the old IDE harddisk boosted
performance. I thought that PostgreSQL runs even with as little as 32 Mb
RAM in the system, though you have to pay a performance price for that.

I have 7.1.2 running on a 486/33 board with a Pentium/83 OD and 32mb ram.
It performs it's limited duties quite well considering the hardware behind
it.

Hi Gilles,

That's cool. Was hoping you'd figure it out!

Just updated the buggy link to point to your new HOWTO :

http://techdocs.postgresql.org/oresources.php#ldap

:-)

Regards and best wishes,

Justin Clift

Gilles DAROLD wrote:

Hi all,

Some of you dream of that, I just had nigthmare with that :-) So it's the first
draft of
the OpenLDAP/PostgreSQL HOWTO and it is available at the following URI:

http://www.samse.fr/GPL/

It was really hard to have it work but nothing impossible, I just write the howto

so there probably some miss or fault. I will review it in some days after a
submit
to the OpenLDAP team to have some patch integration. This howto will also be
submitted to the LDP.

Justin I think you can update your buggy link :-)

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

http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Hi there!

Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?

[]s, Fernando Lozano

Fernando Lozano <fsl@centroin.com.br> writes:

Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?

FWIW, while a version for RHL 6.2 makes sense because of glibc issues
(and other libraries), the supported rpm format for RHL 6.2 is v4.
Erratas (you have applied those, right? ;) also come in that format.

--
Trond Eivind Glomsr�d
Red Hat, Inc.

On Sunday 19 August 2001 22:10, Fernando Lozano wrote:

Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?

Yes, once I have enough hard drives to have another system image installed.
Due to several other issues, I won't be using either a VMware or similar
system, nor do I dual-boot multiple distributions. I prefer having about a
3GB drive for just development -- and I currently do not have a Red Hat 6.2
system installed.

You certainly ARE welcome to install RPM 3.0.5 or above on your own RH 6.2
box and rebuild the source RPM -- but I cannot at present do that.

And, once a Red Hat 7.2, or 8.0, or whatever Red Hat comes out with next
materializes, I will likely migrate my servers to it as well.

My apologies.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Hi Trond,

Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?

FWIW, while a version for RHL 6.2 makes sense because of glibc issues
(and other libraries), the supported rpm format for RHL 6.2 is v4.
Erratas (you have applied those, right? ;) also come in that format.

I have not aplied those. I don't know what I did wrong, but I broke two
systems (had to reinstall) when trying to update the rpm subsystem. But
that's my fault, I'll solve this eventually.

I'd like to have updated rpms for 6.2 for a number of packages and I
wonder if Red Hat or someone else will provide these or not. I am not
talking just about PostgreSQL now. It is not nice to provide support for
a number of customers without Unix and Linux culture and having to
recompile everything from sources. :-(

[]s, Fernando Lozano

On Mon, 20 Aug 2001, Fernando Lozano wrote:

Hi Trond,

Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using
the older glibc and rpm format?

FWIW, while a version for RHL 6.2 makes sense because of glibc issues
(and other libraries), the supported rpm format for RHL 6.2 is v4.
Erratas (you have applied those, right? ;) also come in that format.

I have not aplied those. I don't know what I did wrong, but I broke two
systems (had to reinstall) when trying to update the rpm subsystem. But
that's my fault, I'll solve this eventually.

It's documented on the support site how to do it... upgrade the rpms (rpm,
popt, db3), do a "rpm --rebuild".

I'd like to have updated rpms for 6.2 for a number of packages and I
wonder if Red Hat or someone else will provide these or not.

We typically don't upgrade an existing distribution unless there is a
compelling reason to do so - security or serious bugs affecting many
users, typically. And when we do that, we prefer to apply the fix to the
old version to upgrade.

Reasons? Testing, integration, stability. We want e.g "RHL 6.2" to be
fairly stable in what it means, to make development easy (don't introduce
new libraries which not all users have) and support possible. Also, we
hopefully avoid introducing new bugs this way. And just testing the
component isn't sufficient - integration is also an issue. 20 various
components which users have or haven't upgraded make for a big number of
combinations.

I am not talking just about PostgreSQL now. It is not nice to provide
support for a number of customers without Unix and Linux culture and
having to recompile everything from sources. :-(

If you want newer packages, get Red Hat Linux 7.1.

--
Trond Eivind Glomsr�d
Red Hat, Inc.

On Monday 20 August 2001 18:09, Trond Eivind Glomsr�d wrote:

I am not talking just about PostgreSQL now. It is not nice to provide
support for a number of customers without Unix and Linux culture and
having to recompile everything from sources. :-(

If you want newer packages, get Red Hat Linux 7.1.

For some folks with older machines, 6.2 is as high as it goes. Ever install
7.1 on a 486? This fellow is in Brazil -- and may not have even a Pentium,
for all we know.

PostgreSQL 7.1.x, for the record, runs (well, it jogs at least) on even an
old 486DX4-100 I had RH 6.2 installed on (48MB RAM). (That machine went on
the mission field....)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

If you want newer packages, get Red Hat Linux 7.1.

For some folks with older machines, 6.2 is as high as it goes.
Ever install
7.1 on a 486? This fellow is in Brazil -- and may not have even
a Pentium,
for all we know.

For the record, machine type isn't the only reason some folks cannot move to
7.X. My case, for example, is one where my company bought cheap UPS's for
use with my Linux servers, and even the newest version of the software for
auto-shutdown of the server doesn't support Redhat newer than 6.2. Others
can probably give other examples, but suffice to say, many of us have no
choice but to put newer RPM's or compiled source on top of a RH 6.X base,
and have to face the question of how new a version of various software we
can get away with and not mess up our system.

--------------------------------
Karen Ellrick
S & C Technology, Inc.
1-21-35 Kusatsu-shinmachi
Hiroshima 733-0834 Japan
(from U.S. 011-81, from Japan 0) 82-293-2838
--------------------------------

--- Lamar Owen <lamar.owen@wgcr.org> wrote:

On Monday 20 August 2001 18:09, Trond Eivind Glomsr���d wrote:

I am not talking just about PostgreSQL now. It is not nice

to provide

support for a number of customers without Unix and Linux

culture and

having to recompile everything from sources. :-(

If you want newer packages, get Red Hat Linux 7.1.

For some folks with older machines, 6.2 is as high as it goes.
Ever install
7.1 on a 486? This fellow is in Brazil -- and may not have
even a Pentium,
for all we know.

For the record, Red Hat 7.1 with the slim 2.4 kernel runs very
smoothly on my old Pentium 133 running on 48 MB RAM. It
performs the duties of firewall, SMTP server, and DNS server
while only using 4 MB of swap! PostgreSQL 7.1 should be no
problem.

Brent

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

I am really, really sorry to hear that from you, Lamar.

You alway seemed to me a very reasonable and smart person, but to suggest
that just because Fernando Lozano is in Brazil he "may not have even a
Pentium" is, to say the least, a terrible proof of ignorance and prejudice.

For your information, we, brazilians, do not have to fight lions on the
street or whatever other things you may imagine. Actually, we are doing very
well as it comes to tecnology. I, for instance, work everyday on a Pentium
III 1Ghz with 256MB of memory and a 17 inches monitor.

Sorry for posting a mail like this to the list, but I just couldn't help
myself.

Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informa��o
E-mail: carlosz@dbserver.com.br
Fone: (51) 3342-8055
Fax: (51) 3342-4838

-----Original Message-----
From: Lamar Owen [mailto:lamar.owen@wgcr.org]
Sent: segunda-feira, 20 de agosto de 2001 21:28
To: Trond Eivind Glomsr�d; Fernando Lozano
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] New RPMS ?

On Monday 20 August 2001 18:09, Trond Eivind Glomsr�d wrote:

I am not talking just about PostgreSQL now. It is not nice to provide
support for a number of customers without Unix and Linux culture and
having to recompile everything from sources. :-(

If you want newer packages, get Red Hat Linux 7.1.

For some folks with older machines, 6.2 is as high as it goes. Ever install

7.1 on a 486? This fellow is in Brazil -- and may not have even a Pentium,
for all we know.

PostgreSQL 7.1.x, for the record, runs (well, it jogs at least) on even an
old 486DX4-100 I had RH 6.2 installed on (48MB RAM). (That machine went on
the mission field....)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

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

http://www.postgresql.org/search.mpl

Hi Carlos,

For your information, we, brazilians, do not have to fight lions on the
street or whatever other things you may imagine. Actually, we are doing very
well as it comes to tecnology. I, for instance, work everyday on a Pentium
III 1Ghz with 256MB of memory and a 17 inches monitor.

Come'on Carlos, aren't you afraid of the canibal indians next to your
house? ;-))

Well, I see all around the world there are projects like LTSP which aim
to provide support for Linux and newer apps on old hardware. It may look
very cheap to buy one migh-end PC alone, but getting 20 to 50 of them to
make a working school lab is another entirelly different story.

[]s, Fernando Lozano

On Tuesday 21 August 2001 15:16, Carlos Felipe Zirbes wrote:

You alway seemed to me a very reasonable and smart person, but to suggest
that just because Fernando Lozano is in Brazil he "may not have even a
Pentium" is, to say the least, a terrible proof of ignorance and prejudice.

Whoa.

I intended absolutely NO offense with my posting of that comment. I have
missionary friends in Brazil, Bolivia, and Peru (amongst other places), and
they constantly talk about the slower machines they have to deal with, thus
the comment.

My sincere apologies for any offense, as none was intended whatsoever.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11