Re: minimum hardware requirements for small postgres db

On 22/02/13 19:13, Paul Smith wrote:
> 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
> <mailto: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>
> [mailto: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 <mailto: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.
>
>
Microsoft is on the way out: it has already lost the mobile & servers
wars to Linux, and with Metro it is trying hard (& succeeding) in losing
the Laptop&Desktop wars! So Linux is the future. In 20 years Microsoft
will be as well known as CP/M (http://www.digitalresearch.biz/CPM.HTM)
is now - at one stage CP/M was the dominant O/S for business use. I
predict that the start of thedemise of Microsoft will be well
established and common knowledge by Christmas 2014.

So I suggest you have a migration strategy, as pouring more money into
Microsoft is beginning to be counter productive. The Microsoft
ecosystem is already fragmented, if you look carefully. Some major games
companies are already abandoning Microsoft in favour of Linux.

I am typing this on a Linux Laptop from ZaReason:
http://zareason.co.nz/Verix-530.html
You could look at: http://zareason.com

I currently use the Mate Desktop Environment in Fedora 17.

Cheers,
Gavin