Thread: Using older machines with PostgreSQL?

Using older machines with PostgreSQL?

From
Paul Ganainm
Date:


Hi all,


At home I have a Windows 1.6 GHz Pentium box which I use for accessing
the internet &c. I have two old machines doing nothing at the moment -
one is a late 486 (60 MHz) and the other is an early Pentium (75 MHz). I
have run Linux on both of these machines in the past.


I would like to set these older machines up to run PostgreSQL and
administer the dbs from the Windows box.


Are there any issues in doing this that I should be aware of (apart from
a speed penalty which I expect to have to pay)?



Paul...


--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Re: Using older machines with PostgreSQL?

From
Peter Childs
Date:

On Mon, 27 Oct 2003, Paul Ganainm wrote:

>
>
>
> Hi all,
>
>
> At home I have a Windows 1.6 GHz Pentium box which I use for accessing
> the internet &c. I have two old machines doing nothing at the moment -
> one is a late 486 (60 MHz) and the other is an early Pentium (75 MHz). I
> have run Linux on both of these machines in the past.
>
>
> I would like to set these older machines up to run PostgreSQL and
> administer the dbs from the Windows box.
>
>
> Are there any issues in doing this that I should be aware of (apart from
> a speed penalty which I expect to have to pay)?
>

    Should not be any problems. If you can get Linux on Postgres will
run. As with any database memory is important (but then memory is cheap) I
would surgest at least 256Mb more is preferable. Switch X windows off
together with any other system services, Just run ssh (to get into the
machine when all else fails) and postgres. Also you may need to be
carefull as many old machines can't hadle disks larger than 6Gb.
    You may wish to stream line everything.

Peter Childs

>
>
> Paul...
>
>
> --
>
> plinehan__AT__yahoo__DOT__com
>
> C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
>
> Please do not top-post.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

Re: Using older machines with PostgreSQL?

From
Tomka Gergely
Date:
2003-10-27 ragyogó napján Paul Ganainm ezt üzente:

>
>
>
> Hi all,
>
>
> At home I have a Windows 1.6 GHz Pentium box which I use for accessing
> the internet &c. I have two old machines doing nothing at the moment -
> one is a late 486 (60 MHz) and the other is an early Pentium (75 MHz). I
> have run Linux on both of these machines in the past.
>
>
> I would like to set these older machines up to run PostgreSQL and
> administer the dbs from the Windows box.
>
>
> Are there any issues in doing this that I should be aware of (apart from
> a speed penalty which I expect to have to pay)?

You must watch the memory usage. With 32MB RAM sometimes, very rarely the
kernel killed apache or postmaster. But with 64 megs and ~200 Mbyte swap
must run without trouble.



--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."


Re: Using older machines with PostgreSQL?

From
Paul Ganainm
Date:
blue.dragon@blueyonder.co.uk says...


> > Are there any issues in doing this that I should be aware of (apart from
> > a speed penalty which I expect to have to pay)?


>     Should not be any problems. If you can get Linux on Postgres will
> run. As with any database memory is important (but then memory is cheap) I
> would surgest at least 256Mb more is preferable.


I think that I have 32 MB on one machine and 48 on the other.


If I install Linux with no GUI (just command line), will PostgreSQL
work, or does it actually require that much RAM?


Paul...


> Peter Childs

--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Re: Using older machines with PostgreSQL?

From
Peter Childs
Date:

On Mon, 27 Oct 2003, Paul Ganainm wrote:

>
> blue.dragon@blueyonder.co.uk says...
>
>
> > > Are there any issues in doing this that I should be aware of (apart from
> > > a speed penalty which I expect to have to pay)?
>
>
> >     Should not be any problems. If you can get Linux on Postgres will
> > run. As with any database memory is important (but then memory is cheap) I
> > would surgest at least 256Mb more is preferable.
>
>
> I think that I have 32 MB on one machine and 48 on the other.
>
>
> If I install Linux with no GUI (just command line), will PostgreSQL
> work, or does it actually require that much RAM?

    Postgres will run. just be careful what you set the buffers to.

Peter

>
>
> Paul...
>
>
> > Peter Childs
>
> --
>
> plinehan__AT__yahoo__DOT__com
>
> C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
>
> Please do not top-post.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>