Re: minimum hardware requirements for small postgres db

Thanks for your advice. It is very interesting you were able to run pg on
a SD card in a RasPi ! In addition to Wolgang's last reply, that
confirms I was misinformed last year when I originally settled on pg as my
1st choice, hsqldb being 2nd choice, but then rejected pg in favour of
hsqldb, as told the former needs stronger hw than I use.

Regarding yours and Gavin's recommendation I change to Linux, I have made
such an investment in Windows ever since it overlayed DOS, use so many
Windows dependant programs, it would be a major investment in time to start
again in Linux.

I have monitored the progress of Linux, particularly Ubuntu over the
decades, and sadly have always found some reason not to change. I stopped
using big desktops years ago due to travel needs, and read a big problem
using Linux on new laptops/nettops was lack of Driver support from
manufacturers ... causing lots of headaches. Recently, I read the change
of 'Desktop' to Unity needs maturing. I do realise open-source encourages
healthy creativity, and so diversity, but just the other week I read
'fragmentation' of Linux into so many flavours causes big problems
supporting Apps.

Another reason your mention of pg on RasPi was so interesting, is I am
thinking to buy something smaller than a Nettop, to use primarily as a
media-streamer to TV, but also be a 'backup computer' in case my Nettop
breaks - as it just has. The choice on ARM hw has to be Linux or the
Android fork. If ARM, I was thinking of the Tegra3 based OUYA, unless a T4
or other faster SoC alternative becomes available. So following the news
on development of Ubuntu for ARM devices with interest.

So as per my last post to Wolfgang, I will install pg once my Nettop
repaired or replaced.

Thanks, Paul

On 21 February 2013 15:00, Matt Musgrove <MMusgrove(at)efji(dot)com> wrote:

> I regularly use PostgreSQL on a system with an Atom processor and 4GB of
> RAM and running CentOS (no problems even on the one box with only 2GB of
> RAM). I have even tinkered with PostgreSQL on a Raspberry Pi with 256 MB of
> RAM running off of an 8 GB SD card.
>
>
>
> I agree with everyone else that moving to Linux will be a wise decision
> both for security and usability.
>
>
>
> HTH,
>
> Matt
>
>
>
> *From:* pgsql-novice-owner(at)postgresql(dot)org [mailto:
> pgsql-novice-owner(at)postgresql(dot)org] *On Behalf Of *Paul Smith
> *Sent:* Wednesday, February 20, 2013 7:50 AM
> *To:* pgsql-novice(at)postgresql(dot)org
> *Subject:* [NOVICE] minimum hardware requirements for small postgres db
>
>
>
> I am having difficulty finding documentation stating the minimum hardware
> requirements to run pg under Windows. (I did look in the FAQ & User Manual)
>
>
>
> I seek an open source RDBMS with close adherance to ANSI standards, good
> free graphic design tools for drawing of the ER Diagram, validation of the
> ERD model, and generation of the SQL required to build the DB.
>
>
>
> I only want to design a few small DB Apps using about 20 tables, for
> single-user offline environment, hopefully runnable on Nettop class
> hardware under WinXP or Win7 32bit.
>
>
>
> I want to access the db via a Forms driven GUI and a Report-writer with
> features comparable to old versions of Access, but preferably also
> open-source.
>
>
>
> If Atom class nettop not sufficient, would like to know the minimum class
> of CPU, RAM, GPU required.
>
>
>
> Thank you in advance for any assistance
> This e-mail transmission, and any documents, files or previous e-mail
> messages attached to it, may contain confidential information. If you are
> not the intended recipient, or a person responsible for delivering it to
> the intended recipient, you are hereby notified that any disclosure,
> distribution, review, copy or use of any of the information contained in or
> attached to this message is STRICTLY PROHIBITED. If you have received this
> transmission in error, please immediately notify us by reply e-mail, and
> destroy the original transmission and its attachments without reading them
> or saving them to disk. Thank you.
>